1. Home
  2. Business Central integration
  3. Business Central Shopify

Business Central and Shopify connect through Microsoft's own connector, online only

Microsoft's Shopify Connector comes built into Business Central online. It syncs products, stock, customers, orders, shipments and payouts, and stock flows one way, from Business Central to Shopify. It does not run on-premises or with Supply Chain Management.

Checked 19 November 2026

Microsoft’s connector is built in, online only

Start with Microsoft’s own Shopify Connector. It is preinstalled for new Business Central sign-ups and trials. Older environments install it from Marketplace. You need a Business Central license and a Shopify license. Microsoft supports it like the rest of Business Central.

Three facts from Microsoft’s FAQ set its reach:

  • Online only. It is not available for on-premises deployments.
  • Business Central only. It does not work with Dynamics 365 Supply Chain Management or Dynamics 365 Sales. A Finance and Supply Chain shop needs another route to Shopify.
  • Open source. The code sits in Microsoft’s BCApps repository, so a developer can read exactly what it does.

Users need the SHPFY ADMIN permission set to set it up.

What the connector carries, and which way

Direction matters most. It decides which system your team edits, record by record.

Scroll the table sideways to see every column.

Data Direction Microsoft’s rule
Products and items Both ways Pick one system of record first
Prices Business Central to Shopify Main and undiscounted prices
Inventory Business Central to Shopify Business Central is the system of record
Customers and B2B companies Both ways Matched by ID, then email, then phone; companies by tax or registration number
Orders, refunds and returns Shopify to Business Central From the online store, Shopify POS and B2B
Shipments and posted invoices Business Central to Shopify Buyers see invoices in Shopify
Transactions and payouts Shopify to Business Central Payouts are for information only

Payouts from Shopify Payments do not touch the General Ledger or the Bank Ledger. They help when you match your bank statement. They post nothing.

Connect a store with its myshopify.com address

Each store is a record on the Shopify Shop page. Give it a code and enter the address as https://{shop}.myshopify.com/. Turn on Enabled, accept the terms, then approve the app in Shopify.

The connector keeps its own access fresh. Its access tokens expire, and it renews them before they run out. If no renewal works for 90 days, reconnect with Request Access on the Shopify Shop Card. Microsoft’s known issues list includes “Can’t connect from sandbox”, and the page we saved gives no detail. So test the connection itself first.

More than one store is normal. Microsoft says nearly one third of firms on the connector link more than one Shopify store. Each shop has its own setup. One store can also connect to several environments or companies.

Orders become sales orders or sales invoices

Orders come in through a batch job, by hand or on a schedule. Auto Sync Orders listens for each new Shopify order and starts the job through the job queue. It sets no filters. People with the Delegated Admin permission cannot use it.

With Auto Create Sales Documents on, the connector makes the document for you:

  • Order still to ship. A sales order.
  • Order already fulfilled, such as a gift card sale. A sales invoice, if Create Invoices From Orders is on.

Four settings decide whether that works:

  1. Archived orders are skipped. Turn off Shopify’s automatic archive option, or orders vanish from the import.
  2. Locations must map. If Location Mandatory is on in Inventory Setup, a missing map stops the sales document.
  3. Taxes are worked out again. Business Central recalculates tax on each document, so its tax setup must be right.
  4. Currency is a choice. The shop currency is the default. Presentment currency uses the amounts the customer saw and paid at checkout.

Customers match by ID first, then email, then phone. If none match, the connector creates a new customer. For Shopify POS, a customer needs at least one address. Without it, the connector cannot create them in Business Central.

Edits after import do not flow through

This is where Shopify links go wrong. Once Business Central has made a sales document, Shopify edits do not reach it. Microsoft’s error message says the changes “weren’t propagated”. The connector flags the order, and someone fixes the documents by hand.

Edits on the Business Central side can break the link back too:

  • More quantity before shipping. Raise a quantity, post the shipment, and the fulfillment does not sync to Shopify.
  • Same product twice. Orders with multiple lines of the same product will not be fulfilled. Mark them fulfilled in Shopify Admin.
  • One line, two locations. A line split across two locations, such as 2 from EAST and 3 from WEST, arrives as one line with one location. Ship all 5 at once and the order stays unfulfilled.

Returns follow one of three settings. Skip them, import them only, or let Business Central make the credit memos.

Stock goes one way, from Business Central to Shopify

Business Central is the system of record for stock. You pick a method for each Shopify location. The two standard ones are Projected Available Balance at Today and Free Inventory (not reserved).

Microsoft’s own example shows why the method matters. Item A has 10 on hand, with an order for 1 due Monday and an order for 2 due Thursday. Under Projected Available Balance, a sync on Tuesday sends 9 to Shopify. A sync on Friday sends 7.

Two traps:

  • New Shopify locations start empty. Neither Shopify nor the connector adds stock records for existing products. Stock for the new location does not sync until you add them.
  • Bundles block updates. The Shopify Bundles app stops stock changes through the API. Microsoft suggests mapping bundles to Non-inventory items.

Products: decide the system of record first

Microsoft’s advice is to decide where product data lives before you sync anything. If item details and prices live in Business Central, choose To Shopify. The default setting imports products only with orders. It exports them only when someone runs Add Items.

One switch trips people up. Changing Sync Item from From Shopify to To Shopify does nothing until Can Update Shopify Products is on.

