Excel Add-In for HubSpot

Build 25.0.9434

Orders

Lists all order records in HubSpot for managing order workflows.

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long False True

Unique identifier of the order record.

Archived Bool True True

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 False

City listed in the billing address.

Billing Country String False False

Country listed in the billing address.

Billing Email String False False

Email address of the customer as provided in the billing information.

Billing First Name String False False

First name of the customer as provided in the billing information.

Billing Last Name String False False

Last name of the customer as provided in the billing information.

Billing Phone Number String False False

Phone number provided in the billing address.

Billing ZIP/Postal Code String False False

Postal or ZIP code listed in the billing address.

Billing State String False False

State or province listed in the billing address.

Billing Street String False False

Street address from the billing details.

Buyer Accepts Marketing Bool False False

Indicates whether the customer has opted into receiving marketing communications.

Cancellation Reason String False False

Reason provided for the cancellation of the order.

Closed Date Datetime True False

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 False

ID of the user who created the order. Set automatically by HubSpot and cannot be edited.

Object create date/time Datetime True False

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 False

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 False

Any discount codes applied to the order.

Exchange rate Decimal False False

Currency exchange rate used to convert the order amount into company currency.

Canceled Date Datetime False False

Date the order was marked as canceled.

Cart ID String False False

Unique identifier from the external system representing the cart tied to the order.

Checkout ID String False False

Unique identifier from the external system representing the checkout session for this order.

Created Date Datetime False False

Original creation date of the order from the external system.

Modified Date Datetime False False

Last modified date of the order as captured from the source system.

Order ID String False False

External system's unique identifier for the order.

Status String False False

Current status of the order, as defined by the source system (such as open, completed, or canceled).

Order URL String False False

URL linking to the external system's order details page.

Fulfillment Status String False False

Current shipping or delivery status of the order.

Amount in company currency Decimal False False

Total order amount converted to your company's primary currency using the exchange rate.

Landing Site String False False

First page visited on the seller's website before placing the order.

Object last modified date/time Datetime True False

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 False

HubSpot's internal unique identifier for the order.

Record Creation Source String True False

System value indicating how the record was created, sourced from RequestMeta.

Record Source Detail 1 String True False

Primary method or channel through which the order record was created.

Record Source Detail 2 String True False

Secondary method or metadata related to how the order record was created.

Record Source Detail 3 String True False

Tertiary detail providing additional context for the record's creation source.

Record Creation Source ID String True False

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 False

User ID of the actor that triggered the order creation, where available.

Discount Decimal False False

Total amount of discount applied to the order.

Name String False False

Human-readable or numeric identifier for the order, typically used in UI display.

Notes String False False

Any additional notes or comments associated with the order.

Payment Processing Method String False False

The payment gateway or processor used for this order.

Payment Status String False False

The current status of payment for the order, such as 'paid' or 'unpaid'.

Pinned engagement ID Decimal False False

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 False

Timestamp when the order data was imported into HubSpot.

Read Only Object Bool True False

Indicates if the order record is read-only.

Referring Site String False False

The external site the customer visited before coming to the seller's site.

Refund Amount Decimal False False

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 False

City listed in the shipping address.

Shipping Country String False False

Country listed in the shipping address.

Shipping Phone Number String False False

Phone number provided in the shipping address.

Shipping ZIP/Postal Code String False False

Postal or ZIP code for the shipping destination.

Shipping State String False False

State or province for the shipping destination.

Shipping Street String False False

Street address for the shipping destination.

Shipping Cost Decimal False False

Shipping charges in the order's transaction currency before discounts.

Shipping Status URL String False False

URL to track the shipping status of the order.

Shipping Tracking Number String False False

Tracking number(s) for shipments associated with the order.

Source ID Decimal True False

HubSpot App ID from which this order was first synced.

Source Store String False False

Identifies the store or system from which the order originated.

Subtotal Price Decimal False False

Total order value before taxes, duties, and discounts.

Tags String False False

Tags or labels associated with this order.

Tax Price Decimal False False

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 False

Final total price of the order including taxes, shipping, and discounts.

Total Weight String False False

Cumulative weight of all items in the order, used for shipping purposes.

Unique creation key String True False

A unique identifier used to ensure the order record is created idempotently.

Updated by user ID Decimal True False

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 False

Indicates whether the order was created as part of an import operation.

Owner Assigned Date Datetime True False

Timestamp when the owner was assigned to the order. Automatically managed by HubSpot.

Owner String False False

User assigned as the owner of this order.

HubSpot Team String True False

The primary team of the order owner.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434