Hi there,
I’m using Stitch to daily load the Shopify data into BigQuery. I’m using table inventory_items to get the costs for every product joining it on inventory_item_id (id in this table).
I ran into the issue that some of the id 's are missing from table inventory_items. Some inventory_item_id 's exist in tables products and inventory_levels but not in inventory_items. Thus, I do not see the costs for some products in the data, as it is only stored in table inventory_items.
Is there anything I can do to fix this?
Thanks,
Irina