Inventory & Warehouse Management System
The Problem
A 12-location retail chain was tracking stock across branches using a combination of Excel spreadsheets and WhatsApp messages. This led to frequent oversells, unexplained stock discrepancies, write-offs from expired inventory, and a 3-day lag before management could see accurate stock levels across the business.
What We Did
- Conducted a 2-week discovery and process mapping exercise across 3 pilot locations
- Designed a centralized inventory data model supporting multi-location, multi-SKU stock tracking
- Built a Next.js web app with real-time stock views, transfer workflows, and receive/dispatch flows
- Developed an automated reporting engine that generates branch-level and consolidated reports on demand
- Deployed on AWS with a Docker-based CI/CD pipeline for zero-downtime updates
Key Results
Reporting time
3 days
< 30 seconds
Stock discrepancies
Frequent
â70%
Onboarding per branch
N/A
2 days
Real-time inventory visibility across all 12 locations. Reporting time dropped from 3 days to under 30 seconds. Stock discrepancy incidents reduced by 70% within the first quarter. Branches were onboarded in 2 days each.