How to accurately track cost of goods with overlaping inventory?

Shopify Discussion
1

Hi community, I want to ask if there is a solution to this problem. I am running a warehouse/grocery store in which we replenish inventory before it completely runs out. A problem I am running into is if I have 1 remaining inventory that I received at “$35”, and I were to change my cost of goods in “inventory” before I receive a “transfer” of 1 of the same item to “$40”, and I make a sale for 2 of that item, cost of goods will calculate at “$80” instead of “$75”.

  • 1 Item A remaining received COG $35

  • Received 1 new inventory item A COG $40 (updated COG through inventory before receiving through transfer)

  • Sold 2 item A

  • Report shows COG as $80 instead of $75

Is there a workaround or an app that would allow me to report more accurately?

THANKS!