Can I vibe code SmartrMail?

Build an automated ecommerce email automation service in Node.js (TypeScript) using Express, Supabase (Postgres), and the Resend API.

1. DATA MODEL:
Create database tables for:
- customers (id, email, shopify_customer_id, accept_marketing, created_at)
- products (id, shopify_product_id, title, image_url, price, handle)
- carts (id, customer_id, token, line_items_json, updated_at, completed_at)
- email_logs (id, customer_id, template_slug, status, sent_at)
- suppressions (id, email, reason, created_at)

2. CORE FUNCTIONALITY:
- Implement Webhook Endpoints for Shopify:
  a) /webhooks/carts/update: Upsert cart record. If completed_at is null, schedule an abandoned cart job in BullMQ delayed by 2 hours.
  b) /webhooks/orders/create: Set completed_at on the cart record and cancel pending delayed email jobs for this customer.
  c) /webhooks/customers/redact: Hard delete customer and suppress records.
- Automated Email Worker:
  Process BullMQ job for abandoned cart. Check if customer is in suppressions table or if cart completed. If valid, pick 2 top-selling products as recommendations, construct a responsive HTML body using React Email, and dispatch via Resend API.
- Unsubscribe Handling:
  Create a public GET /unsubscribe route accepting a signed JWT email token that adds the email to suppressions and appends standard List-Unsubscribe headers to sent emails.

3. FAILURE MODES & RESILIENCE:
- Webhook Idempotency: Deduplicate Shopify webhooks using X-Shopify-Webhook-Id.
- Soft/Hard Bounce Handling: Webhook route /webhooks/resend to capture bounce events and auto-add to suppressions table.
- Rate Limiting: Respect Resend send limits by throttling worker queue concurrency.

4. OUT OF SCOPE:
- Visual drag-and-drop template designer (use hardcoded React Email templates).
- Multi-tenant dashboard (single store instance only).

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