The verdict in three sentences
A stockout costs you twice: the lost sale and the acquisition budget already spent to bring that customer to an "out of stock" page, who then leaves for a competitor. Overstock is the opposite mistake: it freezes your cash and depreciates 2 to 3% per month through carrying, obsolescence and breakage. A small online seller does not need an ERP: a calculated safety stock and a connected store module are enough to cut stockouts by 30 to 50% in 2026.
The real cost of both mistakes
You only manage well what you quantify. A stockout is not just a missed sale: it is also the wasted acquisition cost (ads, social, SEO) that drove a customer to an "unavailable" page. Overstock looks free because the goods are "there", but it locks up cash that could have funded other lines.
| Cost item | Stockout | Overstock |
|---|---|---|
| Immediate sale | Lost (100%) | Deferred |
| Customer acquisition cost | Wasted (~2,000-5,000 FCFA) | Recovered |
| Loyalty | Customer lost in ~30% of cases | Neutral |
| Cash | Freed | Locked |
| Monthly carrying | 0 | 2-3% of value/month |
The three tools compared (2026 order of magnitude)
| Criterion | Excel/Sheets spreadsheet | Integrated store module | Dedicated stock app |
|---|---|---|---|
| Setup cost | 0 FCFA | Included in the store | 1,500,000-4,000,000 FCFA |
| Stock update | Manual | Automatic on each sale | Automatic + multi-channel |
| Low-threshold alert | No | Yes | Yes + forecast |
| Error risk | High | Low | Very low |
| Time/week | 4-6 h | 30-60 min | 15-30 min |
| Stockout reduction | Low | 30-50% | 40-60% |
For most small stores, the module integrated into the store offers the best benefit/cost ratio: stock decrements automatically on each paid order and the reorder alert fires on its own.
Calculating your safety stock
Simple 2026 rule: safety stock = average daily sales × supplier lead time × safety coefficient (1.3 to 1.5). If you sell 4 units/day of an item and your supplier delivers in 7 days, safety stock is about 4 × 7 × 1.4 = 39 units. Below that, you trigger the order.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
| Rotation | Sales/day | Lead time | Safety stock |
|---|---|---|---|
| Fast | 8 | 5 days | 56 units |
| Medium | 4 | 7 days | 39 units |
| Slow | 1 | 10 days | 14 units |
Mini case study
Oumar, who runs an online sneaker store, tracked stock on a spreadsheet updated in the evening. Result: about 12 stockouts/month on his best-sellers, each costing a sale of about 35,000 FCFA plus 3,000 FCFA of wasted acquisition, i.e. 456,000 FCFA/month in lost revenue. Switching to an integrated module with threshold alerts, he cut stockouts to 5/month and recovered nearly 300,000 FCFA/month. Since the module was included in his store rebuild, payback came in under two months.
FAQ
At how many SKUs does a spreadsheet become unmanageable? Beyond 40 to 50 active SKUs, a manually updated spreadsheet generates too many errors and delays. Displayed stock no longer matches reality, which causes sales of items you don't have.
How much does overstock really cost? Count 2 to 3% per month of the locked value across carrying, breakage and obsolescence. Overstock of 2,000,000 FCFA therefore costs you 40,000 to 60,000 FCFA per month without showing up in your direct expenses.
Does the stock module handle variants (size, colour)? Yes, a good store manages stock at the variant level, not just the product. It is essential for fashion and footwear, where one size can be out while the model still shows as available.
Can stock be connected to several channels (site + social)? A dedicated app allows it by syncing a single stock. For a single-channel seller, the integrated module is more than enough and costs far less.
Let's talk about your project. We build inventory management with threshold alerts and per-variant tracking straight into your store. 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.
