Can I vibe code Inventory Planner?

Build an open-source Inventory Forecasting and Replenishment Application using Next.js (App Router), Supabase (PostgreSQL), Tailwind CSS, and AG Grid (or TanStack Table).

1. SYSTEM ARCHITECTURE & DATA MODEL:
- Implement tables in PostgreSQL: 'products' (id, sku, title), 'variants' (id, product_id, sku, barcode, cost_price), 'warehouses' (id, name), 'inventory_levels' (variant_id, warehouse_id, stock_on_hand, stock_committed, stock_on_order), 'vendors' (id, name, lead_time_days, moq, case_pack_size), 'orders' (id, created_at), 'order_items' (id, order_id, variant_id, quantity), 'purchase_orders' (id, vendor_id, status, created_at), 'po_items' (id, po_id, variant_id, qty_ordered, qty_received).

2. HISTORICAL SALES VELOCITY & FORECAST ENGINE:
- Compute Daily Sales Velocity (DSV) for each variant across configurable timeframes (30, 60, 90 days).
- Implement Stockout Adjustment Logic: Exclude days where stock_on_hand was 0 from the DSV calculation denominator to prevent artificially deflated sales velocity.
- Implement Reorder Point (ROP) calculation: ROP = (Daily Sales Velocity * Vendor Lead Time) + Safety Stock. Calculate Safety Stock as: (Max Daily Sales * Max Lead Time) - (Avg Daily Sales * Avg Lead Time).
- Calculate Reorder Quantity: If (Stock On Hand + Stock On Order - Stock Committed) <= ROP, then Units To Order = Max(Vendor MOQ, Ceil(Target Stock Days * DSV - Current Available Stock, Case Pack Size)).

3. HIGH-DENSITY EDITABLE GRID UX:
- Create an interactive table displaying: Variant SKU, Image, On Hand, On Order, Velocity (30d), Forecasted Demand, Reorder Point, and Recommended Order Qty.
- Allow inline overrides: users can manually edit Vendor Lead Time, Target Stock Days, or Override Forecast values directly in the cell, triggering instant client-side recalculation of Recommended Order Qty.

4. PURCHASE ORDER GENERATION:
- Provide a multi-select feature in the grid to select low-stock SKUs and automatically generate a grouped Draft Purchase Order per Vendor.
- Support PO Export to PDF/CSV and status transitions (Draft -> Sent -> Partially Received -> Received).
- When PO items are received, update inventory_levels automatically.

5. EDGE CASES & ERROR HANDLING:
- Handle variants with zero historical sales gracefully.
- Ensure API rate limit protection when importing large order histories via Shopify GraphQL Admin API.
- Prevent duplicate purchase order items on rapid sync operations.

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