Shopify Integration with Business Central: How It Works, Setup and Limits

Shopify integration with Business Central means your online store and your ERP system share the same records. Product details, stock figures, customer information, orders and financial entries move between the two systems automatically, so your team enters each piece of data once.

What Business Central does in an online retail setup

Dynamics 365 Business Central is Microsoft’s ERP system for small and mid-sized businesses. It holds your finance, inventory, purchasing, warehousing and reporting. In a retail setup it is the back office behind the storefront, and it owns the numbers your accountants and warehouse teams rely on.

What the Shopify Connector is

The Shopify Connector is an application built by Microsoft that links a Shopify store to a Business Central environment. It is available through Microsoft AppSource and through the Shopify app store, and it came out of the partnership between Microsoft and Shopify under Shopify’s Global ERP Program.

What the integration replaces

It replaces manual order entry, spreadsheet stock updates, and duplicate product and customer records kept in two systems. Those habits work at low order volume. They start to cost money when stock figures drift and customers buy items you cannot ship.

Which system handles which part of the process

The connector moves records between Shopify and Business Central on a schedule you control, and you decide the direction of travel for each record type. Some records flow from Business Central out to Shopify. Some flow from Shopify back into Business Central. A few flow both ways.

Scheduled background synchronization

Business Central can synchronize data automatically at scheduled intervals through the job queue. The automation covers products, inventory, customers, orders, shipments and prices. Scheduled jobs minimize manual effort and keep information up to date without anyone starting the process by hand.

The integration covers the full order lifecycle, from publishing a product to posting the revenue behind it.

Product and price synchronization

Keep one source of truth for your product catalog and your pricing.

• Create products in Business Central and publish them to Shopify
• Synchronize product names and descriptions
• Update SKUs and item numbers
• Manage variants such as size, color and style
• Synchronize standard sales prices, price list updates and promotional pricing

Pricing stays maintained centrally in Business Central, which removes duplicate maintenance and keeps prices consistent across your sales channels.

Inventory synchronization across locations

Inventory synchronization prevents stock discrepancies between your ERP and your online store.

• Automatic inventory updates after online purchases
• Stock adjustments following purchase receipts
• Inventory updates after production or warehouse transactions
• Stock visibility that helps prevent overselling
• Inventory synchronization across multiple warehouses

Customers see accurate product availability while your warehouse keeps reliable inventory records.

Customer synchronization

Customer information stays consistent across both platforms.

• Automatic customer creation
• Customer matching to existing records
• Contact information updates
• Duplicate customer prevention

Your sales and finance teams work from accurate customer data instead of reconciling two lists.

Sales order processing and order status

Every Shopify order can automatically create a matching sales document in Business Central. The integration transfers:

• Customer details
• Billing and shipping addresses
• Ordered products and quantities
• Taxes, discounts and shipping charges
• Payment information

Order progress then synchronizes through the fulfillment lifecycle. Typical statuses include open, released, shipped, fulfilled, cancelled and refunded, so your customer service team and your customers both see where an order stands.

Fulfillment, shipping and tracking updates

Once an order ships from Business Central, shipment information is sent back to Shopify automatically.

• Shipment confirmation and fulfillment status
• Tracking numbers
• Shipping carrier information
• Shipping methods and shipping costs
• Delivery tracking and shipment status

Customers receive timely shipping updates without anyone typing them out, and you gain clearer visibility into fulfillment.

Payments and financial posting

Payment details captured during online checkout can also be synchronized, including payment status, payment method, transaction reference, and payment gateway details depending on the implementation. This simplifies payment reconciliation.

Business Central then records the financial transactions generated by Shopify sales:

• Sales invoice creation
• General ledger postings
• Customer ledger entries
• Inventory valuation updates
• Revenue recognition and tax calculations

Financial accuracy improves and your accounting effort drops.

Returns and refunds

Managing returns becomes easier through integrated processes. You can:

• Create return orders
• Generate credit memos
• Process customer refunds
• Update inventory automatically
• Maintain complete audit trails

Returns are reflected accurately in both systems, so your stock position and your ledger agree.

Support for multiple Shopify stores

If you manage more than one online store, you can integrate all of them with a single Business Central environment.

• Store-specific product catalogs
• Separate pricing strategies
• Inventory allocation by store
• Consolidated financial reporting

This simplifies operations for multi-brand and multi-region businesses.

The gains come from removing repeated work and closing the gap between what your store shows and what your ERP holds.

Less manual data entry

Orders, customers and shipment details arrive in Business Central without anyone retyping them, so your team works on exceptions instead of transcription.

Fewer stock and pricing errors

Stock figures and prices come from one place, which reduces oversold items and cancelled orders.

Faster order turnaround

Orders reach the warehouse as soon as the sync runs, and shipment details travel back to the customer automatically.

One version of financial and customer data

Sales, finance and service teams read the same records, so reporting no longer depends on which spreadsheet was updated last.

Room to grow without adding admin headcount

Adding a store, a region or a sales channel adds configuration work rather than a new set of manual routines.

Check these points before you plan the work. The second one rules the native connector out entirely.

• A Shopify account and a live Shopify online store
• Business Central online. Microsoft states the Shopify Connector is not available for on-premises deployments.
• Both a Business Central license and a Shopify license
• The Shopify Connector app installed. It is preinstalled for new Business Central environments and can be installed from AppSource for existing ones.
• A Business Central user with the permission set the connector requires
• Locations, payment methods, shipping methods and tax setup prepared in Business Central before the first sync

The connection is made from both sides. You add the Business Central app in Shopify, then create the matching shop record in Business Central. Follow the steps in order.

