Can I vibe code FirstPromoter?

Build a custom affiliate tracking and management system using Next.js (App Router), Supabase (PostgreSQL), and Stripe Webhooks.

1. DATA MODEL:
- `affiliates`: id, user_id, ref_code, custom_discount_code, payout_email, unpaid_balance_cents, total_paid_cents, created_at.
- `clicks`: id, affiliate_id, ip_hash, user_agent, landing_page, created_at.
- `referrals`: id, affiliate_id, stripe_customer_id, stripe_charge_id, sale_amount_cents, commission_amount_cents, status (pending, approved, refunded, paid), created_at.
- `payouts`: id, affiliate_id, amount_cents, payout_method, reference_id, created_at.

2. TRACKING & ATTRIBUTION:
- Create a lightweight JS snippet (`/public/track.js`) that captures `?via=CODE` from the URL query parameter.
- Store `via` code in `localStorage` and a 60-day HTTP-only cookie.
- Send a beacon hit to `/api/track/click` to log unique hits per IP hash.
- Pass the affiliate code to Stripe Checkout metadata (`metadata: { ref_code: 'CODE' }`) or attach it as a custom field on customer creation.

3. WEBHOOK HANDLING:
- `/api/webhooks/stripe`: Listen for `charge.succeeded` and `invoice.payment_succeeded` events.
- Extract `ref_code` from metadata or lookup by customer ID.
- Calculate commission (default 20% of net sale). Insert record into `referrals` with status `pending`.
- Listen for `charge.refunded` or `customer.subscription.deleted`. If a refund occurs, update referral status to `refunded` and adjust pending affiliate balance.

4. AFFILIATE DASHBOARD:
- Protected UI for affiliates to view total clicks, conversions, pending commissions, and historical payouts.
- Allow affiliates to edit their payout email address.

5. ADMIN PORTAL & PAYOUT EXPORT:
- UI for store admins to approve pending commissions older than 30 days (holding period for refunds).
- Action button to generate and download a PayPal MassPay and Wise API compatible batch CSV file containing `email`, `amount`, and `currency` for all approved unpaid balances.
- Mark balances as `paid` upon CSV export confirmation.

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