Products
Contains product catalog entries (SKU, category, list price, and inventory details) with full record management.
Table-Specific Information
The Products table is only accessible when connected to a ZohoCRM Enterprise Edition account. If using a different edition, this table may not be available.Select
This table supports the COQL and BULK APIs for filtering, meaning that most filters comparing columns to values are submitted server-side.
Insert
The following example demonstrates a basic insert operation:
-- Insert a new product and mark it as active
INSERT INTO Products (ProductName, ProductActive) VALUES ('C-3PO', true)
Required fields: ProductName is required. This is the name of the product and must be provided to create a new record.
Any field which is not read-only (ReadOnly = false in the table schema) can be inserted.
Delete
You must specify the Id column in the WHERE clause to delete a record. The following example demonstrates a delete operation:
-- Delete a product by its unique ID
DELETE FROM Products WHERE Id = '3152079000000153079'
Update
You must specify the Id column in the WHERE clause to update a record. The following example demonstrates an update operation:
-- Update the description for a specific product using its ID
UPDATE Products SET Description = 'Changed from the API.' WHERE Id = '3152079000000487023'
Required fields: Id is required. The update must target a specific record.
Any field which is not read-only (ReadOnly = false in the table schema) can be updated.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
Unique identifier of the product. |
| Owner_Id | String | False |
Unique identifier of the user who owns the product. |
| Owner_FirstName | String | True |
First name of the user who owns the product. |
| Owner_LastName | String | True |
Last name of the user who owns the product. |
| Owner_Email | String | True |
Email address of the user who owns the product. |
| Product_Name | String | False |
Name of the product. |
| Product_Code | String | False |
Code assigned to the product. |
| Vendor_Name_Id | String | False |
Unique identifier of the associated vendor. |
| Product_Active | Bool | False |
Indicates whether the product is active. |
| Manufacturer | String | False |
Name of the manufacturer of the product. |
| Product_Category | String | False |
Category to which the product belongs. |
| Sales_Start_Date | Date | False |
Date on which sales of the product began. |
| Sales_End_Date | Date | False |
Date on which sales of the product ended. |
| Support_Start_Date | Date | False |
Date when support for the product began. |
| Support_Expiry_Date | Date | False |
Date when support for the product ended. |
| Created_By_Id | String | False |
Unique identifier of the user who created the product record. |
| Modified_By_Id | String | False |
Unique identifier of the user who last modified the product record. |
| Modified_By_FirstName | String | True |
First name of the user who last modified the product record. |
| Modified_By_LastName | String | True |
Last name of the user who last modified the product record. |
| Modified_By_Email | String | True |
Email address of the user who last modified the product record. |
| Created_Time | Datetime | False |
Date and time when the product record was created. |
| Modified_Time | Datetime | False |
Date and time when the product record was last modified. |
| Tag | String | False |
Tag used to categorize or filter the product. |
| Unit_Price | Decimal | False |
Unit price of the product. |
| Commission_Rate | Decimal | False |
Commission rate applicable to the product. |
| Tax | String | False |
Tax information for the product. |
| Taxable | Bool | False |
Indicates whether the product is subject to tax. |
| Usage_Unit | String | False |
Unit in which the product is measured or sold. |
| Qty_Ordered | Double | False |
Total quantity of the product that has been ordered. |
| Qty_in_Stock | Double | False |
Current quantity of the product available in stock. |
| Reorder_Level | Double | False |
Stock level at which the product is reordered. |
| Handler_Id | String | False |
Unique identifier of the user handling the product. |
| Qty_in_Demand | Double | False |
Quantity of the product that is currently in demand. |
| Description | String | False |
Description of the product. |
| Record_Image | String | False |
Path or URL to the image of the product. |
| Id_CustomModule | Long | True |
Internal record identifier for the product. |
| Locked__s | Bool | True |
Indicates whether the product record is locked from modifications. |
| Last_Activity_Time | Datetime | False |
Timestamp of the most recent activity on the product record. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String |
The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field. |
| Trigger | String |
To trigger the rule while inserting record into CRM account. |