Why Does the available Column in the Shopify INVENTORY_LEVEL Table Always Display 0?

Shopify no longer includes the available field in responses from the InventoryLevel API object. As a result, we don't populate the available column in the INVENTORY_LEVEL table. In older connections where the column still appears, we populate it with 0.

To query current inventory values, use the quantity column in the INVENTORY_QUANTITY table:

SELECT * FROM [Schema_Name].inventory_quantity WHERE name = '';