Python
Inventory allocation engine for a fashion retailer
A Python engine that analyses sales velocity for 90,000+ SKUs across 84 stores, flushes dead stock to stores that sell it and generates daily warehouse picking lists.
- Client
- Fashion retailer
- Industry
- Retail, India
- Status
- Delivered
The problem
Stockouts in busy stores and dead stock in quiet ones; manual allocation could not handle 90,000+ SKUs.
What we built
- Rolling sales-velocity display floors per store
- Dead-stock matching to proven stores
- Promotional calendar boosts
Challenges we solved
- Avoiding bare donor shelves
- Preventing back-and-forth transfers
Results
- Leave-1-unit floors, transfer caps and a 3-day persistence gate
- 180-day dead-stock drain-to-zero
Technology stack
- Python
- pandas
- NumPy
- MySQL
Need something similar?
Free 30-minute scoping call. We reply within 24 hours.
Talk to us about Python