The verdict in three sentences
A B2B site that sells out-of-stock parts destroys trust faster than it creates revenue. A well-designed ERP integration syncs stock and prices in under 5 minutes and pushes every order into the ERP, for EUR 10,000 to 30,000 (about USD 11,000 to 33,000) and 6 to 10 weeks of work. The decisive choice is architecture: batch sync, real-time events, or querying the ERP directly at checkout.
Three architectures, three levels of freshness
Not all integrations are equal. The right level depends on how fast your stock turns and how much load your ERP can take.
| Architecture | Stock freshness | 2026 cost (excl. VAT) | ERP load | Use case |
|---|---|---|---|---|
| Batch export (nightly CSV) | 12 to 24 h | EUR 3,000 to 6,000 | Low | Slow catalog, few stock-outs |
| Scheduled API sync | 5 to 15 min | EUR 10,000 to 18,000 | Medium | Most common case |
| Real-time events (webhooks, message queue) | Under 1 min | EUR 18,000 to 30,000 | Low to medium | High turnover, multi-warehouse |
| Direct query at checkout | Instant | EUR 12,000 to 22,000 | High | Low volume, highly variable prices |
| iPaaS middleware (off-the-shelf connector) | 5 to 15 min | EUR 6,000 to 15,000 + EUR 300 to 1,200/month | Medium | Standard ERP (SAP Business One, Sage, Odoo, NetSuite) |
For most distributors, an incremental sync every 2 to 5 minutes, backed by a stock check at order confirmation, offers the best reliability-to-cost ratio.
What must flow between the site and the ERP
Stock is only part of the picture. A complete integration covers data in both directions.
| Flow | Direction | Target frequency | Expected gain |
|---|---|---|---|
| Available stock per warehouse | ERP to site | 2 to 5 min | Out-of-stock sales down 80% |
| Customer prices and discounts | ERP to site | 5 to 15 min | No more disputed price gaps |
| Confirmed orders | Site to ERP | Under 1 min | No re-keying, 4 to 6 min saved per order |
| Shipping status and tracking number | ERP to site | 15 min | "Where is my order" calls down 50% |
| Invoice and credit-note PDFs | ERP to site | Daily | Self-service customer area |
| New customer accounts | Site to ERP | Under 5 min | Account opening in 24 h instead of 3 days |
The most sensitive technical point is stock reservation: between add-to-cart and ERP injection, two customers can buy the last part. A check at payment and a clear rule (15-minute reservation, or a stated lead time if stock hits zero) solve it.
Typical 8-week project plan
Weeks 1 and 2: audit of the ERP, available APIs and business rules (units, pack sizes, multi-warehouse). Weeks 3 to 6: flow development, error handling, automatic retry queue. Weeks 7 and 8: tests on live data, cutover and monitoring. An alert dashboard flags any flow blocked for more than 10 minutes.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Julie, e-commerce manager at a technical parts distributor in Lille (bearings, power transmission, hydraulics), handles 1,200 online orders a month. Site stock updates once a night: 9% of orders are cancelled due to stock-outs.
- Current cancelled orders: 108 a month, average order EUR 420, so EUR 45,360 of revenue lost or delayed each month.
- After integration (cancellations down 80%): 22 cancelled orders, 86 saved, so EUR 36,120 a month.
- At a 28% gross margin: about EUR 10,100 of margin protected each month.
- Project cost: EUR 22,000, plus EUR 250 a month for monitoring.
The integration pays back in just over 2 months, before counting eliminated re-keying time or customers who never return after a cancellation.
FAQ
Our ERP is old. Is integration still possible?
Yes, in the vast majority of cases. Without an API, we read the database or scheduled exports through an intermediate connector, which adds EUR 3,000 to 6,000 and limits freshness to 5 to 15 minutes.
Middleware or custom development?
An iPaaS suits standard ERPs and simple flows at EUR 300 to 1,200 a month. Custom development costs more upfront but nothing in licences, and handles complex business rules better.
What happens if the ERP goes down?
Orders are held in a queue and replayed automatically when the ERP returns. The site keeps selling on the last known stock, with a safety buffer of 1 to 2 units per SKU.
How soon will cancellations drop?
From the first month in production. Distributors typically measure a 70 to 85% drop in stock-out cancellations over the first 30 days.
Let's scope your project. Tell us your ERP, warehouses and order volume: we will price a stock and order integration between EUR 10,000 and 30,000, delivered in 6 to 10 weeks. 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.
