Can I vibe code CartRover?

Build an open-source order integration middleware in Node.js (TypeScript) using Express, BullMQ, Redis, and PostgreSQL to bridge Shopify and a custom 3PL WMS.

1. DATA MODEL & ARCHITECTURE
- Design PostgreSQL models for: Stores (Shopify credentials, API tokens), Warehouses (3PL API keys/SFTP credentials), SKU Mappings (cart SKU to 3PL SKU, handling kit exploding), Orders (cart order ID, 3PL order ID, status, payload, error log), and Sync Logs.
- Use BullMQ with Redis for asynchronous background processing of order ingestion, inventory updates, and tracking sync.

2. CORE FUNCTIONALITY
- Webhook Listener: Expose an endpoint to receive `orders/created` from Shopify. Verify HMAC signature.
- Payload Normalization: Convert Shopify order JSON into a standardized internal schema. Apply SKU mappings. If a SKU mapping is missing, flag the order as 'UNMAPPED_SKU' and dispatch an email alert via Resend.
- 3PL Dispatcher: Post the normalized order to the 3PL's REST API endpoint. Store the returned 3PL Order ID and update status to 'SENT_TO_WMS'.
- Tracking Sync Job: Create a scheduled cron job (every 15 mins) to fetch recent ship notices from the 3PL. Call Shopify's GraphQL API (`fulfillmentCreateV2`) to fulfill the order lines and attach carrier/tracking details.
- Inventory Sync Job: Create a scheduled cron job (hourly) to fetch stock quantities from the 3PL, compare against local cache, and update Shopify inventory levels via `inventorySetQuantities`.

3. FAILURE MODES & RESILIENCE
- Implement exponential backoff retry logic (up to 5 attempts) for all outbound 3PL API calls.
- Maintain absolute idempotency: duplicate webhooks must check local PostgreSQL records by Shopify Order ID before creating queue jobs.
- Provide a simple admin UI using Tailwind CSS and React to view stuck orders, trigger manual re-syncs, and edit SKU mappings.

4. OUT OF SCOPE
- Multi-warehouse routing logic or complex carrier selection rules.

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