Shopify and Business Central: The Native Connector Explained

Microsoft includes a native Shopify connector within Business Central at no additional cost. For ecommerce businesses already running BC, or considering it, the connector removes the need for manual data entry between your online store and your ERP system. But it is not a universal solution. Understanding what it does well and where it falls short will help you make the right integration decision.

What the Native Connector Does

The Shopify connector provides bi-directional synchronisation between your Shopify store and Business Central. At its core, it handles four key data flows:

• Products. Items created and maintained in Business Central can be published to Shopify. Product descriptions, prices, images and inventory quantities are synchronised from BC to your storefront.
• Orders. When a customer places an order on Shopify, the connector creates a corresponding sales order in Business Central. Order lines, customer details, shipping information and payment status flow through automatically.
• Customers. Customer records can be synchronised between platforms. New Shopify customers can be created automatically in BC, or mapped to existing customer records based on email address or other identifiers.
• Inventory. Stock levels maintained in Business Central are published to Shopify, reducing the risk of overselling. When a sale is processed in BC, the updated inventory level is reflected on the storefront.

The connector is configured entirely within Business Central. You connect to your Shopify store using API credentials, map your BC items to Shopify products and define how orders and customers should be processed. Once configured, synchronisation runs on a schedule or can be triggered manually.

How the Sync Works

Product synchronisation is typically one-directional: from Business Central to Shopify. You maintain your master product data in BC, including descriptions, pricing and categorisation, and publish it to your storefront. This ensures your ERP remains the single source of truth for product information.

Order synchronisation flows in the opposite direction: from Shopify to Business Central. When an order is placed, the connector retrieves it from Shopify and creates a sales order in BC. Depending on your configuration, this can happen every few minutes or on a longer schedule. The sales order includes all line items, the customer record, shipping details and payment information.

Inventory updates flow from BC to Shopify in near real-time. When stock is received, sold or adjusted in Business Central, the updated quantity is pushed to Shopify. For most single-location businesses, this provides accurate stock visibility on the storefront without manual intervention.

Customer synchronisation can be configured in either direction. You can choose to create new BC customer records from Shopify orders, use a default customer account for all online sales, or map Shopify customers to existing BC records. The right approach depends on whether you need individual customer tracking for online sales.

What It Does Not Do

The native connector has genuine limitations that you should understand before committing to it as your integration strategy:

• Multi-location inventory. If you operate multiple warehouses or stock locations, the connector's inventory sync is limited. It can publish stock from a single BC location to Shopify. Complex multi-location fulfilment logic, where Shopify needs to know which warehouse will fulfil each order, requires additional configuration or middleware.
• Complex variant handling. Shopify and Business Central handle product variants differently. Shopify allows up to three variant options per product. If your BC item structure uses a more complex variant or attribute model, mapping can be problematic.
• Multi-channel selling. The connector handles Shopify only. If you sell through Amazon, eBay, your own website and Shopify, the native connector covers one channel. You will need separate integrations or a multi-channel middleware solution for the others.
• Returns processing. The connector does not automatically process returns or refunds from Shopify back into Business Central. Refunds issued in Shopify need to be handled manually in BC, or you need additional automation to create credit memos from Shopify refund events.
• Complex pricing. If you use customer-specific pricing, volume discounts or promotional pricing that differs between your Shopify store and your BC price lists, the connector's pricing sync may not cover your requirements without additional customisation.

When You Need Middleware

Middleware platforms sit between your ecommerce channels and Business Central, providing a layer of orchestration that the native connector does not offer. You should consider middleware when:

• High order volumes. If you process hundreds or thousands of orders per day, the native connector's scheduled sync may not keep pace. Middleware solutions offer real-time, event-driven processing that scales with volume.
• Multi-channel operations. Selling across Shopify, Amazon, eBay and a standalone website requires a centralised integration layer. Middleware consolidates orders from all channels into BC through a single integration point.
• Complex pricing rules. Promotional pricing, flash sales, channel-specific margins and customer group discounts are better handled by middleware that can apply business logic before data enters BC.
• Advanced fulfilment. If you use third-party logistics providers, drop-shipping or multi-warehouse fulfilment strategies, middleware can route orders to the correct fulfilment point based on rules that the native connector cannot express.

Middleware adds cost and complexity. It requires configuration, maintenance and monitoring. For businesses that genuinely need it, the investment pays for itself in operational efficiency. For businesses that do not, it is unnecessary overhead.

Our Recommendation

For most single-store Shopify businesses with straightforward product catalogues and moderate order volumes, the native connector is the right starting point. It is built into Business Central, maintained by Microsoft, requires no additional licensing and covers the core integration requirements.

If you are selling across multiple channels, processing high volumes or have complex fulfilment requirements, plan for middleware from the outset. Retrofitting middleware after you have outgrown the native connector is achievable but more disruptive than building the right architecture from day one.

We have implemented both approaches across our ecommerce client base. The right choice depends on your specific operational requirements, and we are happy to advise based on your situation.