How can I generate an inventory adjustment history report for EZ Inventory?

In the Shopify Admin > Analytics > Reports, you can use the ShopifyQL query below to generate a report of inventory adjustment changes made by the EZ Inventory app in the last 30 days:

FROM inventory_adjustment_history
  SHOW inventory_adjustment_change
  WHERE inventory_app_id = 2303888
  GROUP BY second, inventory_adjustment_id, product_variant_id,
    product_variant_title, product_variant_sku, inventory_app_name, inventory_app_id,
    inventory_state, inventory_location_name
  SINCE startOfDay(-30d) UNTIL today
  ORDER BY second DESC

If you want to see a longer inventory adjustment history, simply adjust the startOfDay(-30d) part of the query. 


App: EZ Inventory

Tags: inventory history, shpoifyql