Items
Maintains the catalog of products and services that are offered by the business, including inventory and non-inventory items, used for sales, purchases, and expense tracking across QuickBooks Online.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
The unique identifier (Id) of the item. This value distinguishes the item record from all other items in QuickBooks Online. | |
| SyncToken | String | True | False | False |
The version number of the item record. It is used to lock the item for use by one app at a time. When an application modifies an item, its sync token is incremented. Attempts to modify an item specifying an older sync token fail. Only the latest version of the item is maintained by QuickBooks Online. | |
| MetaData_CreateTime | Datetime | True | True | True |
The date and time when the item record was created. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The date and time when the item record was last updated. | |
| Name | String | False | True | True |
The name of the item as it appears in QuickBooks Online forms and reports. | |
| FullyQualifiedName | String | False | False | False |
The fully qualified name of the item. The fully qualified name consists of the topmost parent element followed by each subelement and separated by colons. For example, Parent:Account1:SubAccount1:SubAccount2. | |
| Description | String | False | False | False |
A detailed description for the item that explains the service or product offered. This value appears on invoices, sales receipts, or purchase forms that include the item. | |
| Active | Boolean | False | True | False |
This field indicates whether the item is currently active. Inactive items that are set to false may be hidden from display and are not used in new financial transactions. | |
| ParentRef | String | False |
Items.Id | False | False |
The Id of the parent entity of the item that is referenced when the item is a subitem. If SubItem is true, then ParentRef is required. |
| ParentRef_Name | String | True |
Items.Name | False | False |
The name of the parent entity of the item that is referenced when the item is a subitem. If SubItem is true, then ParentRef is required. |
| PrefVendorRef | String | False |
Vendors.Id | False | False |
The Id of the preferred vendor entity that is linked to the item for purchase purposes. |
| PrefVendorRef_Name | String | False |
Vendors.Name | False | False |
The name of the preferred vendor entity that is linked to the item for purchase purposes. |
| SubItem | Boolean | False | False | False |
This field indicates whether the item is a subitem. A value of false or null indicates the item is a top-level item. | |
| UnitPrice | Decimal | False | False | False |
The monetary value of the service or product that is expressed in the home currency. This value is used when the item is added to a sales form. | |
| Type | String | False | True | True |
The classification that specifies how the item is used (for example, Inventory, Service, Non-inventory, or Other Charge). The allowed values are Inventory, NonInventory, Service, Category, Group. | |
| Taxable | Boolean | False | False | False |
This field indicates whether the item is subject to tax when it is sold. | |
| AssetAccountRef | String | False |
Accounts.Id | False | False |
The Id of the inventory asset account that is assigned to this item. If the same inventory asset account is assigned for multiple items, the current balance of that account shows the combined total value of the inventory. |
| AssetAccountRef_Name | String | True |
Accounts.Name | False | False |
The name of the inventory asset account that is assigned to this item. If the same inventory asset account is assigned for multiple items, the current balance of that account shows the combined total value of the inventory. |
| IncomeAccountRef | String | False |
Accounts.Id | False | False |
The Id of the income account that records the proceeds from the sale of this item. |
| IncomeAccountRef_Name | String | True |
Accounts.Name | False | False |
The name of the income account that records the proceeds from the sale of this item. |
| PurchaseDesc | String | False | False | False |
The purchase description for the item that appears on bills and purchase orders. | |
| PurchaseCost | Decimal | False | False | False |
The amount paid when buying or ordering the item that is expressed in the home currency. | |
| ExpenseAccountRef | String | False |
Accounts.Id | False | False |
The Id of the expense account that is associated with the purchase of the item. |
| ExpenseAccountRef_Name | String | True |
Accounts.Name | False | False |
The name of the expense account that is associated with the purchase of the item. |
| QtyOnHand | Double | False | False | False |
The current quantity of the inventory item that is available for sale. | |
| ReorderPoint | Double | False | False | False |
The minimum quantity of the item that should be kept on hand before reordering. | |
| InvStartDate | Date | False | False | False |
The date to start tracking inventory for the item. This value is required if the TrackQtyOnHand attribute is set to true. | |
| SalesTaxCodeRef | String | False |
TaxCodes.Id | False | False |
The sales tax code that is applied when selling this item. |
| PurchaseTaxCodeRef | String | False |
TaxCodes.Id | False | False |
The purchase tax code that is applied when purchasing this item. |
| TrackQtyOnHand | Boolean | False | False | False |
Specifies whether the system tracks the quantity on hand for this item. This setting determines if inventory levels are monitored and updated automatically when transactions occur. | |
| Level | Integer | True | False | False |
Indicates the hierarchical level of the item within a parent-child structure. This value is 0 for top-level items. Any other value specifies the depth of the item from its top parent in the hierarchy. | |
| Sku | String | False | True | False |
Specifies the stock keeping unit (SKU) for this item. This value is a company-defined identifier that is used to track and manage inventory. | |
| SalesTaxIncluded | Boolean | False | False | False |
Indicates whether sales tax is included in the item amount. When this flag is set to true, the system does not calculate additional tax for transactions involving this item. | |
| PurchaseTaxIncluded | Boolean | False | False | False |
Indicates whether purchase tax is included in the item amount. When this flag is set to true, the system does not calculate additional tax on purchases involving this item. | |
| ItemGroupDetail_ItemGroupLineAggregate | String | True | False | False |
Contains one or more Item objects that are grouped together to form a bundle. This aggregate defines the composition of bundled or grouped items within QuickBooks Online. | |
| ClassRef | String | False |
Class.Id | False | False |
The unique Id for the class object that is linked to this item as found in the Id field of the class payload. This unique Id allows you to categorize the item under a specific class for reporting and tracking. |
| ClassRef_Name | String | False |
Class.Name | False | False |
The identifying name for the class object that is linked to this item. This name provides a human-readable reference to the class that is applied. |
| ItemCategoryType | String | False | False | False |
Specifies the classification that defines how this item is used. This field is applicable only for companies in France and helps categorize items according to local reporting requirements. The allowed values are Product, Service. | |
| Source | String | False | False | False |
Specifies the source type for transactions that are created by QuickBooks Commerce. This value identifies where the item originated from within the system. The allowed values are QBCommerce. | |
| AbatementRate | Decimal | False | False | False |
Specifies the sales tax abatement rate that is applied to this item. This field is used for transactions in Indian locales to comply with regional tax rules. | |
| UQCDisplayText | String | False | False | False |
Specifies the text that is displayed on a customer's invoice to denote the Unit of Measure instead of the standard code. This text provides clarity to customers on how quantities are measured. | |
| UQCId | String | False | False | False |
Specifies the identifier of the Standard Unit of Measure (UQC: Unique Quantity Code) for the item according to GST rules. This field ensures compliance with Indian GST requirements. | |
| ReverseChargeRate | Decimal | False | False | False |
Specifies the sales tax reverse charge rate that is applied to this item. This field is used for transactions in Indian locales to comply with reverse charge tax rules. | |
| ServiceType | String | False | False | False |
Specifies the sales tax service type that is applied to this item. This field is used for transactions in Indian locales to classify services according to regional tax categories. | |
| TaxClassificationRef | String | False | False | False |
Specifies the unique identifier for the tax classification object that is linked to this item as found in the Id field of the tax classification payload. This field determines the tax treatment of the item. | |
| TaxClassificationRef_Name | String | False |
TaxClassification.Name | False | False |
Specifies the identifying name for the tax classification object that is linked to this item. This provides a human-readable reference for the tax classification that is applied. |