The inventory_item_id Column in the PRODUCT_VARIANT Table Contains null Values

Issue

The inventory_item_id column in the PRODUCT_VARIANT table contains null values.

Environment

Connector: Shopify

Resolution

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 to include it in your syncs.
4. Click Save changes.

Cause

The inventory_item_id column in the PRODUCT_VARIANT table depends on data from the INVENTORY_ITEM table. As a result, if you don't include the INVENTORY_ITEM table in your connection schema, the inventory_item_id column will populate with null values.