ItemGroupsItems
Get items related to itemgroups
Table Specific Information
Select
The provider 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 provider.
- 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. |