Shopify Troubleshooting

Learn how to troubleshoot common issues with Shopify connections.

Data Discrepancies

• The CUSTOMER Table Is Not Created in the Destination
• The GIFT_CARD and USER Tables Are Excluded From the Sync
• The inventory_item_id Column in the PRODUCT_VARIANT Table Contains null Values
• TRANSACTION Table Data Is Not Updating Correctly
• Why Don't the Order Dates in Shopify Match the Order Dates in My Destination?
• Why Is the default_address_id Column Empty in the CUSTOMER table?
• Refunded and/or Cancelled Orders Missing From Shopify Tables

Errors, Warnings, and Alerts

• Warning: Delete Order - Shopify GDPR

FAQ

• Can I Increase Shopify’s REST API Pagination Limit?
• How Does Fivetran Get the Key-Value Pairs for the ORDER_URL_TAG Table?

How To

• Associate Your Orders With Discounts
• Identify First-Time or Repeat Customers
• Optimize the Sync Speed
• See Fivetran as a Connected App in Shopify
• Sync UTM Parameters

Syncs

• Why Is My Sync Slow or Delayed?