How can I accurately track inventory cost changes?

Shopify Apps
,

Topic summary

Shopify merchants are struggling to track inventory costs that fluctuate with each restock due to changing wholesale prices, shipping costs, and taxes. The core issue: Shopify doesn’t natively support tracking multiple cost tiers for the same SKU.

Current workarounds mentioned:

  • Creating duplicate inventory items (one active, one draft) for each price change, then swapping them when stock depletes—described as highly inefficient and causing inventory tracking errors
  • Manually updating costs only when product prices change significantly, ignoring minor shipping variations
  • Year-end manual reconciliation using Excel spreadsheets to track all price variations and inventory counts

Desired solution:
A hierarchical cost tracking system where one SKU could have multiple cost “lines” that automatically rotate as inventory from each batch sells through, maintaining accurate COGS without creating separate product records.

Status:
No solution has been identified after multiple years of searching. One user notes the basic Shopify plan doesn’t retain historical inventory data beyond a few months. The discussion remains unresolved, with participants seeking either a native Shopify feature or third-party app recommendation.

Summarized with AI on October 28. AI used: claude-sonnet-4-5-20250929.
1

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.

1 Like
2

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?

1 Like
3

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.

1 Like