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