ItemGroups
Read, Insert, Update adn Delete Item groups.
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 ItemGroups WHERE Id = '3350895000000089001'
Insert
Insert can be executed by specifying the GroupName and Unit 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 ItemGroups (GroupName, Unit, Brand) VALUES ('Bags', 'qty', 'Website')
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 ItemGroups SET GroupName = 'Ra', unit = 'qty' WHERE GroupId = '3285934000000163005'
Delete
Delete can be executed by specifying the Id in the WHERE Clause
For example:
DELETE FROM ItemGroups WHERE Id = '3350895000000089001'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Id of the Item Group | |
AttributeId1 | Long | True |
Id of the attribute present in the Item Group | |
AttributeName1 | String | False |
Name of the attribute present in the Item Group | |
Brand | String | False |
Brand of the Item Group | |
CreatedTime | Datetime | True |
Time at which item group was created. | |
Description | String | False |
Description of the Item Group | |
GroupName | String | False |
Name of the Item Group | |
ImageId | Long | True |
Id of the image. | |
ImageName | String | True |
Name of the image. | |
ImageType | String | True |
Type of the image. | |
IsTaxable | Boolean | True |
Flag to determine if item group is taxable. | |
LastModifiedTime | Datetime | True |
Last modified time of item group | |
Manufacturer | String | False |
Manufacturer of item group | |
ProductType | String | True |
Product type of item group. | |
Source | String | True |
Source of item group. | |
Status | String | True |
Status of item group. | |
TaxExemptionId | Long | True |
Tax exemption id of item group. | |
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 |
Tax name of item group. | |
TaxPercentage | Integer | True |
Tax percentage of item group. | |
TaxType | String | True |
Tax type of item group. | |
Unit | String | False |
Unit of item group. | |
Items | String | False |
Aggreagate items of item group. | |
Attributes | String | False |
Aggreagate attributes of item group. |