Can I vibe code Stockly?

Build a multi-tenant inventory bridge application using Node.js, TypeScript, Express, PostgreSQL, and Redis to route unfulfilled e-commerce backorders between participating store instances.

1. DATA MODEL & SCHEMAS:
Create PostgreSQL tables using Prisma or Drizzle for:
- `stores`: ID, name, api_key, webhook_secret, type (RETAILER or SUPPLIER).
- `catalog_items`: ID, store_id, gtin, sku, title, price, available_stock, updated_at.
- `routing_rules`: ID, retailer_store_id, target_supplier_id, priority, margin_rate.
- `orders`: ID, source_store_id, destination_store_id, external_order_id, status (PENDING, ROUTED, ACCEPTED, SHIPPED, FAILED, REFUNDED), payload JSON.
- `settlement_ledger`: ID, order_id, wholesale_amount, retail_amount, fee_amount, status.

2. CORE ROUTING ENGINE:
Implement an endpoint POST `/api/webhooks/order-created`:
- Verify incoming Shopify/platform HMAC signature.
- Parse line items. Check local stock or flag missing SKUs.
- For out-of-stock items, query `catalog_items` matching GTIN/EAN across connected `SUPPLIER` stores where `available_stock > 0`.
- Apply atomic lock using Redis (`redis.set('lock:sku:' + sku, storeId, 'EX', 10, 'NX')`) to prevent double-selling.
- Select optimal supplier based on `routing_rules` (highest margin or stock priority).
- Dispatch order creation request to target supplier platform API (e.g., Shopify Draft Order API or REST endpoint).
- Update `orders` status to ROUTED and write ledger entry.

3. STATUS SYNCHRONIZATION & FULFILLMENT:
- Build incoming fulfillment webhook endpoint `/api/webhooks/fulfillment-updated` from target supplier.
- Capture tracking number and carrier name.
- Push tracking payload back to source store platform API to fulfill original customer order.

4. FAILURE HANDLING & IDELPOTENCY:
- Implement Exponential Backoff with BullMQ queues for retries when target supplier API fails.
- Include idempotency key check (using external_order_id) to prevent duplicate order generation.
- If all target suppliers reject or time out, update status to FAILED and post alert webhook to retailer.

5. OUT OF SCOPE:
Do not build end-consumer UI, automated tax engine, multi-currency conversion, or gateway payment capture.

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