Shopify TRANSACTION Table Data Is Not Updating Correctly

If the Shopify TRANSACTION table data is outdated and doesn't match what you see in Shopify, it may be because a required table isn't included in your connection schema. Find out how to update your connection's configuration to ensure the table populates with the correct data.

Why is the TRANSACTION table data not updating correctly?

The TRANSACTION table depends on data from its parent, the ORDER table. This issue occurs when you include the TRANSACTION table in the schema, but not the ORDER table.

How to include the ORDER table in your schema

To ensure the TRANSACTION table populates correctly, do the following:

1. In your Fivetran dashboard, go to your Shopify connector page.
2. Select the Schema tab.
3. Check the ORDER table check box.
4. Click Save changes.