AvgCost and default cost per item per shop

rodeomasterrodeomaster Member Posts: 15


For our financial reports we would like to retrieve the default cost and average cost per item per shop. It seems like we are only able to retrieve the costs per item, and not per shop. Is there a way to get this using the retail API?



  • rodeomasterrodeomaster Member Posts: 15


    We would like to create a financial report using this option, so we really hope this is possible. Is the questions clear?

  • LucienVersendaalLucienVersendaal Moderator, Lightspeed Staff Posts: 926 moderator

    Hi @rodeomaster,

    Thank you for contacting us.

    As far as I know we don't have this kind of report, unfortunately. What you can do is take a look at our integrations page which helps you with analytics: https://www.lightspeedhq.com/pos/retail/integrations/?category=analytics

  • rodeomasterrodeomaster Member Posts: 15

    Hi Lucien,

    Thanks for your answer. Are you sure this is the case? Because it is possible to find this (the avg cost per item per shop) in the LS portal. Other wise a other company like you suggested would also not be able to retrieve this from the API

  • Ali_MasoumieAli_Masoumie Moderator, Lightspeed Staff Posts: 183 moderator

    You can get the default cost and average cost per item from the items endpoint, but this is (as you've noticed) for all shops and not per shop.

  • jeroenTPLjeroenTPL Member Posts: 5

    Hi @Ali_Masoumie ,

    We're also looking for this endpoint. In the LS portal under reports, we can check the assets per shop. The assets are calculated with the avg_cost per shop.

    However the API counts with the avg_cost over all shops. Therefore the assets value is not the same and not accurate. This makes it impossible to calculate the assets per shop with the API.

    Could you look into this to check if we can get the avg_cost per shop in the API?

Sign In or Register to comment.