How to Integrate Dynamics 365 with Shopify (2026)

Integrating Microsoft Dynamics 365 (specifically Business Central) with Shopify is achieved through the Microsoft Shopify Connector, a native app that facilitates the bi-directional flow of data between your ERP and your e-commerce storefront. This integration ensures that when a customer places an order on Shopify, it immediately appears as a Sales Order in Dynamics 365, while inventory changes in your warehouse are reflected on your website in real-time. This article is for ERP managers, IT directors, and operations leads who need to automate the manual entry of e-commerce data to reduce errors and improve fulfillment speed.

1. Prerequisites for Integration

Before you begin the technical handshake between the two systems, you must verify that your environment meets the specific version and licensing requirements. Using the wrong version of either platform can lead to API throttling or failed sync tasks.

Technical Requirements

• Microsoft Dynamics 365 Business Central: You must be using the Online version (SaaS). On-premises versions require a different gateway setup that is significantly more complex.
• Shopify Plan: Works with Shopify Basic, Shopify, Shopify Advanced, and Shopify Plus. Note that Shopify Plus provides higher API rate limits (up to 4x higher), which is critical for businesses processing over 500 orders per day.
• Permissions: You need “Super User” permissions in Business Central and “Store Owner” or “Full Access” in Shopify to authorize the app.

If you are still evaluating which ERP fits your business before starting this integration, you might want to compare Dynamics 365 Finance vs Business Central to ensure you are on the right platform for Shopify’s native tools.

2. Step-by-Step Connection Process

The connection is established by installing the Shopify Connector extension from the Microsoft AppSource and then creating a “Shop” record within Business Central.

Phase 1: Install the Extension

1. Log in to Business Central and use the global search (Alt+Q) to search for Extension Management.
2. Navigate to the Marketplace and search for “Shopify Connector” by Microsoft.
3. Click Install. Once installed, Business Central will refresh.

Phase 2: Create the Shopify Shop Card

The “Shop Card” is the command center for your integration. It defines how data moves for a specific store. If you have multiple Shopify stores (e.g., one for the US and one for the UK), you will create a separate Shop Card for each.

1. Search for Shopify Shops in Business Central and click New.
2. Enter your Shopify URL (e.g., your-store-name.myshopify.com).
3. Click Terms and Conditions and accept them.
4. Select Request Access. This will redirect you to Shopify to authorize the “Business Central” app.

Once authorized, the status on your Shop Card will change to “Enabled.” This is a critical milestone. At this stage, no data has moved yet; you have simply opened the pipe between the two systems.

3. Mapping Products and Inventory

The most common cause of integration failure is a mismatch between Item Numbers in Dynamics 365 and SKUs in Shopify. The system uses these as the unique identifier to link records.

Synchronization Logic

You must decide which system is the “Master” for product data. In most ERP-led businesses, Dynamics 365 is the master for pricing and base item data, while Shopify is the master for marketing content (descriptions and images).

Step-by-Step Item Sync

1. On the Shopify Shop Card, go to the Item/Product Sync section.
2. Define your Sync Item filter. You don’t want to sync every item in your ERP (like internal office supplies) to your web store. Use a specific “Web Store” Item Category or a Boolean field.
3. Select Can Update Shopify Product if you want BC to overwrite prices and weights on the website.
4. Run the Add Item process. This will create Shopify products from your BC Items.

Effective stock management is vital here. If you haven’t yet optimized your internal tracking, follow this guide on how to set up inventory management in D365 Business Central to ensure your quantities are accurate before they go live on the web.

4. Automating Sales Orders and Fulfillment

The primary goal of this integration is to ensure that orders flow into your warehouse without manual intervention. The Shopify Connector handles this through a background job queue.

Importing Orders

In the Shop Card settings, under the Order Processing tab, you can choose how orders are created. You have two main options:

• Sales Order: Best for businesses that need to perform warehouse picking and packing. This allows you to use the full WMS capabilities of Dynamics 365.
• Sales Invoice: Best for digital goods or dropshipping where no physical fulfillment step is required in the ERP.

Handling Customers

