The verdict in three sentences
A Dutch outdoor and mountain gear distributor serving 900 retailers and rental shops across the Benelux cannot open a webshop with a single price list: every account has negotiated discounts. A B2B webshop synced with Sage 100 costs, as a 2026 ballpark in Amsterdam, 30,000 to 55,000 EUR excluding VAT, connector included, and takes about 3 months. A realistic goal is 50 % of orders online within 12 to 18 months, freeing the inside sales team to prospect.
Why the Sage 100 sync is the real topic
In outdoor gear, the season drives everything: pre-orders in February and March, restocks from October to January, and rental shops ordering skis or crampons on Friday for Saturday. A buyer who sees stock online and then hears on the phone that it is sold out will not come back to the portal.
Sage 100 remains the single source of truth: items, product groups, prices, discounts, credit limits, stock per warehouse. The webshop rekeys nothing. It reads the catalogue, the 12 price tiers and stock, then writes orders straight into Sage as sales orders. A sync every 15 minutes is enough in most cases; stock for critical SKUs can be queried live when an item is added to the cart.
| Data | Direction | Recommended frequency |
|---|---|---|
| Items, groups, images | Sage to webshop | Hourly or on change |
| 12 price tiers and account discounts | Sage to webshop | Every 15 minutes |
| Stock per warehouse | Sage to webshop | 15 minutes, live on critical SKUs |
| Credit limit and balance | Sage to webshop | Every 15 minutes |
| Customer orders | Webshop to Sage | Instant |
| Invoice and credit note PDFs | Sage to webshop | Daily |
Budget for a Sage 100 B2B webshop in Amsterdam
The budget splits into two blocks. The webshop itself (account area, catalogue, cart, quick order by SKU, one-click reorder) and the Sage 100 connector, which is often underestimated. The figures below are 2026 market ballparks in the Netherlands for a mid-sized distributor.
| Item | 2026 ballpark (excl. VAT) | Comment |
|---|---|---|
| Discovery and order desk workshops | 3,000 to 5,000 EUR | Map price tiers and discounts |
| Design and trade account area | 5,000 to 9,000 EUR | Quick order, saved lists, history |
| Catalogue and specs (3,000 to 8,000 SKUs) | 5,000 to 9,000 EUR | Sizes, variants, multilingual feeds |
| Account pricing, group discounts, free shipping thresholds | 5,000 to 9,000 EUR | 12 tiers plus exceptions |
| Payment on terms, iDEAL and card for new accounts | 2,500 to 4,500 EUR | Credit read from Sage |
| Testing, training, go-live | 3,000 to 5,500 EUR | 2 to 3 weeks |
| Sage 100 connector | 6,500 to 13,000 EUR | Depends on version and custom fields |
| Total | 30,000 to 55,000 EUR | About 3 months |
At Kolonell, this kind of project is a custom application priced on quote after the discovery workshop. The two variables that weigh most are Sage data quality (duplicate items, legacy discounts) and the number of pricing exceptions. Maintenance follows our public grid: 53, 114 or 183 EUR per month depending on service level. Languages are set in the quote.
Three costly mistakes
First mistake: copying prices into the webshop "to go faster". At the first supplier price change, both systems diverge and the order desk spends its days issuing credit notes.
Second mistake: showing global stock instead of stock per warehouse. A rental shop in the Ardennes supplied from a warehouse near Utrecht does not get the same lead time as a store in Amsterdam.
Third mistake: launching without an activation plan. A B2B portal does not fill itself. Send credentials before the season, demo quick order to the top 100 accounts and give field reps commission on online orders in their territory, otherwise they push back.
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 runs an outdoor gear distributor near Amsterdam. His 4-person order desk keys in 2,600 orders a year received by email and phone, at 18 minutes each, 780 hours a year. He targets 50 % online orders within 18 months.
Calculation: 1,300 fewer manual orders × 18 minutes = 390 hours, about 0.25 FTE, close to 13,000 EUR of loaded cost a year in the Netherlands. Keying errors (2 % of orders, 85 EUR average dispute cost) halve: 1,300 × 2 % × 85 EUR = 2,210 EUR saved. Add 3 % larger baskets from accessory suggestions on 1.9 M EUR of online revenue at 30 % margin: 17,100 EUR of margin. For a 45,000 EUR project, payback is around 17 months.
FAQ
Which Sage 100 version do we need?
Recent Sage 100 releases expose the required data through an SQL database or an API. An older version may require an upgrade, roughly 3,000 to 8,000 EUR depending on the Sage partner.
Can we handle more than 12 price tiers?
Yes, the webshop reads price categories and discounts per account and per product group. Beyond 20 tiers, simplify with the order desk before the project, which also cuts errors.
Is a 15-minute sync enough?
For prices, yes. For stock at peak season, the shop queries Sage live on the 200 to 500 best-selling SKUs, so it never shows false availability.
Can buyers pay on 30-day terms?
Yes, payment method and credit come from Sage. New accounts can be forced to iDEAL or card until approved, with fees of roughly 0.3 EUR per iDEAL payment and 1.5 % to 2.5 % for cards.
How long to reach 50 % online orders?
12 to 18 months for a network of 900 accounts, with an activation plan before the season. The most active 20 % of accounts usually switch within the first 3 months.
Let's scope your project. B2B webshop, 12 price tiers and a Sage 100 connector: we define the scope and a go-live plan of about 3 months ahead of your season. 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.
