Can I vibe code Superfiliate?

1. SYSTEM ARCHITECTURE & DATA MODEL
Build a custom creator affiliate engine for Shopify using Next.js 14, Supabase (PostgreSQL + Auth), and the Shopify Admin GraphQL API.
Data Model:
- creators: id, name, handle, email, shopify_discount_code_id, discount_code, commission_rate (default 0.15), paypal_email, bio, avatar_url.
- referral_sessions: id, creator_id, landing_slug, ip_address, user_agent, created_at.
- conversions: id, creator_id, shopify_order_id, order_total, commission_amount, status (pending, paid, cancelled), created_at.

2. CORE FUNCTIONALITY
- Dynamic Creator Route (/c/[handle]): Fetch creator metadata from Supabase. Render a co-branded header (avatar, custom bio, top recommended product cards). Set a 30-day HTTP-only attribution cookie with creator_id. Redirect user to the cart with the creator's Shopify discount code pre-applied via checkout URL (/discount/CODE?redirect=/cart).
- Webhook Listener (/api/webhooks/shopify/orders-paid):
  Verify Shopify HMAC signature. Extract order_id, subtotal, discount_codes, and note_attributes. Match applied discount code against the creators table. Calculate commission (Subtotal * commission_rate). Insert record into conversions with status 'pending'. Ensure idempotency by checking existing shopify_order_id.
- Refund Listener (/api/webhooks/shopify/orders-cancelled):
  Verify HMAC signature. Mark matching conversion record status as 'cancelled'.
- Creator Portal (/portal):
  Supabase magic link authentication. Displays total link clicks, total conversion count, unpaid balance, and historical earnings table. Allows updating bio and PayPal payout email.
- Admin Portal (/admin):
  Form to create new creators which automatically generates a matching discount code in Shopify via Admin GraphQL API (`discountCodeBasicCreate`). Includes a button to export pending conversions as a PayPal MassPay CSV.

3. EDGE CASES & FAILURE MODES
- Duplicate webhooks: Always check if shopify_order_id exists in conversions before writing.
- Leak Prevention: Flag conversions if discount code was used without a corresponding referral_session cookie created in the past 30 days.
- Shopify Rate Limits: Wrap Admin API calls in an exponential backoff retrier.

4. OUT OF SCOPE
Tax form collection (1099s), native bank ACH transfers, and automated SMS marketing triggers.

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