01
Inventory management
Manage products, quantities, categories and stock thresholds.
Case Study · Full-Stack · Automotive
PartsPilot
An automotive inventory platform connecting stock-management workflows with useful operational reporting.
What it does
02
Stock monitoring
Search, filter and sort inventory, including low-stock items.
03
Operational reporting
Review inventory totals and category summaries, with CSV and Power BI reporting.
How it works
React
Responsive interface for inventory workflows and reporting.
FastAPI
REST API for validation, authentication and inventory operations.
PostgreSQL
Persistent storage for inventory, stock and supplier data.
ReactTypeScriptViteTailwind CSSFastAPIPostgreSQLSQLAlchemyDockerPower BI
Engineering decision
The inventory list is paginated, but dashboard totals need to represent every database record. I added separate reporting endpoints so the dashboard wouldn’t calculate totals from only the visible page of results.