Overview

The Items Data Model is designed to simplify the management and retrieval of item-related information across various accounting platforms.

The Items Data Model represents products or services that can be sold or purchased. This unified model simplifies handling item-related information across various accounting platforms.

• Unified item properties: Essential item details such as name, description, status, and type are standardized across different accounting platforms
• Item detail flexibility: The model supports separate details for items being purchased (bill_item) and items being sold (invoice_item), enabling accurate tracking of item-related transactions
• Associated accounts and tax rates: Each item can be linked to specific purchase and sales accounts, as well as purchase and sales tax rates, for seamless integration with other accounting data models

Attributes

Items Attributes

Property	Type	Description
rootfi_id	integer	Unique identifier assigned by Commenda for this item
rootfi_created_at	string	Timestamp when this record was created in Commenda’s system (ISO 8601)
rootfi_updated_at	string	Timestamp when this record was last updated in Commenda’s system (ISO 8601)
rootfi_integration_type	enum
platform_id	string	Unique identifier for this item in the source accounting platform
name	string	The name of the item
description	string	The description of the item
code	string	The reference code of the item
sku	string
price	double
currency_id	enum
type	enum	The type of the item
status	enum	The status of the item
quantity_on_hand	integer	The quantity on hand for the item
is_bill_item	boolean	Whether there are details (bill_item) of this item getting purchased
bill_item	object	Item details of this item getting purchased
is_invoice_item	boolean	Whether there are details (invoice_item) of this item getting sold
invoice_item	object	Item details of this item getting sold
created_at	string
updated_at	string	The date and time the item was last updated

Type Enum Values

Value	Description
INVENTORY	Item is tracked as inventory
NON_INVENTORY	Item is not tracked as inventory
SERVICE	Item represents a service
DIGITAL	Item is a digital product/download
UNKNOWN	Type cannot be determined from the platform

Status Enum Values

Value	Description
DRAFT	Item is in draft status and not yet published
ACTIVE	Item is active and available for use
ARCHIVED	Item has been archived
UNKNOWN	Status cannot be determined from the platform

Expandable Attributes

Use the expand query parameter to include related objects:

• expand=variants — includes the related Variants object(s).

Properties Supported

Fields accepted when creating or updating a record:

Property	Type	Description
platform_id	string	Unique identifier for this item in the source accounting platform
name	string	The name of the item
description	string	The description of the item
code	string	The reference code of the item
sku	string
price	double
currency_id	enum
type	enum	The type of the item
status	enum	The status of the item
quantity_on_hand	integer	The quantity on hand for the item
is_bill_item	boolean	Whether there are details (bill_item) of this item getting purchased
bill_item	object	Item details of this item getting purchased
is_invoice_item	boolean	Whether there are details (invoice_item) of this item getting sold
invoice_item	object	Item details of this item getting sold
created_at	string
updated_at	string	The date and time the item was last updated