Possibility to get product cost history via API

[jakub_kalab]

Hello, I would like to ask if it is possible to download via API costs of product for historical time periods what is seen in the attached picture from shopify app. Is it possible?

[Liam]

Hi Jakub,

Have you looked into whether this data is available with ShopifyQL?

[jakub_kalab]

I have investigated REST API and there is in the inventory enpoint only information about cost in current date, but I need historical prices and these I haven't found.

https://shopify.dev/docs/api/admin-rest/2023-10/resources/inventoryitem#get-inventory-items-inventor...

[Liam]

For accessing the data that you'd find in reports on the store admin, you'd typically use the ShopifyQL API: https://shopify.dev/docs/api/shopifyql

[jakub_kalab]

And could you please send me a simple example of the query which returns the costs grouped by products and day? Or link to a similar example. I haven't found any mention of this metric in the documentation if is available.

[jakub_kalab]

Could I remind with this issue? Thank you so much.