Shopify’s API versions set the upgrade deadline

The connector mostly uses Shopify’s GraphQL Admin API, for every call except sold gift cards. Shopify’s older REST Admin API has been a legacy API since October 1, 2024. On GraphQL, Shopify limits calls by a query cost set by plan, and one query may not cost more than 1000 points.

Versions are the real clock. Shopify releases an API version every three months and supports each for 12 months. Microsoft says the connector adopts the latest Shopify version in major releases of Business Central:

Scroll the table sideways to see every column.

Connector release Shopify API version Microsoft’s note
2026 release wave 1 2026-01 Accessible until December 31, 2026
2026 release wave 2 2026-07 The current connector

Business Central ships major releases in April and October, and a tenant can stay on the old version for up to five months. Microsoft warns that the two timelines do not line up. If you do not upgrade in time, API calls might be blocked and the sync stops. So a tenant still on the April 2026 release must move before December 31, 2026.

Run syncs on the job queue and watch the logs

Each sync can run on a schedule. We counted 12 recurring tasks on Microsoft’s background page on 19 November 2026, each with its own report. Report 30104 imports orders, Report 30103 creates the sales documents, Report 30102 sends stock and Report 30109 sends shipments. Turn on Run Syncs in Background and each supported sync action also runs as a job queue entry.

Logging needs one decision. New shops log Error Only by default, and Shopify log entries are kept for one month. A job queue run reports success even when it skipped records. So check the Shopify Skipped Records page after each new setup, not only the job status.

Test with a Shopify development store and a sandbox

Microsoft calls sandboxes on both sides probably the safest way to test. On Shopify, that can be a trial or a development store. In Business Central, it can even be a test company in a production environment.

Microsoft does not recommend a Shopify sandbox against Business Central production. Orders and invoices made that way can be hard to undo. If you must test like this, it says to check five settings and probably turn them off. They are Auto Create Unknown Items, Shopify Can Update Items, Auto Create Unknown Customers, Shopify Can Update Customers and Auto Create Sales Documents.

Microsoft gives two guards for a live Shopify store tested against a Business Central sandbox:

  • Read only into Business Central. Turn off Allow Data Sync to Shopify. Products, images, customers and orders still import, but nothing goes back to Shopify.
  • Hidden products. Set Status for Create Product to Draft, so exported products stay hidden from buyers while you check them.

Where the connector stops and custom work starts

Custom work starts where the connector stops. That means Business Central on-premises, Supply Chain Management, edits after import, or rules its settings cannot hold.

Shopify asks for written consent before you publish a store app whose main job is passing store data to Business Central. Microsoft’s FAQ adds that an unlisted app may still be possible. Microsoft’s connector is open source, and it publishes façade codeunits for custom work, such as Shpfy Orders, codeunit 30409, with MarkAsPaid and CancelOrder. Shopify POS can also change what you license. Some POS setups may need a Business Central Device license, for example with indirect access or multiplexing.

For the APIs behind a custom step, see Business Central integration. To compare, our NetSuite Shopify integration page covers Oracle’s connector.

Our team has taken Dynamics 365 Business Central and Dynamics 365 Finance live.

Our team has delivered on-demand ERP modules, each built for one business problem.

The first call is free.

Questions

Does Business Central have a Shopify connector?

Yes. Microsoft's Shopify Connector is preinstalled for new Business Central sign-ups and trials, and older environments install it from Marketplace. You need both a Business Central license and a Shopify license. Users need the SHPFY ADMIN permission set. You add each store on the Shopify Shop page. Enter its myshopify.com address, then approve the app in Shopify.

Does the Shopify Connector work with Business Central on-premises?

No. Microsoft's FAQ says the connector is only for Business Central online. It is not there for on-premises setups. It also does not work with other Dynamics 365 apps, such as Supply Chain Management or Sales. An on-premises Business Central needs a custom build or another vendor's app to reach Shopify.

Does inventory sync from Shopify to Business Central?

No, it goes the other way. Microsoft says Business Central is the system of record for stock. The connector sends stock levels to Shopify. You pick a stock method for each Shopify location. One is Projected Available Balance at Today. The other is Free Inventory (not reserved). A new Shopify location needs stock records added before it will sync.

Can Shopify orders become sales invoices instead of sales orders?

Yes, for orders already fulfilled. With Auto Create Sales Documents on, an order that still needs fulfillment becomes a sales order. A fulfilled order, such as a gift card sale, can become a sales invoice if Create Invoices From Orders is on. Taxes are worked out again in Business Central, so check your tax setup first.

What happens if we edit a Shopify order after it is imported?

If Business Central has already made a sales document from it, the edit does not carry across. The connector flags the order and asks you to update the documents by hand. Some edits in Business Central also break the link back. For example, raising a quantity before you post the shipment stops that fulfillment syncing to Shopify.

Can we connect more than one Shopify store to Business Central?

Yes. Microsoft says the connector supports multiple stores, and nearly one third of organizations using it connect more than one. Each shop has its own setup, including its products and the locations used for stock and price lists. The same store can also connect from several environments or companies, which helps when you test.

Sources

Every source behind a figure or a vendor fact on this page, with the day we read it.

Check your Shopify setup against the connector's rules

Bring your Shopify stores, sales channels and the Business Central version you run. On the first call we talk through which records the connector can carry for you and where it stops. The first call is free.

Book a Shopify sync call