Can I vibe code Talkable?

Build an enterprise-grade referral marketing backend and Shopify integration using Next.js App Router, Supabase PostgreSQL, and the Shopify Admin GraphQL API.

1. DATA MODEL:
Create tables for:
- Advocates: id, email, shopify_customer_id, share_code (unique string), created_at.
- ReferredFriends: id, advocate_id, friend_email, status ('pending', 'converted', 'flagged'), conversion_order_id, created_at.
- Rewards: id, advocate_id, discount_code, reward_type ('percentage', 'fixed'), used_at.
- FraudLogs: id, advocate_id, friend_email, ip_address, device_fingerprint, reason.

2. CORE FUNCTIONALITY:
- Public API Route `/api/referral/share-link`: Generates or fetches a unique share URL (e.g., `store.com?ref=CODE`) for a given customer email.
- Frontend JS Widget: Embeddable script for post-purchase pages. Displays referral link and social share buttons.
- Attribution Landing Page Script: Captures `ref` query params, sets a 30-day first-party cookie containing `advocate_share_code`.
- Shopify Webhook Handler (`orders/paid`): Parses customer email, order total, and cookie/discount code used. Matches `advocate_share_code`. If valid, triggers reward creation.
- Reward Generator: Calls Shopify GraphQL API `discountCodeBasicCreate` to generate a dynamic 20% off coupon code for the advocate once friend order is verified.

3. FRAUD DETECTION & EDGE CASES:
- Block self-referrals: Flag if friend email matches advocate email, or if friend IP matches advocate IP within 24 hours.
- Store browser device fingerprint from frontend script and flag if advocate and friend share identical fingerprints.
- Listen for `orders/cancelled` webhooks: Revoke pending rewards if referred order is canceled before fulfillment threshold.

4. OUT OF SCOPE:
- Native transactional email sending (emit webhooks to Klaviyo instead).
- In-app visual WYSIWYG template editor.
- Multi-currency referral payouts.

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