Can I vibe code Glew.io?

Build a full-stack ecommerce analytics dashboard in Next.js (App Router) with Tailwind CSS and Supabase (PostgreSQL).

1. DATA MODEL:
Create PostgreSQL tables:
- `orders` (id, store_id, shopify_id, customer_id, total_price, subtotal_price, total_tax, discount_amount, currency, created_at)
- `order_items` (id, order_id, product_id, variant_id, title, quantity, price)
- `customers` (id, email, first_name, last_name, total_spent, orders_count, first_order_at, last_order_at)
- `ad_spend` (id, platform, campaign_name, spend, impressions, clicks, date)

2. ETL & INTEGRATION LOGIC:
- Write a Next.js Route Handler `/api/sync/shopify` that accepts Shopify REST API credentials and performs incremental syncs of orders and customers.
- Handle rate limits by parsing `X-Shopify-Shop-Api-Call-Limit` headers and implementing exponential backoff.
- Implement a webhook listener at `/api/webhooks/shopify/orders-create` to update Postgres in real time.

3. CALCULATIONS & METRICS ENGINE:
- Write SQL views for key metrics: Net Revenue, Average Order Value (AOV), Repeat Customer Rate, and 30/60/90-day LTV.
- Write a cohort SQL query that groups customers by sign-up month and displays retention percentage over 12 months.
- Implement RFM (Recency, Frequency, Monetary) segmentation that tags customers as 'VIP', 'At Risk', or 'Lost'.

4. DASHBOARD UI:
- Build a main dashboard page using Recharts displaying total revenue, AOV, LTV, and blended ROAS (Revenue / Total Ad Spend).
- Build a Product Velocity page showing top products sorted by unit velocity and revenue generation.
- Build a Customer Cohort Matrix component using a colored heat-map table grid.

5. FAILURE MODES & OUT OF SCOPE:
- Gracefully handle API connection failures by storing sync log errors in a `sync_logs` table.
- Out of scope: Multi-tenant billing, complex attribution modeling logic, and real-time inventory multi-warehouse routing.

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