Can I vibe code CartKit?

Build a custom abandoned cart recovery engine using Next.js, Supabase, BullMQ, Resend, and Twilio.

1. DATA MODEL:
Create a Supabase table `checkouts` storing `checkout_token` (unique string), `email` (string), `phone` (string), `cart_data` (jsonb), `total_price` (numeric), `status` (enum: pending, completed, abandoned, recovered), `created_at`, and `updated_at`.
Create an `opt_outs` table for unsubscribed emails and phones.

2. WEBHOOK INGESTION:
Expose public endpoints `/api/webhooks/shopify/checkout-updated` and `/api/webhooks/shopify/order-created`.
Validate Shopify HMAC signatures.
On `checkout-updated`, upsert the `checkouts` row. If `status` is pending, enqueue a BullMQ job delayed by 60 minutes with job ID `recovery:{checkout_token}`.
On `order-created`, match the order's `checkout_token`. Update status to `completed` and call `queue.remove(jobId)` to cancel any pending recovery job.

3. JOB WORKER & MESSAGING PIPELINE:
Create a background worker for BullMQ. When the 60-minute delayed job fires:
- Fetch the checkout record from Supabase. If `status` is not `pending`, terminate execution.
- Check `opt_outs`. If customer is opted out, abort.
- Step 1 (Email): Send an HTML abandoned cart email via Resend API containing the checkout recovery URL. Update database record with `step_1_sent_at`.
- Schedule a follow-up job delayed by 24 hours for Step 2.
- Step 2 (SMS): If customer provided a valid phone and has not recovered or opted out, send an SMS via Twilio API containing a unique discount link.

4. FAILURE MODES & COMPLIANCE:
Expose `/api/webhooks/twilio/inbound` to process incoming SMS replies. If message body matches 'STOP' or 'UNSUBSCRIBE', add phone to `opt_outs` and update checkout status.
Ensure webhook processing is idempotent using Shopify's `X-Shopify-Webhook-Id` header stored in Redis with a 24-hour TTL.

5. OUT OF SCOPE:
Do not build a drag-and-drop visual email editor. Use hardcoded HTML email templates with dynamic variable insertion.

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