The verdict in three sentences
A Kampala store selling in person, on its website and via WhatsApp runs three storefronts but should run one single stock. Without synchronization, 9% of orders are oversells in 2026 and the owner loses 2.4 hours a day recounting and arbitrating. Central stock with real-time deduction brings oversells down to 1.5%, frees 11 hours a week and cuts inventory variance by four.
Shared spreadsheet vs central system
Many start with a shared file, but the spreadsheet is never up to date when three channels sell at once. The central system deducts stock on every sale, whatever the channel.
| Criterion | Shared spreadsheet | Real-time central system |
|---|---|---|
| Oversell rate | 9% | 1.5% |
| Recounting time / day | 2.4 h | ~15 min |
| Inventory variance | Base | Divided by 4 |
| Cross-channel update | Manual, delayed | Instant |
| Double-sale risk | High | Low |
| Hours freed / week | 0 | 11 h |
Sync architecture and cost
The principle: a single source of truth for stock, fed by every point of sale and read by every channel. Each sale, in store or on WhatsApp, immediately deducts shared stock.
| Component | Role | 2026 order of magnitude |
|---|---|---|
| Central stock database | Single source of truth | included |
| E-commerce site connection | Deduct on order | included |
| Physical store till | Deduct at checkout | 300,000 - 700,000 FCFA |
| WhatsApp gateway | Deduct on confirmed order | 200,000 - 500,000 FCFA |
| Low-threshold alerts | Restock before stock-out | included |
| Total implementation cost | Full project | 900,000 - 2,200,000 FCFA |
2026 rule: every channel must write to the same database and read real stock before confirming an order. Low-threshold alerts prevent stock-outs on fast-moving SKUs.
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
Sarah runs a shoe store in Kampala across three channels: 300 sales a month, 20,000 FCFA average basket. With her spreadsheet, 9% oversells, i.e. 27 cancelled or refunded orders, plus disappointed customers: about 540,000 FCFA of lost revenue and refunds a month. She installs central stock: oversells drop to 1.5%, i.e. 4 or 5 orders, so she recovers the equivalent of 22 sales, i.e. 440,000 FCFA a month, and saves 11 hours weekly. The 1,400,000 FCFA project pays off in just over three months.
FAQ
Why isn't a shared spreadsheet enough? Because it is never up to date the second three channels sell at once. Result: 9% oversells in 2026 and 2.4 hours a day of manual recounting.
How much does multichannel stock sync cost? A 2026 order of magnitude is 900,000 to 2,200,000 FCFA depending on the number of channels and the physical till to connect. The return comes from avoided oversells and freed hours.
Can WhatsApp be synced with stock? Yes, via a gateway that deducts stock as soon as a WhatsApp order is confirmed. It is essential if WhatsApp is one of your big sales channels in Kampala.
How much time do you really save? About 11 hours a week freed from recounting and arbitration, going from 2.4 hours of daily management to about 15 minutes. That time goes back into selling.
What oversell rate should I target? Below 1.5%. Above that, each oversell costs a refund, an unhappy customer and often a negative review, far more than the order itself.
Let's talk about your project. We set up real-time central stock that syncs store, website and WhatsApp to eliminate your 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.
