Build an inventory tracker
Build an inventory tracker in Jotsu for products, suppliers, stock movements, current quantities, and clear reorder needs.
What you will build#
An inventory application with products, suppliers, stock movements, and a low-stock work queue.
Part 1: Plan the application#
Define Product, Supplier, and StockMovement records. A product belongs to one supplier and has many movements. Current quantity is derived from movements; it is not edited independently.
Part 2: Create the data model#
Ask Jotsu to build the three records, relationships, forms, tables, and clearly labeled sample data.
At this point, you can open a supplier and see its products.
Part 3: Build the stock workflow#
Ask Codex for receive and issue actions that create movements. Reject an issue that would make stock negative. Add a low-stock view where quantity is below reorder level.
At this point, receiving stock changes the calculated quantity and removes eligible products from low stock.
Part 4: Design the interface#
Use an operational dashboard with low-stock count, recent movements, and quick actions. Keep the product table compact and make low-stock status unmistakable.
Part 5: Test and debug#
Receive stock, issue stock, and attempt an invalid issue. Confirm persistence and log outcomes.
Part 6: Deploy the application#
Deploy and repeat one stock movement at the deployed URL.
Extend the application#
Add purchase orders, CSV import, or a daily reorder report.