Skip to main content
Glama

Lightspeed Retail (R-Series) MCP by usefulapi

List items

list_items
Read-only

Search the product catalog. Each item has itemID, description, SKUs (systemSku, customSku, upc, ean, manufacturerSku), defaultCost, categoryID and its Prices (price levels). Set include_stock to add per-shop quantities (ItemShops; shopID 0 = all shops). Paginate with next_url. GET /Account/{accountID}/Item.json.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
eanNoExact EAN.
upcNoExact UPC.
sortNoSort field; prefix "-" for descending. Allowed: itemID, timeStamp, description.
limitNoRecords per page (1-100, default 100).
min_qohNoOnly items with at least one shop record whose quantity on hand is >= this (loads ItemShops).
archivedNofalse (default) = active records only, true = active and archived, only = archived only.
next_urlNoTo get the next page: the next_url value from a previous call of this same tool, unchanged. Other filters are ignored when it is set.
item_codeNoExact match on itemID, UPC or EAN.
vendor_idNoOnly items whose default vendor is this vendorID.
custom_skuNoExact custom SKU.
system_skuNoExact Lightspeed system SKU (the barcode on labels).
category_idNoOnly items in this category (categoryID).
descriptionNoDescription contains this text (like search).
include_stockNoInclude per-shop stock (ItemShops relation).
modified_sinceNoOnly items modified at or after this time (item timeStamp, UTC unless an offset is given).
include_categoryNoInclude the Category record.
manufacturer_skuNoExact manufacturer SKU.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

Score is being calculated.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.