Custom Inventory Management System
Internal inventory and order tracking tool built for a distributor to replace spreadsheet-based workflows.
Challenge
A small distributor was managing inventory, purchase orders, and customer orders entirely in spreadsheets. As the business grew, the approach became unworkable — data was duplicated across files, reconciliation was manual, and errors were frequent. They had looked at off-the-shelf inventory software but found that none fit their specific workflow without significant workarounds.
Approach
Started with a structured requirements gathering phase to document the actual workflow and identify where the pain was coming from. Built a Python/FastAPI backend with a React frontend and PostgreSQL database. The data model was designed around their actual processes rather than forcing them to adapt to a generic system. Delivered in phases — core inventory first, then purchasing workflows, then customer orders.
Results
The system replaced all inventory-related spreadsheets and is now the single source of truth for stock levels, orders, and supplier relationships. The phased delivery approach meant the client was getting value from day one rather than waiting for a full build. The codebase is documented and straightforward enough that another developer could pick it up without difficulty.