The verdict in three sentences
Stockouts and overstock cost more than an inventory system: one chases sales away, the other freezes your cash. In Kenya in 2026, a real-time multi-warehouse inventory module with threshold alerts is built for 600,000 to 1,500,000 FCFA and pays for itself in under six months. The real decision is not "spreadsheet or software" but "how much the lack of sync is already costing you" between your online store and physical outlets.
What stockouts and overstock cost
Managing inventory on a shared spreadsheet works at low volume, but the moment you sell online and in-store at once, the gaps create oversells and invisible stockouts. Here are the 2026 order-of-magnitude figures.
| Problem | Quantified impact | Common cause |
|---|---|---|
| Stockout | 10 - 20% of sales lost | No threshold alert |
| Overstock | 20 - 30% of cash tied up | Blind purchasing |
| Oversell (sold but unavailable) | Return + lost customer | Un-synced stock |
| Manual count error | 2 - 5% discrepancy | Spreadsheet entry |
| Manual counting time | 4 - 8 h/week | No automation |
| Unknown shrinkage | 1 - 3% of stock | No traceability |
The critical point: in Kenya, many shops sell the same item online and in-store. Without sync, the item sold in-store still shows "available" online, and the next customer pays for a product that no longer exists.
Spreadsheet vs real-time inventory module: the ROI math
Compare spreadsheet tracking and a connected inventory module for a store doing 4,000,000 FCFA in monthly sales.
| Item | Spreadsheet tracking | Real-time inventory module |
|---|---|---|
| Setup cost | 0 | 600,000 - 1,500,000 FCFA (one-time) |
| Sales lost to stockouts (15%) | 600,000 FCFA/month | ~150,000 FCFA/month |
| Cash tied up in overstock | 25% of stock | 10 - 12% of stock |
| Management time | 6 h/week | 1 h/week |
| Online / store sync | Manual, lagging | Automatic, instant |
| Reorder alerts | None | Configurable threshold |
If the module recovers just half the sales lost to stockouts, i.e. 450,000 FCFA/month, a 1,000,000 FCFA investment is repaid in a little over two months. The gain from freeing overstocked cash adds on top.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Wanjiru runs a baby-goods shop in Kenya, online and in-store, 3,500,000 FCFA in monthly sales. She managed stock on a spreadsheet updated each evening. Problem: items sold in-store stayed "available" online all day, generating oversells and disappointed customers, and she regularly ran out of size 3 diapers, her best-seller.
She commissions a real-time inventory module at 900,000 FCFA, with threshold alerts and online/store sync. Within three months: no more oversells, stockouts on her best-sellers fall from 18% to 4%, and she recovers about 380,000 FCFA of sales/month previously lost. She also frees 600,000 FCFA of cash by stopping the overstock of slow lines. The module is repaid in under three months.
FAQ
When does an inventory module become worth it? As soon as you sell online and physically at once, or exceed a few hundred SKUs. Sync prevents the oversells and invisible stockouts that cost 10 to 20% of sales.
How much does such a module cost? Expect an order of magnitude of 600,000 to 1,500,000 FCFA depending on the number of warehouses, multi-channel sync and alerts. ROI is usually under six months.
Is a spreadsheet enough at low volume? Yes, as long as you sell on a single channel with few SKUs. The spreadsheet breaks the moment several outlets touch the same stock.
What is a threshold alert? The system automatically warns you when an item drops below a set level, so you reorder before running out. That is what removes the 10-20% of lost sales.
Can you sync online store and physical shop? Yes, it is the core of the module: every sale, online or at the till, decrements the same stock in real time, making oversells impossible.
Let's talk about your project. We build your real-time multi-warehouse inventory module with alerts and online/store sync. 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.

