Inventory Adjustment Report

It’s wild to me that Shopify doesn’t have a report to track inventory adjustments and doesn’t make this data accessible for third-party apps to create a reporting mechanism. In trying to find a solution, Shopify noted that you’re able to go into an individual product and view the adjustment history, but that’s obviously not feasible for most shops, and especially us with well over 10,000 products.

What’s everyone else doing to track this? We need to track and report these adjustments for tax purposes primarily.

2 Likes

See also https://community.shopify.com/c/fulfillment-and-inventory/ability-to-run-a-report-that-shows-all-inventory-adjustments/m-p/2203816

and https://community.shopify.com/c/shopify-discussions/can-we-access-inventory-history-beyond-90-days-in-shopify/m-p/2483349

https://community.shopify.com/c/shopify-apps/can-an-app-generate-a-custom-inventory-decrease-report-for-cpb/m-p/2050145

etc

tl;dr Since there is no native inventory history api the only way to have a history in the future is to start self-serve logging of current inventory and record adjustments in custom solutions.

There are probably apps that can start this process for reporting at current inventory levels; but as far as I know there is also no off the shelf app or service that can backfill it’s own app-reports data even IF you have the historical data gathered externally.

Hi, I created Inventory History Guardian for this exact problem. It allows you to create adjustments with notes, see all adjustments across your store in one place and export it, it also saves them so you don’t lose them after 90 days.

Bump. We need a solution to this problem.

1 Like

I’ve been looking for an answer for this for the past month and have read several posts, articles, etc. I think the only free option for this is to adjust inventory through Stocky, then run a report. In Stocky, go to Inventory > Adjustments > Create adjustment, then scan and/or add items to the adjustment. You can also add custom reasons for adjustments. At the end of the month (or whatever time period), you can run a report in Stocky (Reports > Adjustments) to view and filter reasons, etc. Note: The adjustment syncs to Shopify but the reason does not sync (only shows as “Stocky”). This doesn’t matter to me though since I can’t easily view this information in Shopify anyway. I know it’s not ideal but I hope this helps!