The verdict in three sentences
Selling the same stock in store, on your website and on 3 marketplaces without automatic synchronization means accepting overselling: about 40 cancelled orders a month for a diving equipment distributor in Dublin, with penalties and degraded seller ratings as a result. A custom connector between the ERP and the sales channels costs 15,000 to 40,000 EUR in 2026 and is delivered in 8 to 10 weeks, against off-the-shelf middleware at 200 to 800 EUR per month. With sync every 5 minutes and per-channel safety stock rules, cancellations drop by about 90%.
Where overselling comes from, and why it is expensive
The scenario is common: a regulator stays listed as available on a marketplace while the last unit has just been sold in the Dublin store. Stock is updated by manual import once or twice a day, each channel has its own catalogue and returns are not reintegrated in real time.
| Consequence (2026 order of magnitude) | Estimated monthly impact for 40 oversells | Comment |
|---|---|---|
| Cancelled orders | 40 orders, average basket 180 EUR | 7,200 EUR of lost revenue |
| Marketplace penalties | 2 to 5 EUR per cancellation, plus ranking loss | Cancellation rate above 2.5% monitored |
| Seller rating | Lower visibility in search results | Lasting effect on future sales |
| Customer service | 15 to 20 minutes per cancellation | 10 to 13 hours per month |
| Manual stock updates | 1 h per day | About 22 hours per month |
| Lost customers | Some never come back | Acquisition cost paid again |
Beyond lost revenue, the real risk is suspension of the seller account on a marketplace if the cancellation rate exceeds the platform's thresholds.
Off-the-shelf middleware or custom connector
| Criterion | Off-the-shelf multichannel middleware | Custom connector |
|---|---|---|
| Upfront cost | 500 to 3,000 EUR of setup | 15,000 to 40,000 EUR |
| Recurring cost | 200 to 800 EUR per month, often volume-based | 150 to 400 EUR per month of hosting and maintenance |
| Sync frequency | 15 to 60 minutes depending on the plan | Every 5 minutes, or real time by webhook |
| ERP compatibility | Good with common ERPs, weak with niche ones | Built for your ERP and your POS |
| Business rules | Global safety stock | Rules per channel, per family, per supplier (drop-ship stock) |
| Bundles and variants | Varies | Bundles (wetsuit, mask, fins) broken down into components |
| 5-year cumulative cost | 12,500 to 51,000 EUR | 24,000 to 64,000 EUR |
Middleware is a good choice if your ERP is standard and your rules simple. Custom becomes relevant when you sell bundles, multiple sizes, or supplier stock shipped direct, all common in diving equipment, and when middleware fees grow with your order volume.
Architecture and typical timeline
| Component | Role | Duration |
|---|---|---|
| Single product master | Mapping of ERP, website and marketplace references (EAN, seller SKU) | 2 weeks |
| Available stock engine | Physical stock minus reservations, minus per-channel safety stock | 2 to 3 weeks |
| Channel connectors | E-commerce site, 3 marketplaces, in-store POS | 3 to 4 weeks |
| Order intake | Channel orders reserved in the ERP in under 5 minutes | Included |
| Monitoring | Variance alerts, sync log, automatic retry | 1 week |
| Total | 8 to 10 weeks |
The rule that makes the difference: hold a per-channel safety stock on low-quantity SKUs. With 2 units left, show 1 on marketplaces and keep the last one for the store and the website.
Mini case study
Ciaran, owner of a diving equipment distributor in Dublin, sells in store, on his website and on 3 marketplaces. He suffers 40 oversells a month and spends 1 hour a day updating stock. Illustrative scenario: a custom connector at 25,000 EUR, with 300 EUR per month of maintenance.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Cancellations down 90%: 36 orders saved per month at 180 EUR, so 6,480 EUR of revenue, about 1,950 EUR of gross margin at 30%.
- Time saved: 22 hours of updates and 10 hours of customer service per month, 32 hours at 40 EUR loaded, about 1,280 EUR.
- Estimated monthly gain: about 3,230 EUR, minus 300 EUR of maintenance.
The connector pays back in about 9 months, not counting the better marketplace visibility that comes with a near-zero cancellation rate.
FAQ
Is syncing every 5 minutes enough?
For a distributor handling 50 to 300 orders a day, yes in almost every case. Combined with per-channel safety stock, it eliminates about 90% of oversells.
Our ERP is old, is it compatible?
If the ERP exposes a database or exports, a connector can plug into it. Allow 3,000 to 6,000 EUR more when there is no API at all.
How are customer returns handled?
A return approved in the warehouse puts stock back in the ERP, then the connector publishes the new quantity on every channel at the next cycle, in under 5 minutes.
Can we add a fourth marketplace later?
Yes. Since the product master and stock engine are shared, each new channel usually costs 3,000 to 7,000 EUR and 1 to 2 weeks.
What happens if a marketplace is down?
Updates are queued and replayed automatically, with an alert if the gap lasts more than 30 minutes.
Let's scope your project. Tell us your ERP, your sales channels and your order volume: we will price the connector, an indicative budget and a go-live timeline. Detailed quote within 48 h. 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.