Could Shopify enhance the line item object to include a cost field?
This is so that we can access the historical cost of the item at the time of the sale.
At the moment, we can look up the price from the inventory item, but this is the current as of now.
I have not heard of any plans to add cost to an order's line item.
However, you could definitely perform this mapping as an app by verifying costs in response to an order webhook.
Additionally, for orders that existed before your app was installed, you could compare the updated_at fields on both the order and the inventory_item to determine if the cost has potentially changed since the order was placed.
Thanks Alex, I thought about that but it's really not ideal.
What we want is line_item.cost, just like line_item.price
My understanding is that the Shopify margin reports are using the historical cost of the line item (at the time of the sale), so I would assume that it is already captured somewhere in the order data.
Consider this an official feature request 🙂
I'd like to third this request. Right now to calculate order cogs you need to go:
Order -> line_item -> variant -> inventory_item -> cost
And, as was pointed out in this thread, that is based off the current cost and not the cost at the time of the transaction.
Having order.line_item.cost would be very helpful as an app developer.
I agree, this should be considered and added by Shopify.
The solution proposed by Alex_B does not take into consideration that an item cost can change multiple times while several orders are placed.
Totally agree! This should be considered for implementation asap by Shopify.
Are there any updates on this? I have seen multiple threads about this over the last few years and little to no action/update on shopify's end, even though the data exists in shopify. We need this available to properly calculate margin and is a necessity to our business.
Connect your PayPal account to allow your customers to checkout using the PayPal gateway a...By Ollie Jul 28, 2022