The verdict in three sentences
Above 100 orders a day, manual re-entry into Sage X3 becomes the main brake on growth for a manufacturer selling online. A custom connector between 15,000 and 40,000 EUR excl. VAT syncs stock, customer prices, orders and invoices, and removes about 1.5 FTE of data entry for 300 daily orders. The real gain also shows in stockouts: stock refreshed within seconds means zero orders sold on unavailable products.
The hidden cost of retyping into Sage X3
In many industrial companies, the webshop (Shopify, PrestaShop, Magento or Sylius) was launched alongside the ERP. Orders arrive by email or CSV export, a team retypes them into Sage X3, and webshop stock is updated once a day, sometimes once a week.
| Indicator | Manual process 2026 | With real-time sync |
|---|---|---|
| Entry time per order | 3 to 5 min | 0 min (exception handling only) |
| FTE needed for 300 orders a day | 1.5 to 2 | 0.2 to 0.3 |
| Annual entry cost (38,000 EUR loaded per FTE) | 57,000 to 76,000 EUR | 8,000 to 11,000 EUR |
| Freshness of displayed stock | 24 h | 5 to 60 seconds |
| Orders on out-of-stock items | 1 to 3% | close to 0% |
| Entry errors (address, quantity, price) | 0.5 to 1.5% | under 0.1% |
| Order to shipment delay | D+1 to D+2 | Same day if ordered before 2 pm |
At 300 orders a day, 2% of stockouts sold means 6 disappointed customers daily, refunds to process and negative reviews that hurt conversion.
What a Sage X3 connector must sync
Sage X3 is a powerful but demanding ERP: its web services (legacy SOAP or GraphQL API in recent versions) require solid knowledge of folders, storage sites and pricing rules. The budget depends mostly on the number of flows and their complexity.
| Flow | Direction | Complexity | 2026 indicative budget |
|---|---|---|---|
| Available stock per warehouse | Sage X3 to webshop | Medium | 3,000 to 7,000 EUR excl. VAT |
| Catalogue, items and variants | Sage X3 to webshop | Medium | 3,000 to 8,000 EUR excl. VAT |
| B2B customer prices and discounts | Sage X3 to webshop | High | 4,000 to 10,000 EUR excl. VAT |
| Web orders | Webshop to Sage X3 | High | 4,000 to 9,000 EUR excl. VAT |
| PDF invoices and credit notes | Sage X3 to webshop | Low | 1,500 to 3,000 EUR excl. VAT |
| Shipping status and tracking | Sage X3 to webshop | Low | 1,000 to 3,000 EUR excl. VAT |
| Total project | 15,000 to 40,000 EUR excl. VAT |
Add 200 to 600 EUR a month for middleware hosting, monitoring and corrective maintenance. Off-the-shelf connectors exist for some platforms, but they rarely cover negotiated customer prices, which are precisely the heart of a B2B shop.
Real time, near real time or nightly batch
The words real time deserve a precise definition in the specification, because they change the architecture and the price.
| Mode | Latency | Load on Sage X3 | Use case |
|---|---|---|---|
| Nightly batch | 24 h | Very low | Stable catalogue, few orders |
| Hourly batch | 60 min | Low | Fewer than 50 orders a day |
| Near real time (polling) | 1 to 5 min | Medium | 50 to 500 orders a day |
| Event-driven real time | 5 to 30 s | Optimised | Tight stock, flash sales, multichannel |
For 300 orders a day with fast-moving products, near real time on stock and real time on orders give the best balance of cost and reliability.
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.
Pieter, operations director of an Amsterdam manufacturer of professional cleaning products, receives 300 orders a day on his B2B webshop. Two full-time employees plus a temp in peak season retype them into Sage X3, so 1.7 FTE at 38,000 EUR loaded: 64,600 EUR a year. On top of that, 2% of stockouts are sold, about 1,500 cancelled orders a year at 12 EUR handling cost each: 18,000 EUR.
The chosen connector costs 28,000 EUR excl. VAT plus 400 EUR a month for maintenance. After go-live, 0.3 FTE remains to handle exceptions (11,400 EUR) and stockouts sold drop to almost zero. Annual gain: 64,600 + 18,000 - 11,400 - 4,800 = 66,400 EUR. Payback in 5 months, and both employees move to customer service.
FAQ
Do we need a recent Sage X3 version to connect a webshop?
It helps: version 12 and later expose more modern APIs. On V11 or earlier, plan 15 to 25% more budget to go through SOAP web services.
How long does the project take?
Between 8 and 14 weeks depending on the number of flows: 2 weeks of scoping with your Sage partner, 4 to 8 weeks of development, 2 to 4 weeks of testing on a test folder.
Does the connector slow Sage X3 down?
Not if it is well designed: a message queue absorbs peaks and limits calls to a few hundred per hour. A poorly built connector that queries all stock every minute can, however, overload the server.
What happens if Sage X3 is down?
Orders are queued in the middleware and imported as soon as the service is back, with no loss. An alert goes to the team if downtime exceeds 15 minutes.
Can we handle several warehouses or web-reserved stock?
Yes, the connector can publish stock per warehouse or a computed web stock (physical stock minus reservations and safety stock). This setup usually adds 2,000 to 4,000 EUR excl. VAT.
Let's scope your project. Tell us your webshop platform, your Sage X3 version and your order volume, and we will price a connector between 15,000 and 40,000 EUR excl. VAT, delivered in 8 to 14 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.
