How can I accurately track inventory cost changes?

[CrossedHearts]

I've looked this question up and though it's been asked several times, no one seems to want to touch it.  I'm hoping there is a brave soul who has an answer or something has been developed since the last time the question was posed.

When I stock a product for the first time, I enter that information into the cost of the item.  So let's say I carry a blue widget with a wholesale price of $1.00 but I also will be including tax of .02 cents per item and shipping cost of .05 cents per item.  I've purchased 200 of them but two weeks later I sell out and need to replenish my stock.

So...this time the wholesale price has gone up by .05 cents per item due to rampant inflation BUT because they sold so well and I'm ordering 500 this time,  I'm getting a price break of .10 cents per item leaving my widget at now .95 cents per item.  Tax hasn't changed so it's still .02 cents per item but shipping has gone up again so my price per item will be .07 cents this time.

The math on this particular word problem isn't important but only there to prove a point.  Every single time I replenish supplies there is a PRICE change.  Is there an app that will accurately track these items and their wholesale cost per shipment without having to do it manually? 

Right now (this is so stupid but it's the only way I can figure out how to do it with the tools available) I enter each shipment as a different inventory item.  One is active and one is in draft.  When I run out of the item I have to try to catch it (??? I literally have 1000's of line items in inventory so this is almost impossible) I archive the 1st version and make the 2nd version active.  There are so many holes in this method.  First, it screws up my overall inventory.  Second, it's the most inefficient process I've ever dreamed up.  I just can't figure out how to get around it.  

It would be really cool if there were multiple lines available with an assigned hierarchy.  The first line would have the inventory amount and the cost associated with that group/wholesale order.  When that sells out, it would automatically go to the next line in the hierarchy with the cost for that group/wholesale order, until that sells out, and so on.  That way, the sku's the barcodes, inventory, etc. could all be housed in ONE record instead of multiple different ones depending on how many times that item is resupplied/repurchased.

I hope this makes sense!  I KNOW I can't be the only person with this issue.  Thank you in advance for any advice or help you can provide. 

[bnbsnacks]

We’re having the same issue one two items in particular. Did you ever find a work around, or did you have to resort to another paid app?

[LBrod]

This has been my number 1 problem with Shopify since I started 6/7 years ago, and I've never found a solution, which means inventory at the end of the year is a beast because I can't rely on Shopify to track my inventory. Right now, I order a product and put in the cost (product+shipping). When the price changes (always because shipping changes) I don't usually change it until the price of the product itself changes. So I reorder 5 times in the year and have 5 different priced items that I need to track for year-end inventory and Shopify is 0 help. So...I order whatever I need and at the very end of the year put everything into an excel spreadsheet with all the price breakdowns. It takes a very long time. Then I have to do my counts, and then go back and enter all those counts into the spreadsheet. I have not figured out a solution for this and I cannot wrap my head around how other people do this because surely I'm not the only person that reorders products?? I also have the basic Shopify plan so I can't even track inventory - all the data disappears in a few months because they want me to upgrade.