Question

What is causing a long historical sync or incremental sync?

Environment

Connector: Shopify

Answer

Sync of fulfillment_event table

The fulfillment_event table can take a long time to sync due to the time it takes to extract the data via the Shopify API. There is a Warning on this table in the schema config informing of slow sync:

To verify this:

1. Go to the Dashboard logs for the Shopify connector.
2. Select one of the latest logs to see the full log info.

3. A URI parameter showing a value, such as:

   https://<shopify_url>.myshopify.com/admin/api/2021-07/orders/<order_id>/fulfillments/<fulfillments_id>/events.json?limit=250" will confirm it is extracting data for the fulfillment_event table.

Solution to help sync complete:

• De-select the fulfillment_event table

Other Causes

Check our article for other causes of Slow or Delayed Sync.