Is there an app to automatically calculate new product costs?

Shopify Apps
,

Topic summary

Seeks an app to automate recalculating a product’s updated unit cost when new stock arrives and is combined with existing inventory. Wants the app to pull current available quantity and cost from Shopify, merge it with the incoming stock’s quantity and cost, and compute the new cost.

Currently does this with a manual Excel formula (example: 10 units at $5 plus 20 units at $6), which becomes tedious for more complex cases.

Request is for Shopify app recommendations that perform this calculation directly from store data. No answers or solutions provided yet; discussion remains open.

Summarized with AI on January 2. AI used: gpt-5.
1

Hey, so I have many products, and sometimes I receive new stock from some product that I already have so I have an issue calculating the new cost. Here’s an example:

Product 1:

Available stock 10

Cost $5

Incoming stock 20

Cost $6

I usually calculate the new cost manually in Excel (when numbers are more complex its very tedious) with a particular formula.

I was wondering if there is an app that can calculate the new cost taking the information from Shopify (available quantity and cost), and the information of the new stock + quantity.

Thank you very much!!