Can I vibe code Yotpo Loyalty?

Build a custom Shopify Loyalty and Referral App using Node.js, Express, Prisma, PostgreSQL, and React (Remix or Next.js) with Shopify App Bridge.

CORE DATA MODEL:
1. Customer: id, shopifyCustomerId, email, pointsBalance, lifetimePoints, currentTierId, referralCode.
2. LoyaltyTier: id, name, minPoints, multiplier, discountPercentage.
3. PointTransaction: id, customerId, amount, type ('EARN_ORDER', 'EARN_REFERRAL', 'REDEEM_DISCOUNT', 'MANUAL_ADJUSTMENT'), referenceId, createdAt.
4. Referral: id, referrerId, referredEmail, status ('PENDING', 'COMPLETED'), shopifyOrderId.
5. RewardRule: id, name, pointsRequired, rewardType ('FIXED_DISCOUNT', 'PERCENTAGE_DISCOUNT'), rewardValue.

SHOPIFY INTEGRATIONS & WEBHOOKS:
1. Listen to `orders/paid`: Calculate earned points as `(order.total_price * tier.multiplier)` minus shipping/tax. Increment customer points, create PointTransaction, check and update customer tier, update Shopify customer metafield `loyalty.points_balance`.
2. Listen to `orders/cancelled` or `refunds/create`: Deduct points earned from refunded items. Handle negative point balances by pinning to 0.
3. Listen to `customers/create`: Generate unique referral code and populate `loyalty.referral_code` customer metafield.

REWARD REDEMPTION MECHANICS:
1. Storefront App Block UI allows logged-in customers to view points, current VIP tier, and redeem rewards.
2. Redemption API endpoint: Validates customer point balance, deducts points atomically in Postgres, calls Shopify Admin REST/GraphQL API to generate a unique single-use price rule and discount code, returns the code string to the frontend.

REFERRAL ENGINE:
1. Unique URL structure: `?ref=REFERRAL_CODE`. Store in cookie on storefront script load.
2. Pass referral code during cart checkout inside order note attribute or custom metafield.
3. On `orders/paid`, check if referral code exists, credit referrer customer with reward points, set referral status to completed. Include anti-fraud check blocking referrals sharing the same IP, shipping address, or email domain.

FAILURE MODES TO HANDLE:
1. Idempotency: Webhook retries must not award duplicate points. Hash `order_id + event_type` in a processed_events table.
2. Race conditions during redemption: Use Postgres SQL transactions with `SELECT FOR UPDATE` on customer point balances.

OUT OF SCOPE:
- Email/SMS sending (trigger webhooks to Klaviyo instead via custom events).
- Visual drag-and-drop widget builders.
- Multi-store cross-brand loyalty networks.

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