ItemId to ItemCountId

jtellierjtellier Member Posts: 36

Hoe do you go from a list of Item[] from the Item API to get the associated InventoryCount?

Thanks in advance!

5 comments

  • LucienVersendaalLucienVersendaal Moderator, Lightspeed Staff Posts: 345 moderator

    Hi @jtellier,

    Thank you for reaching out to us.

    What do you want to achieve?

  • jtellierjtellier Member Posts: 36

    I would like to get the inventory count for an item..... so once I have an itemId, I need to know how many are available per item.

  • gregaricangregarican Member Posts: 510 

    Have you read the Retail API documentation? https://developers.lightspeedhq.com/retail/endpoints/Item/#get-all-items


    In this case, you would load_relations and add the ItemShops endpoint. Each item's shop allocations would appear. The dummy ShopId = 0 entity represents the cumulative on-hands for all real shops for that item.

    From the API documentation:

    shopID(integer) the foreign key for the shop the inventory quantities are in. ItemShop with shopID = 0 is a summary record that includes the QOH for all shops.

    /API/Account/{accountID}/Shop/{shopID}

  • jtellierjtellier Member Posts: 36
    edited July 6
  • jtellierjtellier Member Posts: 36

    I am gonna retract my previous statement that worked perfectly I was on the wrong POSTMAN collection. Thank you!

Sign In or Register to comment.