Can I vibe code Fishbowl Inventory?

Build a multi-location inventory and work-order management system for ecommerce using Next.js App Router, PostgreSQL, Prisma, and Tailwind CSS.

1. DATA MODEL:
Define Prisma schemas for Locations, Products (SKU, barcode, cost_price, valuation_method), InventoryItems (location_id, product_id, quantity_on_hand, quantity_allocated, lot_number, serial_number), SalesOrders, SalesOrderItems, PurchaseOrders, PurchaseOrderItems, BillsOfMaterials (parent_product_id, child_product_id, quantity_required), and WorkOrders (status: draft, committed, in_progress, completed).

2. INVENTORY LOGIC:
Implement transactional inventory reservation when a SalesOrder is created (move quantity_on_hand to quantity_allocated using atomic Postgres transactions). Build a FIFO valuation calculation pipeline that logs every inventory movement in an InventoryLedger table with timestamp, reference_type, reference_id, unit_cost, and total_value. Block any allocation that would result in negative quantity_on_hand.

3. MANUFACTURING WORK ORDERS:
Create a work order processor API route. When a WorkOrder status transitions to completed, automatically deduct component quantities based on the associated BillOfMaterials table and increment the parent finished good's quantity_on_hand. Block completion if component stock is insufficient and display exact missing sub-assemblies.

4. HARDWARE & SCANNING:
Build a camera and barcode scanner API endpoint that accepts raw scan inputs (UPC, GS1 128 lot format), resolves the product and lot, and performs fast pick validation against an open order. Provide a full audit trail for every pick operation.

5. OUT OF SCOPE:
Full double-entry general ledger accounting integrations, desktop QuickBooks file parsing, complex international customs duty landed cost calculations, and native desktop thick-client binaries.

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