Can I vibe code Zinrelo?

Build a custom e-commerce loyalty points microservice in Node.js, TypeScript, PostgreSQL, and Prisma.

1. DATA MODEL:
- Customer: id, store_customer_id, email, points_balance, current_tier_id, created_at.
- Tier: id, name, min_points_required, multiplier_rate (e.g., 1.5x points).
- PointTransaction: id, customer_id, points_delta, transaction_type ('earn', 'redeem', 'refund', 'expire'), reference_id (order_id), created_at.
- Reward: id, name, points_cost, discount_value, status ('active', 'disabled').
- Redemption: id, customer_id, reward_id, points_spent, discount_code, used_at, created_at.

2. CORE LOGIC & API ENDPOINTS:
- Webhook Handler POST `/webhooks/shopify/orders-paid`: Deduplicate incoming order webhook using order_id. Calculate points earned = floor(order_subtotal * active_tier_multiplier). Insert PointTransaction record and update Customer points_balance within a single database transaction. Check if points reach a new Tier threshold and update tier_id if applicable.
- Webhook Handler POST `/webhooks/shopify/refunds`: Calculate points to claw back based on refunded amount. Deduct points from Customer points_balance and record a 'refund' PointTransaction. Allow balance to go negative if points were already spent.
- Endpoint POST `/api/v1/loyalty/redeem`: Accept customer_id and reward_id. Fetch Customer with SELECT FOR UPDATE row locking. Verify balance >= reward.points_cost. Execute Shopify API call to generate a single-use discount coupon code. Deduct points, record Redemption, and return coupon code in response.
- Endpoint GET `/api/v1/loyalty/customer/:id`: Return points balance, current tier, and transaction history.

3. SAFETY & FAILURE MODES:
- Enforce database-level transactions with row-level locks on redemption to prevent double-spending.
- Handle webhook idempotency by checking if reference_id already exists in PointTransaction table.
- Log all failed Shopify discount creation requests and roll back points deduction if external API fails.

4. OUT OF SCOPE:
- Physical POS integrations, physical receipt scan OCR, complex dynamic rule builders, and multi-currency exchange adjustments.

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