Products
Retrieves product records configured in HubSpot, useful for inventory, pricing, and catalog management.
Table Specific Information
Products are a foundational object in HubSpot CRM. Products represent goods or services sold by your company.
SELECT
When selecting products, they can be filtered by ID or by ID and IncludeDeleted. For example:
SELECT * FROM Products WHERE Id = '123456789' SELECT * FROM Products WHERE Id = '123456789' AND IncludeDeleted = 'true'
INSERT
When creating products, you can specify Name, Description and Price. For example:
INSERT INTO Products (Name, Description, Price) VALUES ('NameExample', 'This is a description', 1324)
UPDATE
When updating products, you can change Name, Description and Price by specifying the product Id. For example:
UPDATE Products SET Name = 'UpdatedName', Description = 'Updated desciption', Price = 123 WHERE id = '123'
DELETE
You can delete products singularly by Id, or in batches. For example:
DELETE FROM Products WHERE Id = 123 DELETE FROM Products WHERE Id IN ( '123', '234')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The unique internal ID assigned to the product in HubSpot. | |
| Name | String | False |
The name of the product as it appears in HubSpot. | |
| Sku | String | False |
The Stock Keeping Unit (SKU) code used to identify and track the product. | |
| Price | String | False |
The price of the product, typically represented as a string to allow currency symbols or formatting. | |
| Description | String | False |
A descriptive summary of the product, detailing its key features or specifications. | |
| Version | Integer | True |
The version number of the product record. This value increments each time the product is updated to track changes. | |
| IsDeleted | Boolean | False |
Boolean indicating whether the product has been marked as deleted. Deleted products are excluded from results unless explicitly requested. |
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. For more information, see the WHERE clause section.
| Name | Type | Description |
| IncludeDeleted | String |
Optional input parameter that, when set, includes deleted product records in query results. Useful for auditing or historical data retrieval. |