Can I vibe code WareIQ?

Build a multi-channel inventory management and order routing backend using Node.js, Express, PostgreSQL, and Prisma ORM.

1. DATA MODEL
- Location: id, name, pincode, max_daily_capacity.
- Product: id, sku, barcode, total_stock.
- InventoryLevel: location_id, product_id, available_stock, reserved_stock.
- Order: id, channel (Shopify, Custom), external_order_id, shipping_pincode, payment_mode (PREPAID, COD), status (PENDING, ROUTED, SHIPPED, DELIVERED, RTO).
- OrderItem: order_id, product_id, quantity.

2. CORE FUNCTIONALITY
- Webhook Receivers: Endpoint to receive order creation payloads from sales channels.
- Inventory Reservation: Lock product stock instantly upon order creation using Postgres transactions (`SELECT FOR UPDATE`) to prevent overselling.
- Smart Order Routing Logic: Given an incoming order, locate the warehouse with available stock closest to `shipping_pincode`. Assign order to that location and decrement `available_stock` while incrementing `reserved_stock`.
- Stock Sync Engine: When inventory changes at any location, emit background job (via BullMQ/Redis) to broadcast remaining global stock to connected Shopify endpoints via REST API.
- Tracking Page: Express route `/track/:tracking_id` rendering current courier status, fallback status updates, and estimated delivery date.

3. FAILURE MODES & CONCURRENCY
- High Concurrency: Prevent race conditions when two orders for the last stock unit arrive simultaneously. Use atomic database transactions.
- API Rate Limits: Implement exponential backoff when broadcasting stock updates to external channel APIs.
- Out-of-stock Exceptions: If no single warehouse has complete order inventory, split order across two warehouses or flag for manual review.

4. OUT OF SCOPE
- Physical warehouse management software (WMS) barcode scanner integration.
- Indian GST invoice PDF generation or e-Way bill API integration.
- Automated WhatsApp IVR calling infrastructure.

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