The verdict in three sentences
In Accra, a retailer selling in-store and online without synced stock suffers 5-12% oversell: they sell an item already gone, then apologise and refund. Conversely, they block sales out of fear of stockouts, losing GHS 200-400 per abandoned basket. A real-time inventory module removes both problems and usually pays for itself in under 4 months.
Spreadsheet, stock software or integrated e-commerce module
Your tool choice drives your error rate and the hours you spend. Here are the 2026 orders of magnitude in Accra.
| Metric | Excel spreadsheet | Dedicated stock software | Integrated e-commerce module |
|---|---|---|---|
| Store + online sync | Manual | Semi-auto | Real time |
| Oversell rate | 5-12% | 2-5% | < 1% |
| Stocktaking time/month | 4-8 h | 2-4 h | < 1 h |
| Reorder threshold alerts | No | Yes | Yes |
| Multi-warehouse | Hard | Yes | Yes |
| Cost 2026 | ~GHS 0 | GHS 150-400/month | Included in store |
The spreadsheet is free but costs dearly in errors and hours. The integrated module drops oversell below 1% and removes double entry.
What a stockout or oversell really costs
In Accra, a stockout or oversell costs more than the lost sale: it damages trust. Here is the estimated impact per incident.
| Incident type | Estimated direct cost | Indirect effect |
|---|---|---|
| Oversell (item already sold) | GHS 200-400 | Refund + disappointed buyer |
| Unanticipated stockout | GHS 200-400 | Lost basket, buyer goes elsewhere |
| Monthly manual stocktake | 4-8 h of time | Data-entry errors |
| Late reorder | Reduced margin (rush) | Missed sales |
At 10 incidents/month at GHS 300, that's GHS 3,000/month — far above the cost of an integrated module.
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
Kofi runs two fashion shops in Accra plus an online sales page. Without sync he has 8 oversells/month at GHS 300 = GHS 2,400/month in refunds and disputes, plus 6 hours of manual stocktaking.
He moves to an online store with a real-time inventory module (included in his e-commerce package). Oversell drops below 1%, roughly 1 incident/month. Direct saving: ~GHS 2,100/month, plus 6 hours recovered. The module's cost is recovered in under 3 months, and reordering becomes driven by threshold alerts.
FAQ
What is oversell and why is it so costly? It's selling an item already gone elsewhere. In Accra it costs GHS 200-400 per case between refund, fees and lost trust.
Is a simple spreadsheet enough to start? At the very start yes, but once you sell in-store and online, the spreadsheet drives 5-12% oversell and 4-8 hours of manual stocktaking per month.
How fast does a stock module pay for itself? Usually under 4 months, because it removes oversell and stocktaking hours. At 10 incidents/month at GHS 300, savings quickly exceed cost.
Is multi-warehouse manageable for two shops? Yes, an integrated module assigns stock per outlet and warehouse, with threshold alerts for each location.
Do threshold alerts prevent stockouts? Yes: as soon as an item falls below the set threshold, you get a notification to reorder before it runs out, protecting your online sales.
Let's talk about your project. We sync your in-store and online stock in real time to eliminate oversell and stockouts. 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.
