Shopify Sage 200 integration: connector or custom?

How to connect Shopify to Sage 200: what needs to sync, connector apps or a custom integration, what it costs, and where integrations go wrong.

/6 min read/EC Web

Shopify and Sage 200 don't talk to each other out of the box. There's no built-in link from Shopify or from Sage, so every order, stock level and trade price has to cross the gap somehow. For a lot of businesses that means someone re-keying orders into Sage each morning and updating stock in Shopify by hand.

There are two ways to fix it: a ready-made connector, or a custom integration built on the Sage 200 API. Most stores should start with a connector. This post covers what needs to sync, how to choose between the two, and the problems we see most often once the data starts moving.

What needs to sync

Before you compare tools, write down which system is in charge of each kind of data. Most of the trouble with a Sage 200 integration comes from two systems both thinking they own the same thing.

DataUsual directionWhat to decide
OrdersShopify to Sage 200Whether each order becomes a sales order, an invoice, or part of a daily summary
Customers and trade accountsBoth waysWhich system creates the account, and how a web customer is matched to an existing Sage account
Stock levelsSage 200 to ShopifyHow often stock updates, and which warehouse counts as available
Products and pricesUsually Sage 200 to ShopifyWhether descriptions and images stay in Shopify while codes and prices come from Sage
Despatch and trackingSage 200 to ShopifySo customers get their shipping email with a tracking number
Payments and refundsShopify to Sage 200How Shopify Payments payouts, fees and refunds land in your bank reconciliation

A typical setup keeps Sage 200 in charge of stock, product codes and trade prices, and keeps Shopify in charge of how products look online. Orders flow into Sage, and stock and tracking flow back.

Check which Sage 200 you're on

Sage 200 comes in two editions, and it affects how an integration connects.

Sage 200 Standard runs in the cloud and is hosted by Sage. You get the standard features and can't customise them much.

Sage 200 Professional runs on your own server or is hosted for you by a Sage partner. It can be customised and extended with extra modules.

Both editions have an API, which is how connectors and custom integrations read and write data. If you're on Professional on your own server, the integration needs a secure way to reach that server. Ask your Sage partner which edition and version you're on, and whether API access is switched on, before you buy anything.

Option 1: a connector app

Several UK companies sell ready-made Shopify and Sage 200 connectors, including Zynk, Patchworks, Besyncly, Codeless Platforms and Red IT. They cover the common flows: orders into Sage, stock back to Shopify, and customers and products both ways. We're not affiliated with any of them.

A connector is the right choice when your process is fairly standard. You sell to consumers, perhaps with a few trade accounts. You run one Shopify store and you're happy for orders to go into Sage in a set format. You pay a monthly fee to the connector company, and setting it up well usually takes hours rather than weeks.

The set-up is where most connectors go wrong. The defaults rarely match your nominal codes, VAT rules or warehouse setup, so check them against real orders before you switch it on. That includes a refund, a discount code and an order with free shipping.

Option 2: a custom integration

A custom integration uses the Sage 200 API directly, so it can follow your rules exactly. It costs more up front, but there's no per-order fee, and you own the code. It makes sense when:

  • You sell trade and retail from Shopify. Your Sage 200 price bands need to become Shopify B2B catalogues, with each trade customer linked to the right company and payment terms. Shopify B2B now comes with every plan, but below Plus you get three catalogues, so we often map several Sage price bands onto those three, or move you to Plus.
  • You run several stores or sell on marketplaces. Orders from a UK store, an EU store and Amazon or Zalando all need to reach one Sage company in the right currency.
  • Your order flow is unusual. For example, made-to-order products, back orders that ship in parts, or orders that need approval before they go to the warehouse.
  • The connector costs more than it saves. Some connectors charge per order. At high volume, a custom integration can cost less over two or three years.

We build custom integrations from £8,000 at a fixed price. They usually take three to six weeks, including a period running alongside your current process to check the numbers match.

Where Sage 200 integrations go wrong

These problems come up whichever route you choose. Plan for them early and the launch is much calmer.

Duplicate orders. If a request times out and the system tries again, Sage can end up with the same order twice. Each order needs to be matched on a fixed ID, so a retry can never create a second copy.

SKUs that don't match. Shopify variants and Sage product codes need to match one to one. A size or colour that exists in Shopify but not in Sage will stop the order. Clean this up before go-live.

Payouts that don't reconcile. Shopify Payments pays out the order total minus fees and refunds, often days later and in batches. If orders and payments go into Sage separately, your accounts team needs a clear way to match them, or month end gets painful.

Discounts, shipping and VAT. A discount code, a free-shipping order and a mixed basket of zero-rated and standard-rated goods each need to post correctly. Test all three before launch.

Stock at busy times. If stock only updates every hour, you can oversell during a sale. Check how often the connector updates, and update sooner for fast-selling lines.

Nobody notices when it stops. An integration that fails quietly is worse than none. Every failed order should raise an alert and appear on a list someone checks each day.

How we'd approach it

We start with a free integration review. We look at your Sage 200 edition, how you trade and what needs to move, then tell you whether a connector will do the job. If it will, we can set it up at £125 an hour, usually in a few hours. If it won't, we'll give you a fixed price for a custom build.

Either way, we test it against your real orders before it goes live, and run it alongside your current process until the numbers match. If you sell wholesale, our post on Shopify B2B: native, custom, or both? covers the storefront side.

Quick answers

Does Shopify integrate with Sage 200? Not out of the box. Neither Shopify nor Sage provides a built-in link, so you need a connector app or a custom integration built on the Sage 200 API.

What is the best Shopify Sage 200 connector? It depends on your order flow, so we don't name one for everyone. Zynk, Patchworks, Besyncly, Codeless Platforms and Red IT all offer Shopify and Sage 200 connectors. Compare them on the flows you need, how they handle refunds and payouts, and their support, not on the feature list.

How much does a Shopify Sage 200 integration cost? A connector costs a monthly fee plus set-up, which usually takes a few hours. A custom integration with us starts from £8,000 at a fixed price and takes three to six weeks.

Can Sage 200 price bands work with Shopify B2B? Yes. Each trade customer becomes a Shopify company with the right catalogue and payment terms. Below Shopify Plus you get three catalogues, so several Sage price bands may need to share one, or you may need Plus.

If you're re-keying Sage 200 orders or stock by hand, book a free integration review and we'll tell you which route fits. More on how we connect Shopify to Sage, NetSuite and other systems is on our Shopify ERP integration page.

Tell us what you’re working on

Book a free thirty-minute call. You’ll come away with a clear next step, whether that’s a proposal, an existing app that already does the job, or a simpler way to get there. We reply within a working day.