Orders

Lists all order records in HubSpot for managing order workflows.

Table-Specific Information

In HubSpot, order records store information about ecommerce purchases.

SELECT

When selecting orders, 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 Orders;
SELECT * FROM Orders WHERE [Id] = '385815394826';
SELECT * FROM Orders WHERE [Discount] = 10 OR [Exchange rate] = 1.5;

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 Orders WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Orders WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Orders WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Orders 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 statements use the format:

INSERT INTO Orders ([Currency Code]) VALUES ('INR')
INSERT INTO Orders ([Currency Code], [Exchange rate], [Created Date]) VALUES ('USD', 1.6, '2024-12-14 18:30:00.000'), ('ALL', 160.3, '2024-11-14 18:30:00.000')

UPDATE

UPDATE statements use the format:

UPDATE Orders SET [Exchange rate] = '2.5' WHERE ID = '3917882265'

DELETE

DELETE statements use the format:

DELETE FROM Orders WHERE ID = '3917882265'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	True		True	Unique identifier of the order record.
Archived	Bool	True		False	Indicates whether the order record has been archived.
CreatedAt	Datetime	True		False	Timestamp when the order was initially created.
UpdatedAt	Datetime	True		False	Timestamp of the most recent update to the order.
All teams	String	True		False	IDs of all teams, including those in the hierarchy, associated with ownership properties of this order.
Business units	String	False		False	The business units assigned to this order record.
All owner ids	String	True		False	All owner ID values from default and custom ownership fields on the order.
All team ids	String	True		False	All team ID values from default and custom ownership fields on the order.
Billing City	String	False		True	City listed in the billing address.
Billing Country	String	False		True	Country listed in the billing address.
Billing Email	String	False		True	Email address of the customer as provided in the billing information.
Billing First Name	String	False		True	First name of the customer as provided in the billing information.
Billing Last Name	String	False		True	Last name of the customer as provided in the billing information.
Billing Phone Number	String	False		True	Phone number provided in the billing address.
Billing ZIP/Postal Code	String	False		True	Postal or ZIP code listed in the billing address.
Billing State	String	False		True	State or province listed in the billing address.
Billing Street	String	False		True	Street address from the billing details.
Buyer Accepts Marketing	Bool	False		True	Indicates whether the customer has opted into receiving marketing communications.
Cancellation Reason	String	False		True	Reason provided for the cancellation of the order.
Closed Date	Datetime	True		True	Date when the order was closed. This is set automatically and may be null if the order was not closed.
Created by user ID	Decimal	True		True	ID of the user who created the order. Set automatically by HubSpot and cannot be edited.
Object create date/time	Datetime	True		True	Date and time when the order object was created. This is system-generated and not editable.
Currency Code	String	False		False	Currency code (such as USD or EUR) used for the order total.
Customer Phone	String	False		True	Phone number of the customer who placed the order.
Date entered Stage 1 (Pipeline 1)	Datetime	True		False	Date when the order entered 'Stage 1' of 'Pipeline 1'.
Date exited Stage 1 (Pipeline 1)	Datetime	True		False	Date when the order exited 'Stage 1' of 'Pipeline 1'.
Discount Codes	String	False		True	Any discount codes applied to the order.
Exchange rate	Decimal	False		True	Currency exchange rate used to convert the order amount into company currency.
Canceled Date	Datetime	False		True	Date the order was marked as canceled.
Cart ID	String	False		True	Unique identifier from the external system representing the cart tied to the order.
Checkout ID	String	False		True	Unique identifier from the external system representing the checkout session for this order.
Created Date	Datetime	False		True	Original creation date of the order from the external system.
Modified Date	Datetime	False		True	Last modified date of the order as captured from the source system.
Order ID	String	False		True	External system's unique identifier for the order.
Status	String	False		True	Current status of the order, as defined by the source system (such as open, completed, or canceled).
Order URL	String	False		True	URL linking to the external system's order details page.
Fulfillment Status	String	False		True	Current shipping or delivery status of the order.
Amount in company currency	Decimal	False		True	Total order amount converted to your company's primary currency using the exchange rate.
Landing Site	String	False		True	First page visited on the seller's website before placing the order.
Object last modified date/time	Datetime	True		True	Most recent property update timestamp for this order, including hidden and system fields.
Merged record IDs	String	True		False	IDs of any order records that were merged into this one. Automatically set by HubSpot.
Record ID	Decimal	True		True	HubSpot's internal unique identifier for the order.
Record Creation Source	String	True		True	System value indicating how the record was created, sourced from RequestMeta.
Record Source Detail 1	String	True		True	Primary method or channel through which the order record was created.
Record Source Detail 2	String	True		True	Secondary method or metadata related to how the order record was created.
Record Source Detail 3	String	True		True	Tertiary detail providing additional context for the record's creation source.
Record Creation Source ID	String	True		True	Internal source ID associated with the record creation in the system.
Record Source	String	True		False	Describes the general creation source or channel for the order.
Record Creation Source User ID	Decimal	True		True	User ID of the actor that triggered the order creation, where available.
Discount	Decimal	False		True	Total amount of discount applied to the order.
Name	String	False		True	Human-readable or numeric identifier for the order, typically used in UI display.
Notes	String	False		True	Any additional notes or comments associated with the order.
Payment Processing Method	String	False		True	The payment gateway or processor used for this order.
Payment Status	String	False		True	The current status of payment for the order, such as 'paid' or 'unpaid'.
Pinned engagement ID	Decimal	False		True	ID of the engagement currently pinned to the order, if applicable.
Pipeline	String	False		False	The sales pipeline in which the order is located.
Stage	String	False		False	The specific stage within the order pipeline.
Processed Date	Datetime	False		True	Timestamp when the order data was imported into HubSpot.
Read Only Object	Bool	True		True	Indicates if the order record is read-only.
Referring Site	String	False		True	The external site the customer visited before coming to the seller's site.
Refund Amount	Decimal	False		True	Amount refunded to the customer for this order.
Shared Team IDs	String	True		False	Team IDs with shared access to this order record.
Shared User IDs	String	True		False	User IDs with shared access to this order record.
Shipping City	String	False		True	City listed in the shipping address.
Shipping Country	String	False		True	Country listed in the shipping address.
Shipping Phone Number	String	False		True	Phone number provided in the shipping address.
Shipping ZIP/Postal Code	String	False		True	Postal or ZIP code for the shipping destination.
Shipping State	String	False		True	State or province for the shipping destination.
Shipping Street	String	False		True	Street address for the shipping destination.
Shipping Cost	Decimal	False		True	Shipping charges in the order's transaction currency before discounts.
Shipping Status URL	String	False		True	URL to track the shipping status of the order.
Shipping Tracking Number	String	False		True	Tracking number(s) for shipments associated with the order.
Source ID	Decimal	True		True	HubSpot App ID from which this order was first synced.
Source Store	String	False		True	Identifies the store or system from which the order originated.
Subtotal Price	Decimal	False		True	Total order value before taxes, duties, and discounts.
Tags	String	False		True	Tags or labels associated with this order.
Tax Price	Decimal	False		True	Total amount of tax, including duties, applied to the order.
Time in Stage 1 (Pipeline 1)	Decimal	True		False	Total time in seconds the order remained in 'Stage 1' of 'Pipeline 1'.
Total Price	Decimal	False		True	Final total price of the order including taxes, shipping, and discounts.
Total Weight	String	False		True	Cumulative weight of all items in the order, used for shipping purposes.
Unique creation key	String	True		True	A unique identifier used to ensure the order record is created idempotently.
Updated by user ID	Decimal	True		True	ID of the last user who modified this order record. Automatically tracked by HubSpot.
User IDs of all notification followers	String	True		False	IDs of users who have opted in to receive notifications about this order.
User IDs of all notification unfollowers	String	True		False	IDs of users who have opted out of receiving notifications about this order.
User IDs of all owners	String	True		False	IDs of all users who are listed as owners of this order.
Performed in an import	Bool	True		True	Indicates whether the order was created as part of an import operation.
Owner Assigned Date	Datetime	True		True	Timestamp when the owner was assigned to the order. Automatically managed by HubSpot.
Owner	String	False		True	User assigned as the owner of this order.
HubSpot Team	String	True		False	The primary team of the order owner.