Can I vibe code TrueProfit?

Build a custom e-commerce net profit analytics dashboard in Next.js, Tailwind CSS, and Supabase.

1. DATA MODEL:
Create PostgreSQL tables in Supabase:
- `orders`: order_id, created_at, total_price, total_tax, total_shipping, gross_cost (COGS), gateway_fee, status.
- `line_items`: item_id, order_id, sku, quantity, price, cost_per_item.
- `cogs`: sku, cost, effective_date.
- `ad_spend`: platform (meta, google, tiktok), date, spend, impressions, clicks.
- `custom_expenses`: id, category, amount, recurring_interval, date.

2. INTEGRATIONS & DATA INGESTION:
- Implement a Webhook Route (`/api/webhooks/shopify`) to process `orders/create` and `orders/fulfilled`. Calculate net sales (total_price minus tax and shipping). Fetch line item costs from the `cogs` table and sum them to assign `gross_cost`.
- Implement a scheduled daily cron job (`/api/cron/sync-ads`) using Next.js Route Handlers. Use native fetch to call Meta Graph API, Google Ads API, and TikTok Marketing API endpoints to pull yesterday's daily ad spend per account. Insert records into `ad_spend`.

3. PROFIT ENGINE LOGIC:
- Create a server action to compute Net Profit for any selected date range using the formula: Net Profit = Net Sales - COGS - Payment Gateway Fees (e.g. 2.9% + $0.30) - Ad Spend - Custom Expenses.
- Calculate key performance indicators: Net Margin %, ROAS (Gross Sales / Ad Spend), Average Order Value (AOV), and baseline Customer Lifetime Value (LTV).

4. UI COMPONENTS:
- Build a main dashboard layout with top-level KPI summary cards (Net Profit, Gross Revenue, Ad Spend, Net Margin %).
- Render a daily breakdown time-series chart using Recharts showing Gross Revenue vs. Net Profit over time.
- Build a product margin table displaying profitability breakdown grouped by SKU.

5. SECURITY & RESILIENCE:
- Secure incoming webhook routes using HMAC validation on the `X-Shopify-Hmac-Sha256` request header.
- Encrypt external API tokens stored in environment variables or database configurations.
- Implement exponential backoff handling to manage ad platform API rate limits during data ingestion.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs