Can I vibe code Gratisfaction?

Build a self-hosted loyalty and referral platform for a Shopify/WooCommerce store using Next.js (App Router), Supabase (PostgreSQL), and Tailwind CSS. The solution must contain:

1. DATA MODEL:
- Customer: id, external_store_customer_id, email, points_balance, referral_code, created_at.
- PointsLedger: id, customer_id, points_change, reason (PURCHASE, REDEMPTION, REFERRAL_BONUS), reference_id, created_at.
- RewardTier: id, name, points_required, discount_value, discount_type (FIXED, PERCENTAGE).
- Referral: id, referrer_id, referee_email, status (PENDING, COMPLETED), order_id.

2. WEBHOOK & INTEGRATION ENGINE:
- Express/Next route handler for 'orders/paid' webhooks.
- Parse webhook: Verify HMAC signature. Check if order was already processed (idempotency).
- Calculate earned points: 1 point per $1 spent. Insert record into PointsLedger and update Customer balance.
- Referral check: Read cart/order attributes for 'ref_code'. If present, attribute purchase to referrer, update Referral status to COMPLETED, and award bonus points to both referrer and referee.

3. REDEMPTION & COUPON GENERATION:
- Endpoint for customer to redeem points for a reward.
- Deduct points transactionally in Supabase.
- Make REST/GraphQL API call to Shopify/WooCommerce API to create a unique single-use discount code corresponding to the selected RewardTier.
- Return discount code string to the user front-end.

4. FRONTEND COMPONENTS:
- Admin Dashboard: Manage point earning rules, view user balances, export logs.
- Embeddable Widget: Light modern Web Component / React component showing user points balance, referral link copy button, and redemption buttons.

5. FAILURE MODES & ANTI-FRAUD:
- Block referral rewards if referrer email domain and referee email match, or if IP addresses are identical within a 24-hour window.
- Out of scope: Third-party social API automated follow verifications.

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