Hi there, I found a very helpful site under the inventory section called ‘Inventory History’. what we like about it is that it shows the actual order or draft that reduced the inventory, or the increase of inventory through restocking. now the challenge is that this is a site per variant of a SKU…

Unfortunately, as far as I can see, Shopify doesn’t expose the inventory history through the API.

Hi Lukasz, thanks for the reply. however this export does not include the inventory history per item. I guess I could recreate it by using existing inventory and then in excel sorting the order export by the items and then subtracting the line items from the inventory ordered by the date… but that…

Thanks for clarification. I’m going to look into the Shopity API and check if it would be possible to create such a custom export.

Lukasz I really appreciate you looking into this. And sorry for not being clearer earlier. Basically I just want to have the Inventory History Exportes but for all variants with the same information as you can see on the second screen. Rather than go into every product, then variant and then click …

I’ve asked Shopify Support directly about this before. They said there is no way to export. Not only does it give you the history of a SKU, but other details such as who manually adjusted or if a 3rd party app made a change… this data is not available anywhere else. I may submit a feature request no…

I just don’t get it. Does no one in the Shopify world need to use inventory adjustments of various categories for accounting purposes? It seems not. Things like shrinkage, breakage, charity and miscounts need to be accounted for in PnL. Very frustrating.

We need this for when we reduce inventory internally. Ridiculous that you can’t export or otherwise get access to the data.

I will note that we started using the Stocky app for inventory management functions including PO/receive and adjustments. It’s by no means perfect, but it enables some missing functionality in the core Shopify system. We are able to create inventory adjustments with classifications. I can dump a CSV…

Export inventory history with order numbers

Shopify Discussion

LukaszWiktor February 6, 2020, 3:16pm 2

Hi Evert,

Have you tried exporting orders? You’ll get a CSV file that includes line items with order numbers, SKUs and quantities. Or is this not sufficient?

Best regards,
Lukasz

Topic		Replies	Views
How to export inventory history for advanced data analysis? Shopify Discussion troubleshooting	2	108	September 28, 2024
How can see the variants(inventory) quantity history shopify Graphql Basics And Troubleshooting	1	617	September 17, 2021
INVENTORY - HEEEEELP :) Payments + Shipping & Fulfilment inventory	2	36	November 15, 2024
Fetch Inventory History data via API Partners Discussion	2	1786	September 13, 2021
Shopify Flow App - track inventory adjustment history for each SKU Shopify Apps shopify-apps	3	159	September 25, 2024

Export inventory history with order numbers

Related topics