The verdict in three sentences
Stock auto-decremented on every order stops you from selling a product that no longer exists. An alert threshold set at 10-15% of monthly volume warns you before the stockout, and a safety stock absorbs demand spikes. Together, these three settings move unflagged stockouts from ~12% to ~3% and avoid refunds that each cost far more than the product's margin.
The real cost of an oversell
An oversell (selling more than actual stock) is never free. It triggers a refund, transaction fees, customer-service time and, above all, a lasting negative review.
| Oversell cost item | Estimated 2026 amount |
|---|---|
| Refund (average basket) | 22,000 FCFA |
| Non-recovered transaction fees | 300-700 FCFA |
| Customer service time (30 min) | ~2,500 FCFA |
| Negative review impact (future loss) | 4,000-6,000 FCFA |
| Real total cost per oversell | ~8,500 FCFA (excl. refunded basket) |
Across 8 oversells/month, the hidden loss exceeds 68,000 FCFA/month, before counting the long-term drag of negative reviews.
Manual vs automatic stock
| Criterion | Manual stock (spreadsheet) | Automatic stock (decrement) |
|---|---|---|
| Update after a sale | Manual, delayed | Instant |
| Oversell risk | High (~12%) | Low (~3%) |
| Low-threshold alert | None | Automatic |
| Management time / week | 5-7 h | 1-2 h |
| Multi-channel reliability | Low | High |
| Stockout reduction | Baseline | -70% |
Auto-decrement isn't a comfort feature: it's the foundation of a store that keeps its promises.
Setting alert threshold and safety stock
The optimal alert threshold sits around 10-15% of monthly units sold, to leave time to restock. Safety stock covers supplier lead time: if a restock takes 10 days and you sell 3 units/day, keep at least 30 units as a buffer. Tune per product: a best-seller deserves a higher threshold than a long-tail item.
Mini case study
Fatou runs an online cosmetics store in Nairobi but budgets in FCFA for her West African sourcing. She sells 40 units/month of her flagship serum. Without an alert, she went out of stock 3 days/month and lost ~5 sales at 15,000 FCFA each. By setting an alert threshold of 6 units (15%) and a safety stock of 12 units, she no longer misses a sale: +75,000 FCFA/month recovered, from a setup that took 20 minutes.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
At what level should I trigger an alert?
Between 10 and 15% of your monthly volume per product. For an item sold 40 times/month, alert around 4 to 6 units left, factoring in your restock lead time.
Does automatic stock handle in-store sales?
Yes if the register is linked to the same stock. Unified online and in-store stock stops you selling the same piece twice across two channels.
What about a product that's constantly out of stock?
Raise its safety stock and alert threshold, or offer pre-order. A repeat stockout on a best-seller is margin left on the table.
How much does this feature cost?
Stock management with alerts is included from Kolonell's Growth e-commerce tier (2,000,000 FCFA / about 3,050 EUR), with analytics dashboard and shipping calculation.
Can I show "only 3 left" to the customer?
Yes, and it's a strong urgency lever. Showing low stock can lift conversion while staying transparent, as long as the number is real.
Let's talk about your project. We set up automatic stock with alerts and thresholds tuned to each of your products. 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.
