Integrating Business Central with Shopify
How Microsoft's Shopify connector for Business Central works — items, orders, inventory sync, fulfilment, and the operational realities.
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:
- 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.
- 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.
- 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.
- 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.
- 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.
Related guides
- Integrating Business Central with Microsoft 365How Business Central plugs into Outlook, Teams, Excel, SharePoint, OneDrive, and the rest of Microsoft 365.
- Integrating Business Central with SalesforcePatterns for connecting Business Central to Salesforce — accounts and contacts, opportunities to orders, and the choice between iPaaS and direct integration.
- Common Business Central ISV add-onsCategories of Business Central ISV add-ons that customers most often install — country localizations, document automation, EDI, banking, and vertical industry apps.
- EDI with Business CentralHow EDI integration works with Business Central — direct EDI vendors, AppSource connectors, document mapping, and the trade partner setup.
- Integrating Dynamics 365 with Azure servicesHow Dynamics 365 plugs into Azure — Service Bus, Logic Apps, Functions, API Management, Event Grid, and the iPaaS patterns that actually work.