What's New: Troubleshooting Shopify Integration (2023 release wave 2)

Overview

The video walks through the tools added to the Shopify connector for finding out why synchronization fails. It starts with the reworked Shopify log entries view, which now shows request and response columns, an error indicator and a request ID for Shopify support. Log responses include a user error section, and the logging mode on the shop card is now an option field with disabled, fully enabled and error only (default).

It then covers log retention, product error handling, Business Central fulfillment service, Shopify API versioning and the end of support date on the shop card. The demos show running synchronization in the foreground to see errors, using Shopify orders to import as a buffer table, inspecting received Shopify data, comparing it with Shopify JSON, and resolving shipment synchronization errors through the Role Center and the Shopify fulfillment ID field.

Key points

• Logging mode on the Shopify shop card is now an option field: disabled, fully enabled, or error only (default), so logs hold only errors by default.
• Log entries show request and response columns and an error checkbox. The request ID can be given to Shopify support.
• Log responses contain a user error section, for example invalid phone numbers or blank required fields. Product queries also return user errors.
• Retention policy deletes Shopify log entries older than one month by default. The Shopify data capture retention policy is disabled by default.
• To debug, disable background job queue synchronization and run it in the foreground to see errors and copy call stacks.
• Shopify orders to import is a buffer table. The Get orders action retrieves orders modified after a date, and the Has Error field shows import errors. Appending JSON to a Shopify order URL shows the raw data for comparison.
• The Shopify fulfillment ID on the document can be 0, -1 (error) or a real value. Changing -1 to 0 resets the error state. Business Central fulfillment service support was already enabled in an earlier minor update, and SKU is required when it is selected.

Features

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

• table “Shopify Log Entries” at 1:37
• table “Shopify orders to import” at 13:32
• table “Shopify shop” at 4:29
• other “Role Center” at 20:15
• other “Shopify activities” at 20:15

Not found in BC28-30: table “Shopify Log Entries”, table “Shopify orders to import”, table “Shopify shop”.

Quotes

• 1:54 “With the new upgrade, the default view looks a bit better.”
• 3:00 “And to help you to talk to Shopify support, you need to use a request ID.”
• 4:29 “Now logging mode transformed from the boolean on and off into the option field.”
• 7:51 “Be aware that already before this release in one of the minor updates, we enabled full support for business central fulfillment service.”
• 9:45 “Every quarter they release a new version of the API. So, four times per year, there is a new version. And each version is”
• 11:44 “But if you experience some problems, sometimes it’s easier to explore it in the foreground.”
• 13:32 “Shopify orders to import. It’s not just a filtering opportunity. It is in reality the buffer table.”
• 13:32 “It’s not just a filtering opportunity. It is in reality the buffer table.”
• 14:09 “If I will press it, I will get orders which were modified after some specific date.”
• 15:46 “Header, fully payments, transactions, shipments, lines, returns, refunds, like a lot of stuff.”
• 16:14 “Now you can see like what exactly we received from Shopify. So now you can understand if it’s problem about data which we received”
• 17:23 “And then in the URL you just add JSON. Now you can see like representation of Shopify.”
• 21:08 “And it can be 0, -1 if it’s some error, or the actual value. If it has an actual value, then all good.”
• 22:03 “Shopify API versioning. No need to worry. Just stay updated.”

Disclaimers in the video

• 7:51 not-in-this-release: full support for business central fulfillment service already before this release in one of the minor updates
• 22:33 other: I hope you will not need all these tools because connector is again more and more stable. And less issues are happening with it.

Presenters (as heard): Andrei Panko.