The verdict in three sentences
In 2026, combining a physical store, an e-commerce site and Instagram sales without synced inventory leads straight to overselling: two customers buy the last item, one gets refunded and leaves a one-star review. An inventory module with real-time sync and a WhatsApp alert to the owner costs far less than a damaged reputation. The rule: every sale, whatever the channel, decrements one single stock, and the reorder threshold fires on its own.
Manual stock vs real-time sync
The Excel file updated "in the evening" is the classic trap: between two updates, several channels sell the same item. Real-time sync removes that risk window.
| Criterion | Excel / manual | Real-time sync |
|---|---|---|
| Typical inventory gap | 5 to 12% | 1 to 2% |
| Oversell window | Hours to days | Near zero |
| Threshold alert | None | Auto WhatsApp/SMS |
| Multichannel view | Fragmented | Unified |
| Management time/week | 4 to 8 h | 30 to 60 min |
| Cost of an error | High | Rare |
The 5 to 12% inventory gap in manual management is not abstract: on 3,000,000 FCFA of tied-up stock, that's 150,000 to 360,000 FCFA of "ghost" merchandise you think you have but that's missing.
The real cost of an oversell
| Item | Estimated 2026 cost per incident |
|---|---|
| Refund + mobile money fees | 1 to 2% of the amount |
| Customer handling time | 30 to 60 min |
| Wasted delivery already dispatched | 1,500 to 4,000 FCFA |
| Negative review (lost future sales) | High, hard to quantify |
| Average total cost per oversell | 12,000 to 20,000 FCFA |
A smart alert threshold isn't set at an arbitrary round number: it's calculated from sales velocity and supplier lead time. If you sell 3 units/day and reordering takes 10 days, your alert threshold should be at least 30 units, plus a safety margin.
| Product | Sales/day | Supplier lead time | Recommended alert threshold |
|---|---|---|---|
| Fast mover | 5 | 7 days | 45 units |
| Medium mover | 2 | 14 days | 35 units |
| Slow mover | 0.5 | 21 days | 15 units |
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
Emeka runs an accessories store in Lagos: physical shop, website and Instagram page. Managing stock in a notebook, he oversells about 6 items/month. Observed average cost: 15,000 FCFA per oversell, i.e. 90,000 FCFA/month in direct losses, not counting reviews. He installs a real-time sync module with WhatsApp alerts. Oversells drop to under one a month. Net saving: about 75,000 FCFA/month, plus reliable stock to decide when to reorder.
FAQ
What's the typical inventory gap in manual management? Between 5 and 12% of stock. On 3,000,000 FCFA of stock, that's 150,000 to 360,000 FCFA of miscounted goods.
What does an oversell really cost? On average 12,000 to 20,000 FCFA per incident: refund, mobile money fees, time, a delivery dispatched for nothing and, above all, the negative review.
How do I set the right reorder threshold? Multiply sales velocity by supplier lead time, plus a margin. Three sales/day and a 10-day lead time require a threshold around 30 to 40 units.
Is the WhatsApp alert really useful? Yes: the owner gets a notification as soon as an item drops below threshold, leaving time to order before the stockout, covering a supplier lead time of 3 to 21 days.
What's the ROI of an inventory module? By eliminating most oversells, a store losing 90,000 FCFA/month often saves 70,000 to 80,000 FCFA monthly, a payback within weeks.
Let's talk about your project. We sync your sales channels with automatic stock alerts. 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.
