How is priceCost/calcAvgCost calculated in eCom/Omnichannel?

VintageWineGuyVintageWineGuy Member Posts: 120 ✭

I am looking at some API extracts of data to try to get some financials. I am trying to figure out how Cost information is being calculated in an Omnichannel setup. When comparing the outputs of the Sale retail API with the output of the orders ecom API, I cannot figure out how the cost columns match up?

For example, in eCom.orders, I see a priceCost of $16.00 on a transaction.

In Retail.Sale, same transaction, I see calcAvgCost and calcFIFOCost of $13.34

Looking across all my transactions, I can't see any that the cost data matches. So curious as to how cost is calculated on both sides, given that it should be sharing the same cost information?


Thank you.

Answers

  • VintageWineGuyVintageWineGuy Member Posts: 120 ✭

    Hey @Lightspeed , Any help on this?

  • JoeyJoey Administrator, Moderator, Lightspeed Staff Posts: 277 moderator

    Hi @VintageWineGuy

    I can only provide you with a quick answer at this time, my appologies. The calculated cost in Retail is much more advanced than eCom as every single item in QOH has it's own cost.

    eCom has a single cost for all items.

    This is where the discrepancy could come from.

    eCom Support Team
    Lightspeed HQ
Sign In or Register to comment.