Back to Functions
XO.LITEM
Lookup a property of an inventory item by item code. Returns name, description, price, or status.
Syntax
=XO.LITEM(org_id, item_code, property)
Parameters
| Parameter | Required | Description |
|---|---|---|
| org_id | Yes | Organization ID from XO.ORG() |
| item_code | Yes | Item code (must match exactly) |
| property | Yes | Property to return (0-3) |
Property Options
| Code | Property | Description |
|---|---|---|
| 0 | name | Item name |
| 1 | description | Item description |
| 2 | price | Sales unit price |
| 3 | status | Item status (ACTIVE, INACTIVE) |
Examples
Get item name:
=XO.LITEM(A2, "WIDGET-001", 0)Get item price:
=XO.LITEM($A$2, "SERVICE-A", 2)