The verdict in three sentences
As long as you sell on one channel, a notebook or spreadsheet is enough; the moment the same stock feeds your online store, WhatsApp, Instagram and Jiji, the risk of overselling explodes. The point where automation pays off sits around 50 to 100 orders per month, when every cancellation costs you a customer and your reputation. The right answer is not the priciest software but a single source of truth for stock, updated in real time.
The real problem: overselling across channels
Overselling happens when two buyers reserve the last unit on two different channels before either stock count is decremented. The result: a cancelled order, a Paystack refund, and often a bad review. In markets where online trust is already fragile, one cancellation weighs heavily.
Three disciplines cut the risk before you even buy a tool:
- SKU discipline: every variant (size, colour) gets a unique code, never reused.
- Stock buffer: hide the last 1 to 2 units of a high-demand item to absorb sync lag.
- Master channel: one channel is authoritative for the count; the others align to it.
Sync methods compared (2026)
| Method | Annual cost (rough order) | Oversell risk | Suited volume |
|---|---|---|---|
| Manual (notebook / memory) | 0 | Very high | < 20 orders/month |
| Shared spreadsheet (Google Sheets) | 0 | High | 20-50 orders/month |
| Light ERP (Odoo Community) | NGN 250k-1m (hosting + setup) | Low | 50-300 orders/month |
| Custom module (store + webhook) | NGN 500k-1.5m (one-off dev) | Very low | > 200 orders/month |
| Friction point | Spreadsheet | Light ERP | Custom module |
| Real-time update | No (manual) | Near (scheduled sync) | Yes (webhook) |
| Multi-user | Limited | Yes | Yes |
| Low-stock alerts | No | Yes | Yes |
| Shop POS link | No | Yes (Odoo POS) | Custom |
| Learning curve | Low | Medium | None (invisible) |
Mini case study
Chidinma runs a fashion store in Lagos. She sells on her own store, Instagram DMs and Jiji, with 80 orders a month and an average basket of NGN 22,000. On manual stock she oversold roughly 6 orders a month, each cancelled: that is 6 × 22,000 = NGN 132,000 in lost sales, plus refund time.
She moves to a light ERP at NGN 45,000/month (about NGN 540k/year all in). Oversells drop below one order a month. Net monthly gain: about NGN 120,000 recovered − 45,000 tool = NGN 75,000, not counting the reviews she keeps. The tool pays for itself in the first month.
FAQ
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
At how many orders should I automate?
Below 50 orders a month, a disciplined shared spreadsheet works. Between 50 and 100 a light ERP pays off; beyond that, a custom module wired to your store is fully justified.
How much does Odoo cost for a small shop?
The Community edition software is free; hosting and setup are the cost, a rough order of NGN 250k to 1m per year depending on support.
Does a stock buffer lose sales?
Marginally: hiding 1 to 2 units of a hot item costs a few sales but avoids cancellations that cost far more in trust and refunds.
Can WhatsApp sync automatically?
Yes, through the WhatsApp Business catalogue linked to an ERP or your store by API; otherwise WhatsApp stays a manual master channel that points to your store for payment and counting.
Do I need a barcode scanner in the shop?
Not at first, but past 300 orders/month a POS with scanning sharply cuts entry errors and speeds up checkout.
Let's talk about your project. We sync your stock across online store, WhatsApp and shop to kill oversells. 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.
