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, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operator is =.

SELECT * FROM Products WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM Products  WHERE Archived = TRUE;

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	False		True	Unique identifier of the object.
Archived	Bool	True		True	Whether the object is archived or not.
CreatedAt	Datetime	True		False	When the object was created.
UpdatedAt	Datetime	True		False	When the object was last updated.
Net price	Decimal	True		False	Internal placeholder _to prevent conflicts with line item property of same name_.
Create Date	Datetime	False		False	The date the product was created.
Product description	String	False		False	Full description of product.
Unit discount	Decimal	False		False	The discount amount applied.
All accessible team IDs	String	True		False	The team IDs_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom.
Business units	String	False		False	The business units this record is assigned to.
All owner ids	String	True		False	The value of all owner referencing properties for this object_ both default and custom.
All team ids	String	True		False	The team ids corresponding to all owner referencing properties for this object_ both default and custom.
Avatar FileManager key	String	True		False	The path in the FileManager CDN for this product's image. Automatically set by HubSpot.
Unit cost	Decimal	False		False	The amount that sold goods cost the HubSpot customer.
Created by user ID	Decimal	True		False	The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time	Datetime	True		False	The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Discount Percentage	Decimal	False		False	The discount percentage applied.
Folder Id	Decimal	False		False	The ID of the folder that has this product.
Image Url	String	False		False	Product images.
Last Modified Date	Datetime	True		False	The date any property on this product was modified.
Merged object IDs	String	True		False	The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Record ID	Decimal	True		False	The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Product Type	String	False		False	The type of product. By default_ categorize your product as either Inventory_ Non_Inventory or Service.
Read Only Object	Bool	True		False	Is the object read only.
Term	String	False		False	Product recurring billing duration.
Start Date	Date	False		False	Recurring billing start date for a line item.
SKU	String	False		False	Unique product identifier.
Unique creation key	String	True		False	Unique property used for idempotent creates.
Updated by user ID	Decimal	True		False	The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
URL	String	False		False	Product url.
User IDs of all notification followers	String	True		False	The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers	String	True		False	The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners	String	True		False	The user IDs of all owners of this object.
Owner Assigned Date	Datetime	True		False	The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Owner	String	False		False	The owner of the object.
HubSpot Team	String	True		False	The primary team of the owner.
Name	String	False		False	Product name.
Unit price	Decimal	False		False	Cost of product.
Quantity	Decimal	True		False	Internal placeholder _to prevent conflicts with line item property of same name_.
Recurring billing frequency	String	False		False	How often a product with recurring billing is billed. It informs the pricing calculation for deals and quotes. Products with one_time billing aren_t included.
Tax	Decimal	False		False	The tax amount applied.