How can I export the "Unavailable" inventory quantity from Shopify?

The "Unavailable" quantity in Shopify is the sum of quantities in the following inventory states:

  • damaged
  • quality_control
  • reserverd
  • safety_stock

In EZ Exporter's Product export, you can select the field variants.inventory_levels.total_unavailable to export the total unavailable quantity for the variant.

To only export the quantity for a specific location, you use the formula below in the Calculated Fields (replace "Warehouse A" with your location name):

get_total([q.quantity for q in load_json_data(search_attributes({{ variants.inventory_levels }}, "Warehouse A", search_key="location_name", result_key="quantities")) if q.name in ["damaged", "quality_control", "reserved", "safety_stock"]])

Related Articles:


App: EZ Exporter

Tags: shopify inventory export