When an order comes in, the connector looks for an existing customer based on their email address. If no match is found, Business Central can automatically create a new Customer Card using a “Template Customer.” This ensures that the posting groups, VAT/Tax settings, and payment terms are applied correctly for every new web shopper.

Fulfillment Sync

When your warehouse team posts a “Shipment” in Dynamics 365, the connector triggers a message to Shopify. This includes the carrier name (e.g., FedEx, UPS) and the tracking number. Shopify then automatically sends the “Shipping Confirmation” email to the customer. This loop reduces customer service inquiries by 30-40% in most retail environments.

5. Financial Mapping and Payouts

One of the most complex parts of ERP integration is reconciling the money. Shopify Payouts often include multiple orders, subtracted transaction fees, and sometimes refunds. At our firm, we emphasize that the integration is only “complete” when the finance team can balance the books.

Mapping Payment Methods

You must map Shopify Payment Methods to Business Central Payment Method Codes. For example:

• Shopify Payments (Credit Card): Maps to a “SHOPIFY” payment method linked to a clearing bank account.
• PayPal: Maps to a “PAYPAL” payment method linked to your PayPal GL account.

By using a clearing account, you can post the Sales Invoice as “Paid” immediately. When the actual payout hits your real-world bank account, you perform a transfer from the clearing account to the bank account. This mirrors the real-world flow of funds. For more advanced financial automation, check out our guide on automating bank reconciliation in Business Central.

6. Common Pitfalls and Troubleshooting

Even with a native connector, issues can arise due to data inconsistencies or API limitations. According to internal benchmarks, approximately 15% of initial integration attempts face SKU mismatch errors.

Top 3 Integration Errors

1. SKU Mismatch: If Shopify has SKU “ABC” and Business Central has Item No. “abc”, the sync may fail depending on case sensitivity settings. Always use exact matches.
2. UOM Failures: Shopify only understands pieces/eaches. If your Business Central item is sold in “Boxes of 12,” you must ensure the Unit of Measure conversion is handled correctly during the sync.
3. API Rate Limits: If you attempt to sync 10,000 items at once on a standard Shopify plan, the sync will hang. Use filters to sync in batches of 500-1,000.

Shopify Integration Readiness Checklist

If you encounter deep technical hurdles, such as needing to connect to a custom 3rd-party logistics (3PL) app alongside Shopify, you may need to look into Dynamics 365 API integration for developers to build custom endpoints.

7. Frequently Asked Questions

Can I sync multiple Shopify stores to one Business Central company?

Yes. You can create multiple Shopify Shop Cards within a single Business Central company. Each card can have its own mapping rules, allowing you to manage a US store and a UK store separately while keeping inventory in one ERP.

How often does the data sync?

The sync frequency is determined by the Job Queue Entries in Business Central. You can set them to run as often as every 1 minute, though most businesses find that every 5 to 10 minutes for orders and 20 to 30 minutes for inventory is sufficient to prevent API throttling.

Does the connector handle gift cards?

The connector can import orders paid via gift cards. However, the gift card must be created in Shopify. Business Central treats the gift card as a payment method rather than a liability account unless specifically configured with custom GL mapping.

What happens if I change a price in Business Central?

If the Sync Price toggle is enabled on the Shop Card, the new price will be pushed to Shopify during the next synchronization cycle. Note that Shopify “Compare at Price” (MSRP) is not updated by default unless specifically mapped.

Is a partner required for this setup?

While the connector is “plug-and-play” for basic stores, most mid-market companies benefit from choosing a Dynamics consulting partner to handle complex tax mapping, multi-location inventory logic, and historical data migration. If you are migrating from an older system, you should also review the guide to migrating from GP to Dynamics 365.

Conclusion

Integrating Dynamics 365 with Shopify removes the friction of manual data entry and provides a single source of truth for your business operations. By following the steps outlined—installing the connector, configuring the Shop Card, and carefully mapping your items and financial settings—you can achieve a seamless flow of data that scales with your growth.

The next step for most businesses is to perform a “Data Audit” on their current SKU list to ensure readiness. If your business involves complex internal billing between entities, you might also consider automating intercompany transactions as part of your broader ERP optimization strategy. For a complete look at the implementation journey, refer to our breakdown of ERP implementation phases.