Help with Lightspeed Retail Maximum values

jaikamat

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

Adrian Samuel

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 :)

jaikamat

@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 Samuel

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!

jaikamat

Awesome, thank you!