Can I vibe code Order Time?

Build an inventory and manufacturing order management system (MRP Light) using Next.js (App Router), PostgreSQL, and Prisma ORM.

1. DATA MODEL:
- Items: id, sku, name, type (inventory, assembly, non-inventory), unit_cost, total_on_hand, reserved_qty.
- BillOfMaterials (BOM): parent_item_id, component_item_id, qty_required, scrap_percentage.
- WorkOrders: id, status (draft, committed, completed), assembly_item_id, target_qty, location_id, created_at.
- PurchaseOrders: id, vendor_id, status (draft, sent, received), expected_date.
- InventoryLedger: id, item_id, transaction_type (po_receive, wo_consume, wo_produce, manual_adjust), qty_change, dynamic_unit_cost, created_at.

2. CORE FUNCTIONALITY:
- BOM Explosion: When a Work Order status shifts to 'committed', soft-reserve required sub-components based on BOM calculations including scrap factor.
- Work Order Execution: When completed, execute an atomic transaction: reduce component stock levels on hand, insert 'wo_consume' ledger records, calculate rolled-up component cost, add finished assembly stock, and insert 'wo_produce' ledger record with average unit cost.
- Inventory Reconciliation: API endpoint to recompute current stock on hand dynamically from InventoryLedger and flag any variance against item table caches.
- Stock Sync Trigger: Post webhooks to Shopify Admin API whenever an Item's available stock (on_hand minus reserved) changes.

3. FAILURE MODES & ATOMICITY:
- Throw strict transaction errors if completing a Work Order results in negative component stock unless explicitly allowed by system config.
- Use Postgres row-level locking (SELECT FOR UPDATE) on Item rows during Work Order fulfillment and PO receipt to prevent race conditions during concurrent requests.

4. OUT OF SCOPE:
- Accounting GL syncing (QuickBooks/Xero).
- Multi-currency conversions.
- Lot and serial number tracking.

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