Back to Tables
Items Table
Inventory and service items from Xero. View item codes, prices, descriptions, and stock levels.
Use it to get a full price list, a stock-on-hand report or a margin check out of Xero and into a sheet you can sort and filter, without exporting a CSV every time.
What you can build with it
- Price list: keep Code, Name and SalesPrice, filter IsSold to TRUE, and you have a customer-ready price list that refreshes from Xero.
- Stock valuation: filter IsTrackedAsInventory to TRUE; QuantityOnHand and TotalCostPool give you units and value on hand per item.
- Margin check: add a column for SalesPrice minus PurchasePrice (or the % equivalent) to spot items sold below cost or with thin margins.
Items table or XO.LITEM?
The table gives you the whole list on one sheet. If you only need one detail of one item in a single cell (say the price of “WIDGET-001” next to a quantity), use the XO.LITEM formula instead.
Output Columns
| Column | Description |
|---|---|
| Code | Item code (SKU) |
| Name | Item name |
| Description | Sales description |
| PurchaseDescription | Purchase description |
| PurchasePrice | Cost price |
| SalesPrice | Selling price |
| IsSold | Whether item is sold |
| IsPurchased | Whether item is purchased |
| IsTrackedAsInventory | Whether inventory tracked |
| QuantityOnHand | Current stock quantity |
| TotalCostPool | Total inventory value |
| ItemID | Xero unique identifier |
Plus OrgID, OrgName, and Timestamp columns.
API Limitation
No archived/deleted filter is available for Items, because the Xero API does not support item status filtering. All items (active and inactive) are always returned.
Tips
- Filter by IsTrackedAsInventory to see stock items
- Use QuantityOnHand for reorder point analysis
- Compare SalesPrice vs PurchasePrice for margin analysis