Can I vibe code PostPilot?

Build a Node.js and TypeScript background service and backend API that replaces PostPilot's core direct mail triggering and tracking features using Lob as the print provider.

1. DATA MODELS
Define a PostgreSQL schema using Prisma ORM:
- Customer: shopify_id, email, first_name, last_name, address1, address2, city, province, zip, country, cass_validated (boolean).
- Campaign: id, name, trigger_event (e.g., 'WINBACK_60_DAY', 'ABANDONED_CHECKOUT'), delay_hours, template_id, status (ACTIVE/PAUSED).
- DirectMailJob: id, customer_id, campaign_id, lob_id, status (created, processing, in_transit, delivered, failed), cost, sent_at, delivered_at.
- Attribution: id, direct_mail_job_id, shopify_order_id, order_value, converted_at.

2. WEBHOOK & TRIGGER LOGIC
- Implement POST /webhooks/shopify/orders to ingest order data and update customer last_order_date.
- Implement a Cron Job (using BullMQ) running hourly that evaluates 'WINBACK' criteria (customers with no orders in 60 days who haven't received a postcard in 90 days).
- Before dispatching mail, call Lob's Address Verification API. If valid, normalize the address; if invalid, set cass_validated=false and skip.

3. PRINT GENERATION & DISPATCH
- Use Handlebars to populate an HTML/CSS postcard template (4x6 format with 300 DPI, 0.125-inch bleed margins, and USPS mailer area constraints) with recipient first name, personalized single-use discount code, and dynamic product recommendations.
- Render the template using Puppeteer to generate front and back PDF buffers.
- Send the PDF payload to Lob API POST /v1/postcards.

4. ASYNC TRACKING & ATTRIBUTION
- Implement POST /webhooks/lob to receive status updates ('postcard.processed', 'postcard.delivered', 'postcard.failed'). Update DirectMailJob status and delivered_at timestamp.
- Implement a daily attribution job: query all Shopify orders created within 30 days following a DirectMailJob delivered_at date for matching customer shipping address or email. Record matches in the Attribution table.

5. ERROR HANDLING & OUT OF SCOPE
- Implement exponential backoff for API rate limits.
- Out of scope: Visual drag-and-drop postcard designer, native print press routing, manual bulk paper stock selection.

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