Slow or Delayed Synclink

Updated 12 days ago

Issuelink

The connector is experiencing a slow or delayed sync.

Environmentlink

Connector: Shopify

Resolutionlink

Check if your connector schema includes the FULFILLMENT_EVENT table. If you include the table, you may experience a slow or delayed sync due to the increased time it takes to extract the relevant information using Shopify's API.

When including the FULFILLMENT_EVENT table, the following warning appears in the Fivetran dashboard:

Not recommended: Syncing FULFILLMENT_EVENT table might slow down your sync.

To check if the FULFILLMENT_EVENT table is impacting your sync, do the following:

1. In Fivetran, go to the Logs tab of your Shopify connector.
2. Select the latest log to see all relevant information.
3. Look for a URI parameter that includes the word fulfillment. For example, https://<shopify_url>.myshopify.com/admin/api/2021-07/orders/<order_id>/fulfillments/<fulfillments_id>/events.json?limit=250.

To resolve any delays, exclude the FULFILLMENT_EVENT table from your syncs.