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:
- How can I export the "Available" inventory quantity from Shopify?
- How can I export the "Committed" inventory quantity from Shopify?
- How can I export the "Damaged" inventory quantity from Shopify?
- How can I export the "Incoming" inventory quantity from Shopify?
- How can I export the "On Hand" inventory quantity from Shopify?
- How can I export the "Quality Control" inventory quantity from Shopify?
- How can I export the "Reserved" inventory quantity from Shopify?
- How can I export the "Safety Stock" inventory quantity from Shopify?
App: EZ Exporter
Tags: shopify inventory export