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 only 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 product object.
Archived	Bool	True		True	Indicates whether the product record is archived.
CreatedAt	Datetime	True		False	Timestamp when the product was first created in the system.
UpdatedAt	Datetime	True		False	Timestamp of the most recent update made to the product.
Net price	Decimal	True		False	Placeholder value used to avoid conflicts with similarly named line item fields.
Create Date	Datetime	False		False	Date the product record was created.
Product description	String	False		False	Detailed description of the product's features or purpose.
Unit discount	Decimal	False		False	Flat discount amount applied to the product.
All accessible team IDs	String	True		False	IDs of all teams, including hierarchical teams, associated with ownership of this product.
Business units	String	False		False	Business units that the product is assigned to.
All owner ids	String	True		False	All owner IDs associated with the product through default and custom properties.
All team ids	String	True		False	IDs of teams linked to this product via ownership references.
Avatar FileManager key	String	True		False	File path in the HubSpot FileManager CDN for the product's image. Automatically set by the platform.
Unit cost	Decimal	False		False	Cost incurred by the company for the product sold.
Created by user ID	Decimal	True		False	User ID of the creator of the product. This is set automatically by HubSpot and is read-only.
Object create date_time	Datetime	True		False	Date and time when the product object was created. Automatically populated and not editable.
Discount Percentage	Decimal	False		False	Percentage discount applied to the product price.
Folder Id	Decimal	False		False	Identifier of the folder in which the product is stored.
Image Url	String	False		False	URL to the product image, typically for display in catalogs or listings.
Last Modified Date	Datetime	True		False	Timestamp of the last change made to the product record.
Merged object IDs	String	True		False	List of product IDs that were merged into this one. Managed automatically by HubSpot.
Record ID	Decimal	True		False	Internal HubSpot ID for the product record. This value is system-generated.
Product Type	String	False		False	Category of the product, typically 'Inventory', 'Non_Inventory', or 'Service'.
Read Only Object	Bool	True		False	Indicates if the product record is in a read-only state.
Term	String	False		False	The billing term or contract duration for recurring billing products.
Start Date	Date	False		False	Start date for recurring billing associated with this product.
SKU	String	False		False	Stock Keeping Unit. A unique code used to identify the product.
Unique creation key	String	True		False	Key used to ensure idempotent product creation through integrations.
Updated by user ID	Decimal	True		False	User ID of the person who last updated the product. Automatically maintained by HubSpot.
URL	String	False		False	Web URL pointing to the product's external or internal page.
User IDs of all notification followers	String	True		False	IDs of users who opted in to receive notifications about this product record.
User IDs of all notification unfollowers	String	True		False	IDs of users who opted out of receiving product-related notifications.
User IDs of all owners	String	True		False	All user IDs assigned as owners of this product.
Owner Assigned Date	Datetime	True		False	Timestamp when an owner was most recently assigned to the product. Managed by HubSpot.
Owner	String	False		False	Current owner of the product record.
HubSpot Team	String	True		False	Primary HubSpot team assigned to the product owner.
Name	String	False		False	The name or title of the product.
Unit price	Decimal	False		False	Price per unit of the product.
Quantity	Decimal	True		False	Placeholder used to avoid naming conflict with quantity on line items.
Recurring billing frequency	String	False		False	Frequency of billing for recurring products (for example, monthly or annually). Excludes one-time billing products.
Tax	Decimal	False		False	Amount of tax applied to the product.