The inventory_item_id Column in the Shopify PRODUCT_VARIANT Table Contains null Values

If you're seeing null values in the inventory_item_id column of the PRODUCT_VARIENT table, it may be because we're not syncing the required data from another table. Find out how to update your connection's configuration to ensure the column populates the correct data.

Why the inventory_item_id column contains null values

The inventory_item_id column in the PRODUCT_VARIANT table relies on data from the INVENTORY_ITEM table. As a result, if the INVENTORY_ITEM table isn't included in your connection schema, we can't populate the the inventory_item_id column, resulting in null values.

How to include the INVENTORY_ITEM table in your schema

To resolve this issue, do the following:

1. In Fivetran, go to your Shopify connection page.
2. Select the Schema tab.
3. Select the checkbox next to the INVENTORY_ITEM table.
4. Click Save changes.