Products
Create, update, delete, and query the products registered for the SuiteCRM project
Table Specific Information
Select
You can query the Products table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.
SELECT * FROM Products WHERE [Product Name] LIKE '%test%'
Insert
Create a Product by specifying any writable column.
INSERT INTO Products ([Product Name],[Product Code]) VALUES ('Prod','CODE1')
Update
You can update any Product column that is writable, by specifying the Id.
UPDATE Products SET [Product Code]='Test', [Part Number]='2part' WHERE Id = 'Test123'
Delete
Delete a Product by specifying the Id.
DELETE FROM Products WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the ACL Action. |
| Assignedto | String | True |
The user name of the user assigned to the record. |
| AssignedUserId | String | False |
The Id of the user assigned to the record. |
| Category | String | False |
Name of the product's category. |
| Contact | String | True |
Product's point of contact name. |
| contact_id | String | False |
Product's point of contact id. |
| Cost | Double | False |
Cost of the product. |
| Cost(DefaultCurrency) | Double | False |
Cost of the product in USD. |
| CreatedById | String | True |
The Id of the user who created the record. |
| CreatedByName | String | True |
The name of the user who created the record. |
| Currency | String | False |
The Id of the currency used for the product. |
| DateCreated | Datetime | True |
The date the record was created. |
| DateModified | Datetime | True |
The date the record was last modified. |
| Deleted | Bool | False |
The record deletion indicator. |
| Description | String | False |
The action description. |
| ModifiedById | String | True |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The name of the user who last modified the record. |
| PartNumber | String | False |
Part number of the product. |
| Price | Double | False |
Price of the product. |
| Price(DefaultCurrency) | Double | False |
Price of the product in USD. |
| ProductCategory | String | True |
Name of the product's category. |
| ProductCategoryID | String | False |
Id of the product's category. |
| ProductCode | String | False |
The code assigned to the product |
| ProductImage | String | False |
Image uploaded for the product. |
| ProductName | String | False |
The action name. |
| Type | String | False |
Type of the product. |
| URL | String | False |
Url where the product can be seen. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |