Can I vibe code Ecomdash?

Build a multi-channel inventory management microservice using Node.js, TypeScript, PostgreSQL, Prisma, and BullMQ.

1. DATA MODEL:
- MasterSKU: id, sku (unique string), title, total_quantity (int), updated_at.
- Channel: id, name (e.g. 'shopify', 'amazon'), auth_credentials (jsonb), active (boolean).
- ChannelMapping: id, master_sku_id (fk), channel_id (fk), channel_sku (string), external_item_id (string).
- Order: id, channel_id (fk), external_order_id (string), status (string), total_amount (decimal), created_at.
- OrderItem: id, order_id (fk), master_sku_id (fk), quantity (int), price (decimal).
- InventoryLog: id, master_sku_id (fk), quantity_change (int), reason (string), reference_id (string), created_at.

2. CORE LOGIC:
- Expose webhook endpoint POST `/webhooks/order/:channelId` to receive incoming order payloads from Shopify or Amazon.
- Upon payload arrival: parse the items, lock the matching MasterSKU records inside a database transaction (`SELECT FOR UPDATE`), deduct the purchased `quantity`, and record entries in `InventoryLog` and `Order` tables.
- Immediately push a job named `SyncInventoryToChannels` to a Redis BullMQ queue passing the `master_sku_id`.
- The queue worker reads all active `ChannelMapping` rows for that `master_sku_id` and executes external API calls to update remote stock counts.
- Implement exponential backoff and retry mechanisms (up to 5 attempts) for channel API updates.
- Expose REST endpoints: GET `/api/skus`, POST `/api/skus`, and GET `/api/orders` for internal admin visibility.

3. CONCURRENCY & FAILURE MODES:
- Guarantee thread-safety using database-level locking during inventory deduction to prevent overselling across fast concurrent webhooks.
- Handle rate-limit responses (HTTP 429) from marketplace APIs by setting appropriate retry delays in BullMQ.
- Record API sync errors to a `SyncLogs` table without breaking execution for other channels.

4. OUT OF SCOPE:
- Automated product listing generation, shipping label printing, legacy SOAP protocol support, and automated tax calculations.

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