Integrating Business Central with Shopify

Microsoft ships a first-party Shopify connector as part of Business Central. For B2C and small-B2B sellers running Shopify as their storefront and Business Central as their back office, it's typically the integration of first choice.

What the connector does

The connector synchronises five things between Business Central and one or more Shopify shops:

1. Items / products. Items in BC publish to Shopify as products with title, description, images, tags, variants, prices, and inventory. The push is one-way (BC → Shopify) for catalogue control.
2. Inventory. On-hand quantities at nominated BC locations sync to Shopify so the storefront shows accurate stock. Multi-location stock can publish to Shopify's multi-location.
3. Orders. Shopify orders import into BC as sales orders, with the Shopify customer mapped to a BC customer (auto-created or matched). Order line items reference the originating BC items.
4. Fulfilments. When a BC sales shipment posts, the connector pushes a fulfilment back to Shopify, including tracking number, marking the order as shipped for the customer.
5. Payments. Shopify's payment summary imports into BC as a customer payment, applied against the imported sales invoice when the order is also fulfilled and invoiced.

Customer mapping

A Shopify customer maps to a BC customer either by email match or by auto-creation in a template-defined customer template. Repeat customers reuse their BC record.

Tax handling

Shopify computes tax client-side; the connector imports the order with tax pre-calculated. For VAT-registered EU businesses on OSS or import-VAT regimes, configure carefully — mismatches between Shopify's tax engine and BC's VAT engine surface here.

Inventory timing

Inventory sync is near-real-time but not transactional. A Shopify oversell — two customers buy the last unit in the same minute — can happen during reconciliation gaps. Configure Shopify's safety-stock buffer to absorb the window.

Multi-shop

The connector supports multiple Shopify shops mapped to the same or different BC companies. Useful for multi-region operations.

Limits

The first-party connector handles standard order-to-cash. For sophisticated needs — subscriptions, complex bundles, B2B pricing tiers, Shopify Plus features like wholesale channels — ISV connectors from AppSource often add the missing scope.

Set-up

Connecting a shop is wizard-driven: install the Shopify Sales Channel app from BC's AppSource entry, supply the Shopify store URL and access token, map BC items to publish, configure customer template and posting groups, and run an initial sync.

Operational reality

Daily reconciliation checks (orders not imported, payments not matched, fulfilments not pushed) are essential in the first weeks. Once stable, the integration runs unattended.