Items
Read, Insert, Update and Delete Items.
Table Specific Information
Select
The 本製品 will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.
- Id supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM Items WHERE Id = '3350895000000089001'
Insert
Insert can be executed by specifying the Name column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO Items (Name) VALUES ('testitem11')
Update
Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Items SET Name = 'updated name' WHERE Id = '3350895000000090009'
Delete
Delete can be executed by specifying the Id in the WHERE Clause
For example:
DELETE FROM Items WHERE Id = '3350895000000089001'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Unique ID generated by the server for the group to which the item belongs, if any. This is used as an identifier. | |
ActualAvailableStock | Integer | True |
Stock based on Shipments and Receives minus ordered stock. | |
AccountName | String | True |
Name of the Sales Account. | |
AttributeId1 | Long | False |
Unique ID used by the server. This is used as an identifier. | |
AttributeName1 | String | False |
Name of the attribute present in the Item Group. | |
AttributeOptionId1 | Long | True |
Unique ID generated by the server for the attribute options. This is used as an identifier. | |
AttributeOptionName1 | String | True |
Name of the attribute option. | |
AvailableStock | Integer | True |
Stock based on Shipments and Receives. | |
CreatedTime | Datetime | True |
Time at which item was created. | |
Description | String | False |
Description of the Item. | |
Documents | String | False |
Documents of the Item. | |
Ean | Long | True |
Unique EAN value for the Item. | |
GroupId | Long | False |
Unique ID generated by the server for the group to which the item belongs, if any. This is used as an identifier. | |
GroupName | String | False |
Name of product group. | |
HsnOrSac | Integer | True |
HSN Code of the item | |
ImageName | String | True |
Image name of the Item. | |
ImageType | String | True |
Type of the image i.e., its file format. | |
InventoryAccountId | Long | False |
Unique ID generated by the server for the Inventory account. | |
IsComboProduct | Boolean | True |
Flag to determine is the item part of combo. | |
IsLinkedWithZohocrm | Boolean | True |
Flag to determine if product is linked with ZohoCRM | |
Name | String | False |
Name of the Item. | |
IsTaxable | Boolean | False |
Boolean to track the taxability of the item. | |
Isbn | Long | True |
Unique ISBN value for the Item. | |
ItemType | String | False |
Item type can be inventory, sales, purchases or sales_and_purchases. If item is associated with a group, then type should be inventory. | |
LastModifiedTime | Datetime | True |
Time at which item was last modified. | |
PartNumber | String | True |
Part Number of the Item. | |
ProductType | String | False |
Type of the product. It can be goods or service | |
PurchaseDescription | String | True |
The description for the purchase information. This will be displayed to the vendor in your purchase order. | |
PurchaseAccountId | Long | False |
Unique ID generated by the server for the Purchase account. | |
PurchaseAccountName | String | False |
Name of the Purchase Account. | |
PurchaseRate | Integer | False |
Purchase price of the Item. | |
Rate | Integer | False |
Sales price of the Item. | |
ReorderLevel | Integer | False |
Reorder level of the item. | |
Sku | String | True |
The Stock Keeeping Unit (SKU) of an item. This is unique for every item in the Inventory. | |
Source | String | True |
The source of the Item Group. | |
Status | String | True |
Status of the Item Group. | |
StockOnHand | Integer | True |
Stock available for a particular item. | |
TaxId | Long | False |
Unique ID generated by the server for the tax associated with the item. This is used a unique identifier. | |
TaxName | String | True |
Name of the tax applied on the Item Group. | |
TaxPercentage | Integer | True |
Percentage of the Tax. | |
TaxType | String | True |
Type of the Tax. | |
ItemTaxPreferences | String | False |
Item Tax Preference. | |
Upc | Long | True |
The 12 digit Unique Product Code (UPC) of the item. | |
Unit | String | False |
Unit of measurement for the item. |