Start a project

Shopify ERP Integration: How to Connect Shop and Back Office

Shopify ERP integration explained: what to sync, which direction, the options, the cost drivers and the mistakes that cause overselling and bad stock.

7 min read E-commerce
Parcels and shipping boxes ready to dispatch, representing orders flowing from a shop to the back office

Shopify ERP integration means your online shop and your back-office system exchange data automatically: orders flow into the ERP, stock levels flow back to the shop, and products, prices, customers and refunds stay consistent between them. Done well, nobody retypes an order or fixes stock by hand. Done badly, you oversell, invoice the wrong amount and lose a day each week to reconciliation.

The technical connection is the easy part. The hard questions are which system owns which piece of data, what happens when the two disagree, and who notices when a sync fails. This guide covers those decisions, the connection options and a sensible rollout.

Why a shop needs an ERP behind it

Shopify is excellent at selling: catalogue, checkout, payments and customer accounts. It is not designed to run purchasing, warehouse-level stock control, manufacturing, landed costs or full accounting. Once you hold stock in more than one place, buy on a schedule or make what you sell, the shop becomes one input to a larger process.

The signs that you have reached that point are familiar:

  • Someone exports orders to a spreadsheet every day to pick and invoice them.
  • Stock in the shop differs from stock on the shelf, and customers receive apologies.
  • You sell the same products on a marketplace or in a trade channel with its own prices.
  • Your accountant asks for sales by VAT rate and channel and the answer takes hours.
  • Purchasing relies on someone remembering which lines are running low.

If most of these sound familiar, the shop and the back office need to share data. For a view of what the back-office side does, see what ERP software is.

What to sync, and in which direction

Every integration is a list of data flows. For each one, decide a single owner. The owner is the system where the data is edited; the other system receives a copy.

DataUsual ownerDirectionWhy it matters
Product master (SKU, cost, weight)ERPERP to shopOne SKU per item across all channels
Product marketing contentShopShop only, or shop to ERPCopy and images change often and belong to merchandisers
PricesERP or shop, never bothOne wayPrevents two price lists drifting apart
Stock levelsERPERP to shopStops overselling
OrdersShopShop to ERPTriggers picking, invoicing and accounting
Fulfilment and trackingERP or warehouseERP to shopCustomer notifications and order status
Refunds and returnsShop initiates, ERP booksBoth waysCredit notes and restocking must match
CustomersShop for consumers, ERP for trade accountsShop to ERPAvoid duplicate records

Three ways to connect Shopify to an ERP

A ready-made connector or app

Quick to start and fine for standard flows: orders in, stock out, simple tax mapping. The limits appear when you have bundles, several warehouses, custom pricing or unusual VAT handling. Connectors are usually paid monthly, so look at what you pay across a year.

An integration platform

A middle layer lets you map fields, add rules and monitor failures without writing a full application. It suits companies with a few systems to join and some logic to express. You still need someone to own it.

A custom integration

Built against Shopify's APIs and your ERP's interface, with exactly your rules. It costs more at the start and needs maintenance when either side changes, but it is the right answer for complex fulfilment, several brands or high order volumes. Our custom software team builds these.

A step-by-step rollout

  1. Map the order-to-cash journey on paper, from basket to bank, and mark every manual step.
  2. Choose a single owner for each data item in the table above.
  3. Clean the product master first: unique SKUs, consistent units, correct weights and costs.
  4. Build or configure the order flow, including discounts, shipping lines, VAT and refunds.
  5. Add stock sync with a safety buffer for fast-moving items.
  6. Test with realistic orders: split shipments, cancellations, partial refunds, gift cards, an out-of-stock race.
  7. Run in parallel for a short period while someone compares totals daily.
  8. Switch over, with alerts on every failed sync.

What drives the cost

Integration is usually priced by complexity rather than by size. A shop with one warehouse and plain products is a small job, whereas bundles, several stock locations and trade pricing multiply the rules that must be built, tested and maintained.

There is no honest flat price, because the cost depends on a handful of factors:

  • The number of data flows and how many are two-way.
  • The number of stock locations, channels and currencies.
  • Custom rules: bundles, tiered pricing, pre-orders, subscriptions.
  • The quality of your existing product and customer data.
  • Whether your ERP exposes a usable interface or needs adapting.
  • The monitoring and support you want after launch.

Worked example, with assumptions stated: a shop sells 300 orders a month and each takes four minutes to re-key, check and invoice by hand. That is 20 hours a month. At £15 an hour of loaded cost, manual handling costs £300 a month before counting errors, which is the figure to compare against the cost of integration.

Common mistakes

  • Letting two systems edit the same field, so changes overwrite each other.
  • Syncing stock too slowly during sales, which causes overselling.
  • Ignoring refunds and cancellations until the first month-end mismatch.
  • Mapping VAT loosely, then discovering the ledger does not match returns.
  • No alerting, so a failed sync goes unnoticed for days.
  • Migrating dirty SKUs and hoping the integration will tidy them.

Where Dika Ops fits

We built Dika Ops so that orders, stock, purchasing and accounting live on one record and the shop is a channel into it rather than a separate island. It is in closed beta with a waitlist, so it is not the right fit for every company today. If you prefer to keep your current ERP, we also build integrations like the ones above through our custom software service; you can start from our homepage.

If you are still choosing the storefront, read Shopify vs WooCommerce, and for the stock side see our guide to inventory management software.

Frequently asked questions

What is Shopify ERP integration?

It is the automatic exchange of data between Shopify and your ERP. Orders move to the ERP, stock and tracking move back to the shop, and products, prices and customers are kept consistent.

Do I need an ERP if I only sell on Shopify?

Not at the start. Shopify handles a simple shop well. You need an ERP when stock is spread over locations, you buy and make goods on a schedule, or accounting and reporting take too much manual work.

How long does a Shopify ERP integration take?

A standard connector can be running in days, but a full rollout including data cleaning and testing usually takes weeks. Custom flows take longer, mostly because of rules and edge cases rather than the connection itself.

How do I stop overselling with an integration?

Make the ERP the owner of stock, sync availability frequently, and keep a small safety buffer on fast-selling lines. Also make sure reservations are created when an order is placed, not when it is picked.

Should prices be managed in Shopify or the ERP?

Pick one. If trade, retail and marketplace prices all come from the same list, manage prices in the ERP. If the shop runs its own promotions, keep those in Shopify and send only base prices from the ERP.

What happens when a sync fails?

A good integration queues the message, retries it and alerts a named person. Without that, orders can sit unprocessed unnoticed. Insist on logs and alerts when you choose a connector or build one.

Next step

Write down the data flows, pick an owner for each, and fix your product master before you connect anything. That preparation is what separates an integration that quietly works from one that needs fixing every week.

Have a project in mind? Let us talk it through.

Tell us what you want to improve. We will reply with a clear next step.