ItemGroupsItems
Get items related to itemgroups
Table Specific Information
Select
The add-in 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 add-in.
- Id supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM ItemGroupsItems WHERE Id = '3350895000000089001'
Columns
| Name | Type | References | Description |
| GroupId | Long |
ItemGroups.Id | Id of the Item Group |
| Name | String | Name of the Item. | |
| Rate | Double | Sales price of the Item. | |
| PurchaseRate | Double | Purchase price of the Item. | |
| ReorderLevel | Double | Reorder level of the item. | |
| InitialStock | Double | The opening stock of the item. | |
| InitialStockRate | Double | The opening stock value of the item. | |
| VendorId | Long | Unique ID generated by the server for the Vendor. | |
| Sku | String | The Stock Keeeping Unit (SKU) of an item. | |
| Upc | Long | The 12 digit Unique Product Code (UPC) of the item. | |
| Ean | Long | Unique EAN value for the Item. | |
| Isbn | Long | Unique ISBN value for the Item. | |
| PartNumber | String | Part Number of the Item. | |
| AttributeOptionName1 | Long | Name of the attribute option. | |
| ActualAvailableStock | Integer | Actual available stock. | |
| AttributeOptionId1 | Long | Attribute option 1 ID. | |
| AttributeOptionId2 | Long | Attribute option 2 ID. | |
| AttributeOptionId3 | Long | Attribute option 3 ID. | |
| AvailableStock | Integer | Available stock. | |
| ImageDocumentId | Long | ID of the image document. | |
| IsReturnable | Boolean | Whether the item is returnable. | |
| ItemType | String | Type of the item. | |
| ProductType | String | Type of the product. | |
| Status | String | Status of the item. | |
| TrackInventory | Boolean | Whether inventory is tracked. | |
| AttributeOptionData1 | String | Attribute option data 1. | |
| AttributeOptionData2 | String | Attribute option data 2. | |
| AttributeOptionData3 | String | Attribute option data 3. | |
| AttributeOptionName2 | String | Name of the attribute option 2. | |
| AttributeOptionName3 | String | Name of the attribute option 3. | |
| CanBePurchased | Boolean | Whether the item can be purchased. | |
| CanBeSold | Boolean | Whether the item can be sold. | |
| ImageName | String | Name of the image. | |
| ImageType | String | Type of the image. | |
| ItemCode | String | Code of the item. | |
| ItemId | Long | ID of the item. | |
| MaximumOrderQuantity | Double | Maximum order quantity. | |
| MinimumOrderQuantity | Double | Minimum order quantity. | |
| OfflineCreatedDateWithTime | Datetime | Offline created date with time. | |
| ProductSubtype | String | Subtype of the product. | |
| PurposeOfUse | String | Purpose of use. | |
| SalesMargin | Double | Sales margin. | |
| StockOnHand | Integer | Stock available on hand. | |
| Tags | String | Tags associated with the item. | |
| VendorName | String | Name of the vendor. |