Items

Read, Insert, Update and Delete Items.

Table Specific Information

Select

The connector 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 connector.

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.