Can I vibe code LoyaltySurf?

Build a lightweight custom referral program backend and widget using Next.js (App Router), Supabase (PostgreSQL), and Tailwind CSS.

1. DATA MODEL:
Create tables in Supabase:
- `advocates`: id (uuid), email (text, unique), ref_code (text, unique), created_at.
- `referrals`: id (uuid), advocate_id (fk advocates), referred_email (text), store_order_id (text), order_amount (numeric), status ('pending', 'approved', 'rejected'), created_at.
- `rewards`: id (uuid), advocate_id (fk advocates), coupon_code (text), target_amount (numeric), issued_at.

2. FRONTEND SCRIPT & WIDGET:
- Create a light script script.js that runs on store load: Parse `?ref=CODE` from URL. Store `ref_code` in a first-party cookie expiring in 30 days.
- Create a simple Tailwind widget component embedded on the store's Order Status / Account page. Allow users to enter their email to fetch or create their unique `ref_code` and view earned rewards.

3. WEBHOOK RECEIVER:
- Build an API route `/api/webhooks/order-created` to receive store checkout payloads (e.g. Shopify/Stripe).
- Extract the referral cookie value or order note attribute (`ref_code`) and customer email.
- Look up the `ref_code` in `advocates`. If found, insert a record into `referrals` with status 'pending'.

4. FRAUD CHECKS & REWARD FULFILLMENT:
- Reject referral if `advocate.email` matches `referred_email` or has the same local-part prefix.
- Create a scheduled job (Cron route `/api/cron/process-rewards`) that runs daily:
  - Query `referrals` where status is 'pending' and age > 14 days (holding period for refunds).
  - If order remains valid, update status to 'approved'.
  - Call store API (e.g. Shopify GraphQL `discountCodeBasicCreate`) to create a single-use 15% off discount code.
  - Save to `rewards` and send an automated transactional email via Resend API to the advocate.

5. OUT OF SCOPE:
Multi-tier affiliate networks, physical gift card integrations, and gamified tier badges.

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