The verdict in three sentences
The moment you stock in two or more locations, a per-warehouse spreadsheet guarantees overselling and invisible stockouts. Real-time unified inventory brings overselling from 3-7 % down to under 0.5 % and lets you route each order to the nearest warehouse. In Nairobi as in Nakuru, it is the only way to sell across channels without disappointing one customer in ten.
Why multi-warehouse breaks the spreadsheet
A hand-updated spreadsheet is always one step behind. Between a sale leaving Mombasa and you correcting the Nairobi row, a second customer has already ordered the last unit. You sell what you no longer have: that is overselling, and it costs you in refunds, negative reviews and trust.
| 2026 criterion | Per-warehouse spreadsheet | Real-time unified stock |
|---|---|---|
| Oversell rate | 3-7 % | < 0.5 % |
| Update lag | 2-24 h | Instant |
| Stockout cost (lost sale) | 5-20 % of cart | Near zero |
| Nearest-warehouse routing | Manual | Automatic (-10 to -20 % shipping) |
| Recommended safety stock | 15-20 % | 10-15 % |
| Inventory errors/month | 8-15 | 1-3 |
| Channels manageable safely | 1 | Unlimited |
Moving to unified stock is not just comfort: it frees cash by lowering safety stock from 20 % to 12 % while eliminating overselling.
What the tooling costs in 2026
A SaaS WMS (Warehouse Management System) stays affordable for an SME. The point is to connect it to the store and mobile money, not to buy a huge ERP.
| Solution | Monthly cost (2026 order of magnitude) | For whom |
|---|---|---|
| Shared spreadsheet | KES 0 | 1 location, < 30 orders/month |
| Built-in store stock module | KES 3,000-8,000 | 2-3 locations |
| Light SaaS WMS | KES 5,000-30,000 | Multi-warehouse + multichannel |
| Full ERP | KES 40,000+ | Industrial volume |
Mini case study
Nadia, who runs a cosmetics store in Nakuru, stocks in Nakuru and Nairobi. With her spreadsheet she oversells 5 % of her 400 monthly orders, i.e. 20 cancelled orders. Each cancellation costs an average cart of KES 3,000 in margin and reputation, or KES 60,000/month of lost value. A WMS at KES 12,000/month brings overselling to 0.4 % (under 2 orders) and, by routing to the nearest warehouse, cuts shipping by 15 %. Estimated net gain: over KES 50,000/month.
FAQ
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
How many warehouses before I need unified stock?
From the second stocking point. With a single warehouse and under 30 orders/month, a spreadsheet is fine; beyond that, oversell risk exceeds 3 %.
What is nearest-warehouse allocation?
The system ships the order from the warehouse closest to the customer. That cuts delivery cost by 10-20 % and delay by one to two days.
What safety-stock level should I keep?
In 2026, plan 10-15 % with synced stock, versus 15-20 % without. Better visibility lets you hold less buffer.
Does mobile money complicate stock management?
No, as long as a confirmed payment reserves the stock. A validated M-Pesa payment should decrement stock in real time.
How long to connect my warehouses?
Plan 1 to 3 weeks depending on the number of locations and channels. Priority is reliable inflows/outflows before automating.
Let's talk about your project. We connect your warehouses, store and mobile money payments into a single real-time inventory. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
