Case · 01 — Production
Génesis
Inventory and order management
Replaced the company's Excel and AppSheet setup with a web app handling stock reservations, shortages, traceability by production area, and reports on turnover and capital tied up.
896SKUs in production
System view · demo data
The problem
Stock was controlled by intuition and scattered spreadsheets: shortages discovered too late, permanent physical stocktaking, and purchasing decisions made without turnover or margin data.
What I built
A 13-table PostgreSQL data model, a FastAPI backend and a Next.js frontend on Docker. Stock reservations, shortage logging, dated supplier price history, and alerts on a configurable threshold.
What changed
In production today with the real 896-SKU catalogue and three users. Physical stocktaking went from permanent to a monthly check. It is growing into a full ERP with sales channels and invoicing.
Tools
- FastAPI
- PostgreSQL
- Next.js
- Docker
- Python