Inventory and orders admin for a shop or warehouse

The same app with every detail named: the pages, fields and tables. Use it when you want exactly this app; the short prompt leaves those choices to your AI.

Use LazyFrog to build an inventory and orders admin for my shop and its stockroom. Products live in a table called products (sku, name, unit_price, reorder_level) and stock in stock_levels (product_id, location as text, shop or stockroom, quantity). Purchase orders (purchase_orders and purchase_order_lines) add stock to a location when marked received; sales orders (sales_orders and sales_order_lines) take it away when marked shipped and refuse to ship more than that location has; every change is written to stock_movements. The home page is a dashboard of what to reorder: products whose total stock is at or below their reorder_level. Pages /products, /purchase-orders and /sales-orders list and add them. POST /api/sales-orders takes JSON {"customer", "location", "lines": [{"sku", "quantity"}]} and answers {"id"}, and POST /api/sales-orders/<id>/ship ships it. /products.csv downloads every product's stock with the header sku,name,unit_price,reorder_level,location,quantity (a row per product and location), and a form at /products/import uploads a CSV file with the same columns (a multipart POST to /products/import, the file in the field file) and adds or updates those products and their stock. A cron job every morning at 7:00 emails me the reorder list. Start with eight example products, one of them SKU MUG-01 "Stoneware mug" with 4 in the shop and 2 in the stockroom against a reorder level of 10, and a couple of orders. Only my staff should get in: protect the whole app with LazyFrog's protected pages (I'll choose the password in the portal).