Troubleshooting the Shopify and Business Central Synchronization

Article
02/28/2023
3 minutes to read

It's possible to run into situations where you need to troubleshoot issues when synchronizing data between Shopify and Business Central. This page defines troubleshooting steps for some common scenarios that may occur.

Logs

If a synchronization task fails, you can activate logging by enabling the Log Enable toggle on the Shopify Shop Card page. Then you can manually trigger the synchronization task and review logs.

Choose the icon, enter Shopify Log Entries, and choose the related link.
Select the related log entry and open the Shopify Log Entry page.
Review the request, status code and description, and response values.

Later, remember to switch logging off to avoid negative performance impacts and increases in database size.

From the Shopify Log Entries page, you can trigger the deletion of all log entries or ones older than seven days.

Data capture

Regardless of the Log Activated settings, some Shopify responses always get logged so you can inspect or download them using the Data Capture List page.

Choose the Retrieved Shopify Data action on one of the following pages:

Shopify order
Shopify order fulfillments
Shopify order shipping costs
Shopify order transactions
Shopify payouts
Shopify payment transactions
Shopify transactions

Reset sync

For optimal performance, the connector imports only customers, products, and orders created or changed since the last synchronization. On the Shopify Shop Card page, there are functions that change the date/time of the last synchronization or completely reset it. This function ensures that when the sync is run, all data is synced rather than just the changes since the last sync.

This function only applies to syncs from Shopify to Business Central. It can be useful if you need to restore deleted data such as products, customers, or deleted orders.

Request the access token

If Business Central won't connect to your Shopify account, try to request the access token from Shopify. This request might be needed if there is a rotation of security keys or changes in required permissions (scopes).

Choose the icon, enter Shopify shops, and choose the related link.
Select the shop for which you want to get the access token to open the Shopify Shop Card page.
Choose the Request Access action.
If prompted, sign in to your Shopify account.

The Has AccessKey toggle will be activated.

Verify and enable permissions to make http requests when running in a non-production environment

To work correctly, the Shopify Connector extension requires permission to make http requests. When testing in a sandbox, the http requests are prohibited for all extensions.

Choose the icon, enter extension management, and choose the related link.
Select the Shopify Connector extension.
Choose the Configure action to open the Extension Setting page.
Make sure that the Allow HTTPClient Requests toggle is enabled.

Rotate the Shopify access token

The following procedures describe how to rotate the access token used by the Shopify connector to access your Shopify online shop.

In Shopify

From your Shopify Admin, go to Apps.
Select Delete in the row with the Dynamics 365 Business Central app.
Select Delete in the message that appears.

In Business Central

Choose the icon, enter Shopify shops, and choose the related link.
Select the shop for which you want to rotate the access token to open the Shopify Shop Card page.
Choose the Request Access action.
If prompted, sign in to your Shopify account, review privacy and permissions, and then choose the Install App button.

Known issues

The Gen. Bus. Posting Group cannot be zero or empty; there must be a value in the customer field

On the Shopify Shop Card page, fill in the Customer Template Code field with the template that has Gen. Bus. Posting Group populated. The customer template is used not only for the creation of customers but also for the calculation of the sales price and during the creation of sales documents.

Importing data to your Shopify shop isn't enabled. Go to the shop card to enable it

On the Shopify Shop Card window, turn on the Allow Data Sync to Shopify toggle. This toggle is intended to protect the online shop from getting demo data from Business Central.

Oauth error invalid_request: Could not find Shopify API application with api_key

It seems you use the Embed App, where the client URL has the format: https://[application name].bc.dynamics.com. The Shopify connector doesn't work for Embed Apps. For more information, see What Microsoft products is the Shopify connector available for.