Export inventory history with order numbers

Solved

Export inventory history with order numbers

greiseve
Explorer
63 1 88

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 that I need to manually navigate to.

I'd love to get this information in a CVS file across all variants and all SKUs so that I can slice it and dice however I want. it would be very helpful for example in tagging products for orders as I can ask my team to just go out and tag products based on orders and they don't do it based on orders (a lot of running around in a big warehouse) but rather by SKU and then consolidate the products for each order to fulfill.

Any suggestions how to get to this data?

Thanks

Evert

Accepted Solution (1)
LukaszWiktor
Shopify Partner
314 24 120

This is an accepted solution.

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

I'm a software engineer. I make things happen automatically.
Check out my apps Exporteo, Fulfilleo, Stockeo, and Personal Discount.

View solution in original post

Replies 9 (9)

LukaszWiktor
Shopify Partner
314 24 120

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?

 

export-orders.png

 

Best regards,
Lukasz

I'm a software engineer. I make things happen automatically.
Check out my apps Exporteo, Fulfilleo, Stockeo, and Personal Discount.
greiseve
Explorer
63 1 88

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's all manual. go to inventory and then chose a product. if you scroll further down you find the inventory history - that's the information that I'd like to have for every product and every transaction on our site exported in one file.

Screen Shot 2020-02-06 at 7.22.11 AM.png

 

Screen Shot 2020-02-06 at 7.23.57 AM.png

 

thanks,

Evert

 

LukaszWiktor
Shopify Partner
314 24 120

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.

I'm a software engineer. I make things happen automatically.
Check out my apps Exporteo, Fulfilleo, Stockeo, and Personal Discount.
greiseve
Explorer
63 1 88
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 on the link to see Inventory History. Very cumbersome and we only have like a 100 variants in total!
LukaszWiktor
Shopify Partner
314 24 120

This is an accepted solution.

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

I'm a software engineer. I make things happen automatically.
Check out my apps Exporteo, Fulfilleo, Stockeo, and Personal Discount.

stephenmed
Visitor
2 0 1

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 now that I know I'm not the only one that could benifit from this.

 

jredneck
Excursionist
12 0 18

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.

kallenconsult
Explorer
60 1 18

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

jredneck
Excursionist
12 0 18

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 periodically that includes cost, then sort and summarize for journal entries.