← Back to TutorialsE-COMMERCE INTEGRATION

Shopify and Business Central Integration: Complete Guide

Dynexal • Beginner to Intermediate • 15 min read

Shopify and Microsoft Dynamics 365 Business Central can work together to connect online commerce with ERP processes. This guide explains the Microsoft Shopify Connector, the data flow between both systems, synchronization of products and inventory, customers, prices, orders and fulfillment, plus practical troubleshooting and integration best practices.

What you will learn: Shopify Connector basics, connection setup, products, inventory, prices, customers, orders, fulfillment, synchronization, testing, troubleshooting and how to approach custom extensions.

Why integrate Shopify with Business Central?

Shopify is designed for online commerce while Business Central manages broader business processes such as sales, inventory, finance and operations. An integration reduces duplicate data entry and helps keep commerce and ERP processes connected.

Microsoft's Shopify Connector is designed to synchronize information such as items, inventory, prices, customers, sales orders and fulfillment information between the two systems. It can also use background synchronization through Business Central's job queue. Microsoft Shopify Connector overview.

How the integration works

At a high level, the integration looks like this:

Shopify Store
     │
     │ Products / Customers / Orders
     ▼
Shopify Connector
     │
     │ Mapping + Synchronization
     ▼
Business Central
     │
     │ Inventory / Prices / Fulfillment / Financial processing
     ▼
Shopify Store

The connector handles the communication and synchronization workflows. Your configuration determines what should flow from Shopify to Business Central, what should flow in the opposite direction, and how records are mapped.

Prerequisites

A Shopify account and online store.
A Business Central environment with appropriate permissions.
The Shopify Connector app installed in Business Central.
A clear decision about which system should be the source of truth for each type of data.
A safe test or sandbox environment for initial validation.

Microsoft's current setup guidance recommends having the Shopify Connector installed and the required permissions assigned before connecting a store. Get started with the Shopify Connector.

Connect Shopify to Business Central

In Business Central, search for Shopify Shops and create a new Shopify Shop record. Enter a recognizable shop code and the Shopify online store URL, enable the connection and complete the authorization flow.

Open Business Central.
Search for Shopify Shops.
Choose New.
Enter a shop code.
Enter the Shopify Admin URL in the format expected by the connector.
Enable the shop and complete the Shopify authorization.
Review synchronization settings before running the first sync.

Important: do not treat the first synchronization as a harmless read-only operation. Depending on configuration, the connector can create or update items, customers and sales documents. Test with controlled data before enabling production synchronization.

Synchronizing products and items

Product synchronization connects Shopify products and variants with Business Central items. Depending on your process, you can manage product information primarily in Business Central and export it to Shopify, or import Shopify data into Business Central.

Typical product data can include item numbers, descriptions, variants, images, categories, prices and inventory-related information. Mapping rules should be designed before the first production synchronization.

Best practice: decide which application owns each field. For example, Business Central may be the system of record for item numbers and inventory while Shopify remains the storefront for web-specific presentation.

Synchronizing inventory

Inventory is one of the most important parts of an e-commerce integration. A customer should not be able to purchase stock that Business Central considers unavailable.

The connector supports inventory synchronization for Shopify locations. Your setup should define which Business Central locations contribute to the Shopify stock calculation and how multiple locations should be handled.

Microsoft documents inventory synchronization as a separate configuration area within the Shopify Connector. Synchronize items and inventory.

Synchronizing prices and taxes

Prices need careful planning because Business Central may calculate selling prices using its pricing logic while Shopify displays the resulting storefront price. Discounts, markets, taxes and customer-specific pricing can affect the final amount.

Define the source of product pricing.
Understand how discounts should be represented.
Configure tax behavior consistently.
Test prices for different markets or customer scenarios.
Verify rounding and currency behavior.

Synchronizing customers

Customer synchronization can create or update Business Central customers from Shopify, depending on configuration. Before enabling automatic creation, define how unknown customers should be handled and how duplicate customers will be avoided.

For B2B scenarios, company and contact relationships require additional mapping and configuration. Always test customer creation with realistic but controlled data.

Importing Shopify orders into Business Central

A common flow is for a customer to place an order in Shopify, after which the order is synchronized into Business Central for sales processing.

Customer places order in Shopify
            ↓
      Shopify Order
            ↓
   Sync Orders From Shopify
            ↓
   Shopify Order in BC
            ↓
      Sales Document
            ↓
   Warehouse / Posting
            ↓
      Fulfillment
            ↓
   Shipment information → Shopify