1. 1

   Set up your Shopify store

   Create your Shopify account, then create the online store that will hold your products, customers and discount details. Once the shop is created, you receive the URL used to access it. You can run more than one shop, for example one per location, and additional stores are added from the store list under your account.

Figure 1. Creating a store from the Get started page of the Shopify Partners dashboard.

Figure 2. The new store listed under Stores, programs and resources, with the store URL used to access the shop.

Figure 3. Opening Stores from the account menu in Shopify admin to add or switch between multiple shops.

2. 2

   Add the Business Central app in Shopify

   In your shop you can add products, customers and orders. To connect the shop to Business Central, open Apps from the left of the Shopify home page, search for Business Central, then add the app.

Figure 4. Searching for Business Central in the Shopify app search, with the Dynamics 365 Business Central app shown in the sidebar.

3. 3

   Sign in to Business Central

   Sign in when you are prompted. You are then redirected into the Business Central application. If your organization has more than one environment, select the one you want to connect.

Figure 5. The Business Central app page in Shopify, with Sign in for organizations already using Business Central.

Figure 6. Selecting the Business Central environment to access when more than one is available.

4. 4

   Create the Shopify shop record in Business Central

   In Business Central, search for Shopify Shop and choose New to add your store details. Enter the shop URL, then choose Enable to integrate Shopify and Business Central.

Figure 7. The Shopify Shops list in Business Central, with the New action used to add a shop.

Figure 8. The General section of the Shopify Shop Card, showing the Shopify URL, the Enabled toggle and the background sync setting.

5. 5

   Configure customer and item synchronization

   Provide the customer and item synchronization details for the shop. These settings decide which records are created automatically, and they set the direction of travel for each record type. In Figure 9 the Sync Item field is set to From Shopify, which pulls items into Business Central. Choose To Shopify instead if Business Central holds your master catalog.

Figure 9. Item Synchronization settings on the Shopify Shop Card, including sync direction, item template and SKU mapping.

Figure 10. Inventory Synchronization and Customer Synchronization settings, including customer mapping and template options.

Figure 11. Customer Synchronization and Order Processing settings, including shipping charges account and automatic order creation.

6. 6

   Run the first synchronization

   Once all details are provided, choose Related on the action bar and select Sync All. The job queue is scheduled and it begins pulling records from Shopify.

Figure 12. The Related menu on the Shopify Shop Card, with the Sync All action that schedules the job queue.

The native connector is the right answer for most businesses, but it is not the only route. There are three approaches, and the choice depends on how far your requirements sit from the standard model.

Start with the native connector and test it against your real catalog. Move to another approach only when you can name the specific requirement it fails to meet.

The connector is built to cover common scenarios well rather than every scenario. Knowing the boundaries early saves you from discovering them during a go-live weekend.

On-premises deployments

The connector works with Business Central online only. If you run Business Central on-premises, you need a custom integration or a third-party platform.

Pricing model constraints

The standard pricing flow suits businesses that publish one price per item to a store. Complex multi-region or multi-currency storefronts may need pricing handled outside the standard flow.

Custom product data and metafields

Metafield support covers basic field types. If your storefront depends on rich text, nested fields or transformed product data, check that support carefully before you commit.

Point of sale and channel separation

Orders from several Shopify sales channels can be imported. If you need strict separation of point of sale stock and online stock, confirm the detail against your own process first.

Narrow extensibility by design

Microsoft keeps the number of extensibility points deliberately small so the connector can follow Shopify’s fast release cycle without breaking existing customers. That stability is the trade-off for flexibility.

Shopify API version alignment

Each connector release targets a specific Shopify Admin API version rather than the newest one available. New Shopify features may not be usable in Business Central straight away.

Most integration problems come from data and configuration rather than from the connector itself. These habits prevent most of them.

Test before you go live

Use a Shopify trial or development store with a Business Central sandbox, or a test company inside your production environment. Avoid pointing a live store at a production company, because the connector can create items, customers and sales documents that are difficult to undo. Tests are easy to rerun, since you can delete imported records and reset the sync.

Clean your data first

Resolve duplicate items and customers, standardize your SKUs, and confirm unit prices before the first sync. Bad data multiplies once it is moving automatically between two systems.

Set the sync frequency deliberately

Match your job queue intervals to your order volume. For most catalogs, accurate stock and price figures matter more than the shortest possible interval.

Monitor the log

The connector records synchronization attempts in its log entries. When a record does not appear where you expect it, check the entries flagged with an error around the time the sync ran, then read the response detail.

Problems worth knowing about

Three issues account for a large share of support tickets. Inventory does not update because a default product location has not been set for the shop. Prices do not appear as expected because the customer price group has not been configured, so the item unit price is used instead. Orders fail to import because a customer template is missing and unknown customers cannot be created.

The integration pays off fastest in businesses where the same record is currently entered twice. Four profiles see the clearest gain.

Online retailers already running Business Central

If your team still keys Shopify orders into Business Central by hand, this removes the step entirely and takes the transcription errors with it.

Distributors and wholesalers selling direct as well as to trade

One stock pool serves both channels, so trade orders and consumer orders draw on figures that agree.

Multi-brand and multi-region businesses

Several Shopify stores can run their own catalogs and pricing while reporting rolls up into one Business Central environment.

Businesses selling B2B through Shopify

Company records, catalog pricing and payment options can be handled through the connector’s B2B support, which relies on a Shopify Plus subscription.

This may not be the right fit if

You run Business Central on-premises, or your commerce processes depend on heavily customized product data and pricing logic. In both cases, plan for one of the other two approaches.