Business Central and Shopify Connector

Today I want to talk to you about the integration of Business Central with Shopify, I tested the tool and I must say that in a few minutes you are online with both platforms and with a good integration. Sure there are many ecommerce platforms (B2C) available with related integrations but this one is very simple and ready to use.

Shopify Connector Features – Summary (BC2022Wave1 20.1)

What can we do?

Multiple Shopify shops connected to the same Business Central

  • Each shop has its own setup, including a collection of products, locations used to calculate inventory, and prices lists.

Bi-directional synchronization of items/products

  • Sync images, item variants, barcodes, vendor item numbers, extended texts, and tags.
  • Export item attributes to Shopify.
  • Use selected customer price groups and discounts to define prices exported to Shopify.
  • Decide whether items can be created automatically or to only allow updates to existing products.

Synchronization of inventory levels

  • Choose some or all of the available locations in Business Central.
  • Update inventory levels on multiple locations in Shopify.

Bi-directional synchronization of customers

  • Smart-map customers by phone and email.
  • Use country-specific templates when creating customers, which helps ensure that tax settings are correct.

Import of Orders from Shopify

  • Create customers on-the-fly, or use fixed retail customer to keep customer data in Shopify.
  • Include orders created in other channels, such as Shopify POS or Amazon.
  • Shipping costs, gift cards, tips, shipping and payment methods, transactions, and risk of fraud.
  • Receive payout information from Shopify Payments.

Send fulfillment information to Shopify

  • Include item tracking information.


Shopify connector – Dynamics 365 Release Plan | Microsoft Docs

TECHNOLOGY (BC2022Wave1 – 20.1)

Connector” is an APP..


Business Central integrated Shopify Menù

Options \ features available:

  • Shops
  • Customer
  • Products
  • Orders
  • Gift Cards
  • Transactions
  • Payout
  • .. and more others pages\statistics etc.

Immagine che contiene testo, screenshot, arancia

Descrizione generata automaticamente

My Demo Shopify Site, a site \ page for selling books (in this case I don’t sell anything but I only publish 2 references to existing books as items to sell).



To really sell, you need to activate a plan, there are different options and prices. If it is not activated, everything works correctly (including the data exchange interface) except the Checkout which obviously is not allowed.

Once the site is created, put something up for sale, we can test the integration between BC and Shopify.

From BC we can open Shopify -Shop

From this page we can configure everything, from the shops to the integration / data transfer methods.


By clicking on “ENABLE” you proceed to authorize the integration (API) between the systems (a bit like the connection to the Dataverse).

You can always check that everything works from the queues

After activation, you can proceed with synchronization (all or step by step with selection)

interesting is the section that allows you to rely on customer templates (as do other B2Cs)

“Get” Location

Yes, you can GET your Location!

About Syncronization

Different possibilities, view of the SKUs (also here similar to other B2C), prices, discounts, promotions etc.

EVERYTHING WORKS! in this case I kept Shopify as Master and import everything in BC (items, Customers, Orders).

Here are my books from Shopify!

there is a dedicated section for these Shopify articles and related statistics but they are also visible in the standard forms

Power Automate!

You can integrate PowerAutomate to create your flows (in practice the connector is already based on Power Automate).

Manual launch \ Sync forcing

Sales Statistics (0 Sales in DEMO Mode)

Download Data

You can not only consult but also download the data.

Thats’ All.

5 thoughts on “Business Central and Shopify Connector

  • 16 June 2022 at 3:28 PM

    I’m using version 20.1 for BC, but I don’t have the Power Automate option available. Did you do something different?

  • 17 August 2022 at 3:34 AM

    A client of mine is struggling with the following error below when running Report ID 30100 – Shopify Sync Customers to sync existing BC customers from BC to Shopify. Any thoughts on what this error means that we see in the Job Queue Entries when 30100 errors out. It seems to be appearing for Products/Items as well. We have not implemented Shopify Connector before and we are just supporting our client who are self-installing.

    Unable to convert from Microsoft.Dynamics.Nav.Runtime.NavJsonToken to Microsoft.Dynamics.Nav.Runtime.NavJsonObject


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.