Products

Lists all product records configured in HubSpot, supporting both OAuth and private-app token authentications.

Table Specific Information

In HubSpot, products represent the goods or services you sell. Building a product library allows you to quickly add products to deals, generate quotes, and report on product performance.

SELECT

When selecting products, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are: =, !=, <, <=, >, >=, IN

Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 AND operators inside of them. For example:

SELECT * FROM Products
SELECT * FROM Products WHERE [Created by user ID] = 4465089 AND [Product price] > 250
SELECT * FROM Products WHERE [Created by user ID] = 4465089 OR [Created by user ID] = 4465090

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Products WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Products WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM Products WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Products WHERE ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value})

INSERT

INSERT INTO Products ([Product description]) VALUES ('description')

UPDATE

UPDATE Products SET [Product description] = 'new description' WHERE ID = '75229453'

DELETE

DELETE FROM Products WHERE ID = '75229453'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	True		True	Unique identifier assigned to the product record in HubSpot.
Archived	Bool	True		False	Indicates whether the product is archived and no longer active.
CreatedAt	Datetime	True		False	Timestamp when the product was first created.
UpdatedAt	Datetime	True		False	Timestamp when the product was last updated.
Net price	Decimal	True		True	Internal placeholder to avoid conflicts with line item property of the same name.
Create Date	Datetime	False		True	Date when the product record was created.
Product description	String	False		True	Full descriptive text providing details about the product.
Unit discount	Decimal	False		True	Amount of discount applied per unit of the product.
All accessible team IDs	String	True		True	List of team IDs, including inherited teams, associated with ownership of the product.
Business units	String	False		True	Business units to which this product record is assigned.
All owner ids	String	True		True	User IDs assigned as owners of the product, including default and custom ownership fields.
All team ids	String	True		True	Team IDs associated with all ownership properties for this product.
Avatar FileManager key	String	True		True	Path to the product's image in the HubSpot FileManager CDN. Set automatically by HubSpot.
Unit cost	Decimal	False		True	Cost to the HubSpot customer for each unit of the product.
Created by user ID	Decimal	True		True	User ID of the individual who created the product record. Set automatically by HubSpot.
Object create date_time	Datetime	True		True	Datetime when the product object was created. Managed automatically by HubSpot.
Discount Percentage	Decimal	False		True	Percentage discount applied to the product price.
Folder Id	Decimal	False		True	ID of the folder where the product is organized within the HubSpot system.
Image Url	String	False		True	URL pointing to images associated with the product.
Last Modified Date	Datetime	True		True	Datetime of the most recent update to any property of the product.
Merged object IDs	String	True		True	List of product record IDs that have been merged into this record. Managed automatically by HubSpot.
Record ID	Decimal	True		True	HubSpot-generated unique ID for the product record.
Product Type	String	False		True	Categorization of the product such as Inventory, Non-Inventory, or Service.
Read Only Object	Bool	True		True	Indicates whether the product record is locked and cannot be edited.
Term	String	False		True	Duration of recurring billing terms for the product if applicable.
Start Date	Date	False		True	Start date for recurring billing for this product.
SKU	String	False		True	Unique stock keeping unit (SKU) identifier for the product.
Unique creation key	String	True		True	Unique property used to ensure idempotent creation of the product record.
Updated by user ID	Decimal	True		True	User ID of the last person who updated this product record.
URL	String	False		True	URL linking to the product's detailed page or resource.
User IDs of all notification followers	String	True		True	User IDs of all users who opted in to follow updates for this product.
User IDs of all notification unfollowers	String	True		True	User IDs of owners who opted out of receiving notifications for this product.
User IDs of all owners	String	True		True	List of user IDs assigned as owners of this product.
Owner Assigned Date	Datetime	True		True	Timestamp of the most recent owner assignment for the product. Set automatically by HubSpot.
Owner	String	False		True	Current owner of the product record.
HubSpot Team	String	True		True	Primary HubSpot team associated with the owner of the product.
Name	String	False		True	Name of the product.
Unit price	Decimal	False		True	Price per unit of the product.
Quantity	Decimal	True		True	Internal placeholder to avoid conflicts with line item property of the same name.
Recurring billing frequency	String	False		True	Frequency with which the product is billed if it uses recurring billing.
Tax	Decimal	False		True	Tax amount applied to the product price.