Troubleshoot export issues on Shopify Skipped Records page

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically - Apr 2025

Business value

When a business experiences a problem with the integration of their front end, Shopify, and their back end, Business Central, it's important to quickly get to the bottom of the issue. Having different levels of logging reduces the time it takes to resolve a problem with your integration between Shopify and Business Central.

Feature details

When you export data to Shopify, the Shopify Connector skips records that Shopify will reject or that aren't valid for export for other reasons. While the behavior is expected, you might be confused if some information wasn't processed as you expected. You can now find those entries on the Shopify Skipped Records page, which shows all skipped records and provides the reasons and the date and time the records were skipped.

Shopify Skipped Records

Cases that the Shopify Connector logs

Customer:

  • A customer has an empty email.
  • A customer with the same email or phone number exists.

Posted sales invoice:

  • Customer doesn't exist in Shopify.
  • Payment term mapping is missing.
  • Customer number is the default customer number for the Shopify Shop.
  • Customer number is used in the Shopify customer template.
  • No lines exist in the sales invoice.
  • Invalid (negative or fractional) quantity.
  • Empty number value.

Product:

  • Item is blocked/sales blocked (item variant).
  • Item is blocked.
  • Item description is empty.

Catalog:

  • Price sync if the catalog isn't found in Shopify.

Shipments:

  • Related Shopify order doesn't exist.
  • No lines in the posted sales shipment are applicable for fulfillment.
  • No corresponding fulfillment is found in Shopify.

If you run sync in the foreground you will get a notification if records were skipped. Choose View Skipped Records to open the Shopify Skipped Records page.

Notification

Setup

The Logging Mode field controls the content of the Shopify Skipped Records page. Note that the All option works in the same way as Error Only and logs only skipped entries. It won't log entries that were previously skipped.

Retention policy

To help you keep your database size under control, Shopify Skipped Records is included in Define Retention Policies.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.