The verdict in three sentences
A B2B webshop connected to your ERP is only worth it if each client's stock levels and negotiated prices are accurate to the minute, otherwise sales reps go back to the phone. In Miami, a full project with Dynamics 365 Business Central costs 40,000 to 110,000 USD, while in Bordeaux the same scope on Sage 100 runs 25,000 to 60,000 EUR excl. VAT plus 8,000 to 20,000 EUR for the connector (2026 estimates), delivered in 10 to 14 weeks. The return shows quickly: 15% fewer phone orders by month six, and order desk staff handling exceptions instead of data entry.
What a trade customer really expects
A contractor or site manager ordering materials wants three things: to know whether the product is in stock at their branch, to see their price (account discount, job pricing, free delivery threshold), and to find past orders to reorder them. Everything else is secondary. A brochure website's public catalogue meets none of these needs.
| Expected feature | Standard brochure site | Generic B2B shop | B2B shop connected to the ERP |
|---|---|---|---|
| Client-specific pricing | No | Manual entry | Read from the ERP, refreshed every 15 min |
| Stock per warehouse or branch | No | Approximate global stock | Real stock per warehouse |
| History and quick reorder | No | Partial | Unified ERP + web history |
| Credit balance and limit | No | No | Checked before order validation |
| Order created in the ERP | No | CSV export | Automatic, no re-keying |
| Downloadable invoices and delivery notes | No | No | Yes, from the ERP |
The key technical point is sync frequency. A 15-minute interval for stock and prices is enough for most distributors; order creation, however, must be immediate to reserve the goods.
Detailed budget: Bordeaux and Miami
The budget depends mainly on the number of SKUs, the complexity of the pricing grid (cascading discounts, per-family pricing, net job prices) and the state of the data in the ERP.
| Item (2026 ballpark) | Bordeaux with Sage 100 (EUR excl. VAT) | Miami with Dynamics 365 BC (USD) | Timeline |
|---|---|---|---|
| Scoping, product data migration and cleanup | 3,000 to 8,000 | 5,000 to 14,000 | 2 to 3 weeks |
| B2B platform (accounts, pricing, cart, quotes) | 15,000 to 35,000 | 22,000 to 60,000 | 5 to 7 weeks |
| ERP connector (stock, prices, orders, invoices) | 8,000 to 20,000 | 10,000 to 30,000 | 3 to 5 weeks |
| Customer portal (history, delivery notes, invoices, balance) | 3,000 to 10,000 | 4,000 to 12,000 | 1 to 2 weeks |
| Testing, order desk and sales training | 2,000 to 5,000 | 3,000 to 8,000 | 1 to 2 weeks |
| Total | 25,000 to 60,000 + connector | 40,000 to 110,000 | 10 to 14 weeks |
These are market estimates. In Miami, the Microsoft ecosystem dominates among mid-sized distributors: Dynamics 365 Business Central offers modern REST APIs, which makes the connector easier, but US hourly rates (120 to 180 USD) push the overall envelope up. In France, Sage 100 remains very common among distributors; depending on the version (Sage 100cloud, Sage 100 i7), the connector goes through a SQL database, middleware or Sage web services, which explains the 8,000 to 20,000 EUR range.
For running costs, plan 300 to 900 EUR (or USD equivalent) a month for hosting, any middleware licence and corrective maintenance.
Pitfalls to avoid
The first pitfall is starting before cleaning product records: truncated names, missing photos, inconsistent sales units (piece, pallet, square metre). Expect 2 to 3 weeks of work on the distributor's side for 5,000 SKUs. The second is trying to reproduce every historical discount rule on the web: it is better to read the net price calculated by the ERP than to recode the logic. The third is forgetting the sales team: if reps are not commissioned on web orders from their territory, they will slow adoption.
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.
Isabelle is finance and admin director at a building materials distributor in Bordeaux, a profile common among Miami distributors too: 3 branches, 4,800 active SKUs, 1,900 trade customers. The order desk receives 2,600 orders a month, 70% by phone, with an average entry time of 6 minutes.
Illustrative scenario: a 42,000 EUR excl. VAT project plus a 14,000 EUR Sage 100 connector, 56,000 EUR in total. By month six, 15% of phone orders move to the web, about 270 orders a month. At 6 minutes each, the order desk saves 27 hours a month, roughly 1,000 EUR at a loaded cost of 37 EUR per hour. The main gain comes from avoided entry errors (estimated at 1.5% of orders, averaging 80 EUR per dispute) and the web basket, often 8 to 12% larger thanks to related-product suggestions. On these assumptions, payback falls between 24 and 36 months.
FAQ
Do I need to upgrade my ERP to connect a B2B webshop?
Not necessarily. Dynamics 365 Business Central and recent Sage 100 versions (Sage 100cloud v8 and later) expose usable data; on older Sage versions, the connector reads the SQL database, adding 2,000 to 5,000 EUR of development.
Are the displayed prices always the ERP prices?
Yes, if the connector reads client prices and discounts from the ERP every 15 minutes. If the connection drops, the shop shows a price-to-be-confirmed message rather than a wrong price.
Can customers pay online on a B2B catalogue?
Yes, but 60 to 80% of trade customers stay on account with 30 or 45-day terms. Cards or instant transfer are offered to new accounts and cash customers.
How long before customers adopt online ordering?
Among distributors, 10 to 20% of orders move online after 6 months, 25 to 40% after 18 months, provided the sales team actively supports it.
Does Kolonell build this type of project?
Yes, through its e-commerce and custom web application projects. Pricing starts from an audit of your ERP and your pricing grid.
Let's scope your project. Tell us your ERP version, the number of SKUs and customers, and your target date, and we will send you a detailed scope and budget. 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.
