Why Is My Shopify Sync Slow or Delayed?

Your Shopify connection may sync slowly or experience delays if you have included certain tables in your connection schema that require nested API calls. Find out which tables can impact your sync speed and how to optimize your sync performance.

What causes slow or delayed Shopify syncs?

We make nested calls to the following Shopify endpoints:

• DISCOUNT_CODE
• FULFILLMENT_EVENT
• ORDER_RISK
• *_METAFIELD
• TRANSACTION

Including these tables in your connection schema may increase your sync time. The FULFILLMENT_EVENT table is particularly likely to increase your sync time. When you attempt to include it in your schema, we display the following warning:

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

How to improve your Shopify sync speed

To optimize the sync speed during historical syncs, exclude the following tables from your connector's schema:

• DISCOUNT_CODE
• FULFILLMENT_EVENT
• ORDER_RISK
• *_METAFIELD
• TRANSACTION

To optimize the sync speed during incremental syncs, exclude the following tables from your connector's schema:

• DISCOUNT_CODE
• FULFILLMENT_EVENT
• ORDER_RISK
• *_METADATA

We particularly recommend excluding the FULFILLMENT_EVENT table. To check if the FULFILLMENT_EVENT table is impacting your sync speed, do the following:

1. Review your logs using our Fivetran Platform connector or external logging services.
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.