The verdict in three sentences
In African e-commerce, software is not what is expensive, stockouts and overselling are: an oversell destroys trust and costs 5,000 to 15,000 FCFA per cancelled order (refund, lost delivery, angry customer). A plain spreadsheet holds up to about 100 orders/month; beyond that, a store-integrated inventory module or a light ERP pays off from the very first oversell avoided. The rule: real-time cross-channel sync is always worth more than its price.
Spreadsheet, store module or light ERP
2026 orders of magnitude for a multi-channel store (site + WhatsApp + physical shop) in West Africa.
| Solution | Monthly cost (FCFA) | Real-time sync | Multi-site | Threshold alerts | ROI at 200 orders/month |
|---|---|---|---|---|---|
| Spreadsheet (Excel/Sheets) | 0 | No | Manual | No | negative above 100 orders |
| Integrated store module | 15,000 - 40,000 | Yes | Limited | Yes | positive from 120 orders |
| Light ERP (Odoo, Zoho) | 40,000 - 120,000 | Yes | Yes | Yes | positive from 200 orders |
| Full ERP | 150,000+ | Yes | Yes | Advanced | from 500+ orders |
At 200 orders/month, a 30,000 FCFA/month integrated module pays for itself by avoiding just 2 to 6 oversells. That is almost always reached in the first week.
The real cost of a stockout and an oversell
An unflagged stockout means a customer orders an unavailable product: either you cancel (30-40 % lost) or make them wait (cancellation risk). An oversell on stock shared across channels means two customers for one item.
| Incident | Direct cost per occurrence | Indirect cost | Frequency without sync |
|---|---|---|---|
| Oversell (shared stock) | 5,000 - 15,000 FCFA | bad review, word of mouth | 3-8 %/month of orders |
| Unflagged stockout | 3,000 - 10,000 FCFA | 20-40 % lost customers | 5-12 %/month |
| Inventory discrepancy (theft/error) | variable | unknown shrinkage | 1-3 % of stock/year |
| Dead stock | locked cash | -30 % resale value | 10-25 % of stock |
On 200 orders, 5 % oversells = 10 incidents x 10,000 = 100,000 FCFA/month of damage, versus 30,000 for the module that prevents them.
Mini case study
Fatou, who runs a shoe shop in Dakar with a site and a physical store, manages stock on a spreadsheet. She does 220 orders/month and suffers about 6 % oversells (13 incidents) because site and till are not synced. Cost: 13 x 9,000 = 117,000 FCFA/month, plus 4 unflagged stockouts at 6,000 = 24,000. Total damage: 141,000 FCFA/month.
She adopts a synced inventory module at 35,000 FCFA/month. Oversells fall to 1 % (2 incidents) and stockouts are alerted before running out. New damage: ~30,000. Net saving: 141,000 - 30,000 - 35,000 = 76,000 FCFA/month, i.e. 912,000 FCFA/year.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
When should I drop the spreadsheet?
As soon as you exceed 80-100 orders/month or sell across more than one channel (site + physical + WhatsApp). A spreadsheet does not sync in real time, which makes oversells inevitable.
Is a light ERP overkill for a small shop?
Below 150-200 orders/month, yes: a store-integrated module is enough and costs 3 to 4 times less. A light ERP becomes relevant with several warehouses or points of sale.
How do I manage stock shared between site and physical shop?
You need a single source of truth synced in real time: every sale, whatever the channel, decrements the same stock. It is the only way to eliminate oversells.
Are threshold alerts worth it?
Yes: an alert at 5 units left gives you time to restock before the stockout. It avoids the 20-40 % of customers lost on unavailable products.
Can inventory integrate with delivery and payment?
Yes: a well-built store links stock, mobile-money payment and delivery waybill in a single flow. The order decrements stock, triggers the trip and notifies the customer with no re-entry.
Let's talk about your project. We build stores with real-time synced inventory across all your channels, threshold alerts and delivery integration. 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.