Depending on configuration, the imported order can be associated with an existing customer or can create a customer when the matching rules allow it. Business Central can then handle the downstream sales and fulfillment processes.

Fulfillment and shipment updates

After an order is processed and shipped in Business Central, fulfillment information can be synchronized back to Shopify. Tracking information can also be transferred when configured.

This creates a useful two-way flow: Shopify captures the customer order while Business Central handles operational processing, and Shopify receives the fulfillment status needed by the customer-facing storefront.

Background synchronization with job queues

Manual synchronization can be useful during initial setup and testing, but production integrations often benefit from background processing. Business Central can automate Shopify synchronization through the job queue.

Background processing should be designed around business requirements rather than simply running everything as frequently as possible. Consider data volume, API limits, error handling, monitoring and the acceptable delay between systems.

Testing strategy

Use a controlled test cycle before connecting production data:

Connect a test Shopify store or safe test environment.
Create a small number of test items.
Synchronize products and verify mappings.
Test inventory changes in both directions where applicable.
Test customer creation and matching.
Create a test order and import it into Business Central.
Process shipment and verify fulfillment synchronization.
Review synchronization logs and correct errors.
Repeat the test after configuration changes.

Microsoft specifically recommends careful testing because connector settings can create or modify business records. Microsoft testing guidance.

Common Shopify integration problems

1. Products are not synchronizing

Check shop configuration, item filters, mapping, synchronization direction and whether the item meets the conditions required for export or import.

2. Inventory is incorrect

Review location mapping, stock calculation settings and the inventory available at the selected Business Central locations.

3. Duplicate customers appear

Review customer matching rules and avoid enabling automatic creation without understanding how Shopify customer information maps to Business Central.

4. Orders fail to import

Check customer and item mapping, missing data, configuration templates, synchronization logs and the status of the Shopify order.

5. Authorization or connection errors

Check the Shopify connection, permissions, authorization flow, browser pop-up blocking and the store URL. Re-authorize the connection when appropriate.

When should you build custom AL code?

The standard Shopify Connector should be the starting point for normal supported scenarios. Custom AL development becomes useful when your business process requires additional validation, custom mappings, extra fields, automated workflows or integration-specific logic.

For example, you may create an extension that adds custom fields to Shopify-related records, subscribes to connector events or applies additional business rules. Keep custom logic isolated and event-driven where possible so upgrades are easier to manage.

Recommended architecture for custom extensions

Shopify
   │
   ▼
Standard Shopify Connector
   │
   ├── Standard synchronization
   │
   └── Events / extension points
             │
             ▼
       Custom AL Extension
             │
       ┌─────┴─────┐
       ▼           ▼
 Validation    Custom mapping
       │           │
       └─────┬─────┘
             ▼
      Business Central

Developer tip: avoid replacing standard connector behavior when an event subscriber or supported extension point can achieve the same result. Smaller extensions are usually easier to test, maintain and upgrade.

Shopify Connector vs custom API integration

Use the standard Shopify Connector when your requirements match the supported synchronization scenarios. A custom API integration may make sense when you need a different architecture, another commerce platform, specialized middleware or full control over the data contract.

Scenario	Recommended starting point
Standard Shopify + Business Central processes	Shopify Connector
Custom fields or validation	Connector + AL extension
Different commerce platform	Business Central APIs / custom integration
Complex multi-system architecture	API + middleware + event-driven design

Security and production best practices

Use least-privilege permissions.
Test synchronization before production rollout.
Back up or protect important production data before major configuration changes.
Monitor synchronization errors and logs.
Define ownership for products, prices, customers and inventory.
Document mappings and synchronization direction.
Keep custom AL logic modular and upgrade-friendly.
Do not expose secrets or access tokens in source code.

What should you learn next?

Business Central API Integration — understand REST APIs and custom integration patterns.

Codeunits in Business Central — build reusable AL business logic for integration processes.

Page Extensions in Business Central — extend standard pages with custom fields and actions.

RDLC Reports in Business Central — build reporting solutions for ERP data.

AL Tables in Business Central — understand the data structures behind Business Central solutions.

Technical reference: Microsoft Learn documentation for the Business Central Shopify Connector, synchronization scenarios and setup guidance.

← Explore all Dynexal tutorials