Why Is My Shopify Sync Slow or Delayed?

Question

Why does my Shopify connection sync slowly or experience significant delays?

Environment

• Connector: Shopify

Answer

Your Shopify connection may sync slowly or experience delays if you have included certain tables in your connection schema that require nested API calls.

What causes slow or delayed Shopify syncs?

We make nested calls to the following Shopify endpoints:

• DISCOUNT_CODE
• FULFILLMENT_EVENT
• FULFILLMENT_ORDER
• *_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:

Syncing 'fulfillment_event' table might slow down your sync

How to improve your Shopify sync speed

To exclude tables and optimize your sync speed:

1. In Fivetran, go to your Shopify connection page.
2. Select the Schema tab.
3. Uncheck the tables you want to exclude from your sync.
4. Click Save changes.

To optimize the sync speed during historical syncs, exclude the following tables:

• DISCOUNT_CODE
• FULFILLMENT_EVENT
• FULFILLMENT_ORDER
• *_METAFIELD
• CUSTOMER_VISIT
• TRANSACTION

To optimize the sync speed during incremental syncs, exclude the following tables:

• DISCOUNT_CODE
• FULFILLMENT_EVENT
• *_METAFIELD

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.