ShopifyQLQuery - From Inventory (but specify the location)

GraphQL Admin API Troubleshooting
1

Hey All,

Wondering if there is a workaround to get the below report via shopifyQLQuery by a warehouse location (and not total of all warehouse locations) :slight_smile:

FROM inventory
  SHOW inventory_units_sold, ending_inventory_units, days_out_of_stock,
    product_variant_abc_grade, first_day_in_inventory, inventory_units_sold_per_day
  WHERE inventory_is_tracked = true
  GROUP BY product_title, product_variant_title, product_variant_sku,
    product_variant_abc_grade WITH TOTALS
  SINCE 2025-11-18 UNTIL 2025-12-03
  ORDER BY inventory_units_sold_per_day DESC
  LIMIT 10000
VISUALIZE inventory_units_sold_per_day TYPE horizontal_bar
2

Try:

FROM inventory_by_location
  SHOW ending_inventory_units_at_location, days_in_stock_at_location,
    inventory_units_net_change_at_location
  WHERE inventory_is_tracked = true
  GROUP BY product_title, product_variant_title, product_variant_sku,
    inventory_location_name WITH TOTALS
  SINCE 2025-11-18 UNTIL 2025-12-03
  LIMIT 10000
3

@Luke Thanks, that looks like it would do the trick.