Can I vibe code Inventoro?

Build a self-hosted Demand Forecasting and Purchase Order automation microservice designed to replace Inventoro for a Shopify merchant.

1. DATA MODEL & INGESTION
- Database: PostgreSQL with Prisma ORM.
- Schema: Products (id, sku, title, current_stock), SalesHistory (id, product_id, date, quantity_sold, were_in_stock), Suppliers (id, name, email, lead_time_days, moq, target_order_value), PurchaseOrders (id, supplier_id, status, created_at), POLineItems (id, po_id, product_id, qty_ordered, unit_cost).
- Data Pipeline: Ingest Shopify orders via webhooks (`orders/create`). Implement a backfill script pulling 12 months of order history via Shopify REST/GraphQL API. Calculate and store aggregated daily sales per SKU.

2. FORECASTING & REORDER LOGIC ENGINE
- Service: Create a Python FastAPI worker using `statsforecast` (AutoARIMA or Holt-Winters) or Exponential Smoothing for low-volume SKUs.
- ABC Analysis: Automatically classify SKUs into Class A (top 80% revenue), Class B (next 15%), Class C (bottom 5%).
- Safety Stock & Reorder Point (ROP):
  * Calculate Average Daily Sales (ADS) excluding dates where `were_in_stock` is false.
  * ROP = (ADS * Lead Time Days) + Safety Stock.
  * Safety Stock = Z_score * (Standard Deviation of Daily Sales * sqrt(Lead Time Days)).
- Purchase Order Generator: Scan active SKUs daily. If (Current Stock + Pending PO Qty) <= ROP, create a Draft PO. Round order quantity up to meet the Supplier MOQ.

3. USER INTERFACE & WORKFLOW
- Frontend: Next.js (App Router), Tailwind CSS, Shadcn UI.
- Stock Risk Screen: View SKUs sorted by 'Days of Stock Remaining' with visual badges for Stockout Warning, ABC Class, and ROP.
- Draft Purchase Orders: UI to view generated PO drafts, edit line item quantities, recalculate total spend against target MOQs, and approve POs. Approved POs trigger email delivery of PDF purchase orders to suppliers.

4. FAILURE MODES & CONSTRAINTS
- Handle zero-inflated demand for slow-moving products by defaulting to standard moving averages when time-series statistical models fail to converge.
- Ensure concurrent order processing does not cause duplicate Purchase Order generation.

5. OUT OF SCOPE
- Multi-warehouse routing, complex multi-currency exchange conversion, and automated inventory sync writebacks to secondary marketplaces.

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