Help with Lightspeed Retail Maximum values

jaikamatjaikamat Member Posts: 6

Hi Admins,

I'm helping a local business design a custom inventory solution via the Lightspeed API. Had a couple questions:

  1. Is there a maximum number of inventory items allowed in the Lightspeed retail POS? It's looking like they'll need to upload about 50,000 records.
  2. When uploading item matrices, do these items count towards that total, and how are individual totals of each atomic (matrixed) item recorded when the whole item itself appears to have only one quantity field?

Thanks much! Appreciate your time and help

4 comments

  • Adrian SamuelAdrian Samuel Moderator, Lightspeed Staff Posts: 572 moderator

    Hey @jaikamat,

    1) I'm not aware of hard limits but 50k records is fine

    2) Matrices are templates for Inventory Items to inherit and thus do not count towards the total :)

    Adrian Samuel

    API Integrations Consultant - Strategic Solutions

    Lightspeed HQ

  • jaikamatjaikamat Member Posts: 6
    edited November 13

    @Adrian Samuel, thanks so much for the prompt reply - appreciate it.

    Sounds good regarding the records.

    I worded #2 improperly. Let me clarify with a use case - let's say I upload a shirt item to the inventory, with a 2x2 matrix of small/large and white/black. How will I know how many of each individual variation exists in the inventory? Seems like line-items just have the one quantity - or are separate line-tems created for each possible combination?

  • Adrian SamuelAdrian Samuel Moderator, Lightspeed Staff Posts: 572 moderator

    Hey @jaikamat,


    Every item associated to a Parent Matrix template is associate with a unique itemMatrixID so if you know the itemMatrixID in advance you could query something like this:

    METHOD: GET

    URL: https://api.lightspeedapp.com/API/Account/{{accountID}}/Item.json?itemMatrixID={{itemMatrixID}}

    There is a count parameter accessed by ["@attributes].count that will give you the amount of items associated with that matrix.

    You can read more about this endpoint here:

    https://developers.lightspeedhq.com/retail/endpoints/Item/

    Otherwise for general discovery


    METHOD: GET

    URL: https://api.lightspeedapp.com/API/Account/{{accountID}}/ItemMatrix.json?load_relations=["Items"]

    Will return every matrix and all associated child item.

    You can read more about this endpoint here:

    https://developers.lightspeedhq.com/retail/endpoints/ItemMatrix/

    Hope this helps!

    Adrian Samuel

    API Integrations Consultant - Strategic Solutions

    Lightspeed HQ

  • jaikamatjaikamat Member Posts: 6

    Awesome, thank you!

Sign In or Register to comment.