Orders
x_fct_trans_orders
Name | Description |
|---|---|
Affiliate Email | Email address of the affiliate. |
Affiliate Id | Unique key generated by Chord to identify a unique affiliate. |
Affiliate Name | Full name of the user. |
Affiliate Seen Emails | List of email addresses seen. |
Affiliate User Id | Unique key generated by Chord to identify a unique user. |
Billing Address Address1 | The street address of the customer. |
Billing Address Address2 | The optional second address of the customer. |
Billing Address Alternative Phone | The customer's alternative phone number. |
Billing Address City | The city where the address is. |
Billing Address Company | A company name. |
Billing Address Country Abbr | |
Billing Address Country Name | Full name of the country. |
Billing Address Firstname | First name of the customer. |
Billing Address Id | Unique key generated by Chord to identify a unique address. |
Billing Address Lastname | Last name of the customer. |
Billing Address Oms Address Id | Unique key generated by Solidus that identifies an address. |
Billing Address Phone | The customer's phone number. |
Billing Address State Abbr | |
Billing Address State Name | Full name of the state. |
Billing Address Zipcode | The postal code. |
Order Adjustment Types | List of distinct adjustment reasons for adjustments made to the order. |
Order Admin Url | The Admin URL of pointing to the order. |
Order Applied Discount Codes | List of promotion codes applied to the order. |
Order Applied Discount Codes Count | Count of promotion codes applied to the order. |
Order Applied Discount Ids | List of promotion ids applied to the order. |
Order Applied Discount Names | List of promotion names applied to the order. |
Order Applied Discount Names Count | Count of promotion names applied to the order. |
Order Cart Url | Url of the cart which contains the order. |
Order Channel | The channel from which the order is created. |
Order Completed Order Rank By Subscription | Allows to rank completed orders by completion date for a subscription. |
Order Completed Order Rank By User | Allows to rank completed orders by completion date for a user. |
Order Contains Refund | Whether or not the order contains refund adjustments or refunds that are processed outside of the Chord OMS adjustment systems (for example via RMAs or cancellations). |
Order Contains Replacement | Whether or not the order contains replacement adjustments or shipped replacement items (following an RMA authorization). |
Order Contains Return | Whether or not the order contains returns (authorized RMAs). |
Order Contains Rma Refund | Whether or not the order contains RMA refunds (refunds issued after an RMA was requested and authorized). |
Order Contains Rma Store Credits | This column is not documented. |
Order Currency | The currency for this order. |
Order Customer Lifetime Month | Number of months between the current order's completion date and the user's first order completion date. First orders have a value of 1. |
Order Customer Lifetime Week | Number of weeks between the current order's completion date and the user's first order completion date. First orders always have a value of 1. |
Order Email | The email address of the customer that made the order. |
Order Financial State | The current payment state of the order. |
Order Fulfillment Ids | Array of unique keys generated by Chord to identify the unique shipments for an order. |
Order Fulfillment Numbers | The unique identifier for this shipment. |
Order Fulfillment State | The current shipment state of the order. |
Order Has Discount | Whether or not the order has promotions applied to it. |
Order Has Order Tags | Whether or not that order has tags. |
Order Hours From Order To First Fulfillment | Number of hours between order completion and first order shipment; how long it takes a company to get the initial product out to a customer. |
Order Hours From Order To Last Fulfillment | Number of hours between order completion and last order shipment. |
Order Id | Unique key generated by Chord to identify a unique order. |
Order Is Canceled | Whether or not the order is canceled. The order is considered canceled when the canceled_at date is not null. |
Order Is Completed | Whether or not that order is completed. The order is considered completed when the completed_at date is not null. This means that the order does not necessarily have a state = complete, since states can change after the order completion (for example in the case of a refund). |
Order Is First Completed Order | Whether or not that order was the first completed order for a user. |
Order Is First Order | Whether or not that order was the first order for a user. |
Order Is First Subscription Completed Order | Whether or not that order was the first completed order for a subscription. |
Order Is First Subscription Order | Whether or not that order was the first order for a subscription. |
Order Is Fulfilled | Whether or not that order has shipped. |
Order Is Part Of Subscription | Whether or not that order is part of a subscription. |
Order Is Pre Paid Purchase | Whether the order the orderincludes the purchase of a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card. |
Order Is Pre Paid Redemption | Whether the order included the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card. |
Order Is Referred By Affiliate | Whether or not the user is referred by an affiliate. |
Order Is Referred By Referrer | Whether or not the user is referred by a referrer. |
Order Is Replacement | True when the order is a replacement order. |
Order Is Suspicious Referral Conversion | Wether this represents a suspicous referral conversions or not. |
Order Item Id | Unique key generated by Chord to identify a unique order. |
Order Item Line Items Quantity | Sum of line items quantities per order. |
Order Item Product Basket | List of product names per in the order. |
Order Item Product Basket Count | Number of products in the order. |
Order Product Basket | The titles of products for a given order array converted to a string. |
Order Item Total Line Item Unit Quantity | Sum of line item units in the order. |
Order Item Total Line Items Quantity | Sum of line items quantities per order. |
Order Item Unique Product Basket | List of unique product names per in the order. |
Order Item Unique Product Basket Count | Number of unique products in the order. |
Order Unique Product Basket | The list of unique products for a given order array converted to a string. |
Order Item Unique Unit Basket | List of unique units in the order. |
Order Item Unique Unit Basket Count | Count of unique units in the order. |
Order Unit Basket | The list of units for a given order array converted to a string. |
Order Item Unique Variant Basket | List of unique variant names per in the order. |
Order Item Unique Variant Basket Count | Number of unique variants in the order. |
Order Unique Variant Basket | The list of unique variants for a given order array converted to a string. |
Order Item Unit Basket | List of all units in the order. |
Order Item Unit Basket Count | Count of all units in the order. |
Order Unique Unit Basket | The list of unique units for a given order array converted to a string. |
Order Item Variant Basket | List of variant names per in the order. |
Order Item Variant Basket Count | Number of variants in the order. |
Order Variant Basket | The titles of variants for a given order array converted to a string. |
Order Number | Human-readable unique key generated by Solidus that identifies an order. It begins with a set of Tenant-Store defined letters and ends in a nine-digit number (for example, CHORD-123456789). This number is shown to the users in various places. These combinations are unique for a given Store. |
Order Oms Order Id | Unique key generated by Solidus that identifies an order. |
Order Rank By User | Allows to rank completed orders by completion date for a user. |
Order Tags | List of tags associated to the order. |
Order Tags Count | Number of tags associated to the order. |
Order Referral Conversion Suspicious Reasons | A list of reasons explaining why the referral conversion is suspicious. |
Order Referrer User Email | The email address of the customer identified with the referral. |
Order Special Instructions | Any special shipping instructions that have been specified by the customer during checkout. |
Order State | The current state of the order. |
Order Store Id | Unique key generated by our models that uniquifies a store. |
Order Store Name | The name of the store. |
Order Store Oms Admin Url | The Admin URL of that OMS. |
Order Store Oms Id | Unique key generated by Chord that uniquifies an OMS. |
Order Store Oms Store Id | Unique key generated by our models that uniquifies a store. |
Order Store Oms Type | The type of the OMS. |
Order Store Id | Unique key generated by our models that uniquifies a store. |
Order Store Tenant Id | Unique key generated by Chord that uniquifies a tenant. |
Order Store Url | The Storefront URL of of the store. |
Order Subscription Customer Lifetime Month | Number of months between the current order's completion date and the user's first subscription order completion date. First orders have a value of 1. |
Order Subscription Customer Lifetime Week | Number of weeks between the current order's completion date and the user's first subscription order completion date. First orders always have a value of 1. |
Order User Referral Code | Unique key generated by Solidus that represents the user's referral code. |
Order Website Locale | Locale of website. This will either be collected from the url or from the drop-down link on the store. |
Referral Conversion Rank By Referrer | Allows to rank a referral conversion by referrer. |
Referral Id | Unique key generated by Chord to identify a unique referral identifier. |
Referral Is Converted | Wether this represents a converted referral or not. |
Referral Is First Conversion | Whether or not the referral was the referrer's first converted referral. |
Referral Is First Non Suspicious Conversion | Whether or not the referral was the referrer's first non suspicious converted referral. |
Referral Is Suspicious | Wether this represents a suspicous referral conversions or not. |
Referral Non Suspicious Conversion Rank By Referrer | Allows ranking of non-suspicious referral conversion by the referrer. |
Referral Oms Referral Conversion Id | Unique key generated by Solidus that identifies a referral conversion. |
Referral Suspicious Reasons | A list of reasons explaining why the referral conversion is suspicious. |
Referrer Currency | The currency for this referral identifier. |
Referrer Email | The email address of the customer identified with the referral. |
Referrer Id | Unique key generated by Chord to identify a unique referral identifier. |
Referrer Oms Referral Identifier Id | Unique key generated by Solidus that identifies a referral identifier. |
Referrer User Referral Code | Unique key generated by Solidus that represents the user's referral code. |
Shipping Address Address1 | The street address of the customer. |
Shipping Address Address2 | The optional second address of the customer. |
Shipping Address Alternative Phone | The customer's alternative phone number. |
Shipping Address City | The city where the address is. |
Shipping Address Company | A company name. |
Shipping Address Country Abbr | |
Shipping Address Country Name | Full name of the country. |
Shipping Address Firstname | First name of the customer. |
Shipping Address Id | Unique key generated by Chord to identify a unique address. |
Shipping Address Lastname | Last name of the customer. |
Shipping Address Oms Address Id | Unique key generated by Solidus that identifies an address. |
Shipping Address Phone | The customer's phone number. |
Shipping Address State Abbr | |
Shipping Address State Name | Full name of the state. |
Shipping Address Zipcode | The postal code. |
Subscription Completed Oms Order Ids | List of completed OMS order ids by a subscription. |
Subscription Completed Order Count | Total amount of orders completed by a subscription. |
Subscription Completed Order Ids | List of completed order ids by a subscription. |
Subscription First Order Unique Product Basket | Array of unique product names ordered in the first order per subscription. |
Subscription First Order Unique Variant Basket | Array of unique SKUs ordered in the first order per subscription. |
Subscription Has Subscription Tags | Whether or not the subscription has tags. |
Subscription Id | Unique key generated by Solidus that identifies a subscription. |
Subscription Interval In Days | The number of days in the subscription interval. |
Subscription Is Auto Redeemed | Whether the pre-paid subscription will be auto-redeemed or if an action is required by the recepient. |
Subscription Is Gift | Whether or not the pre-paid subscription is a gift. |
Subscription Is Recurring | Whether the pre-paid subscription is recurring. |
Subscription Last Order Unique Product Basket | Array of unique product names ordered in the latest order per subscription. |
Subscription Last Order Unique Variant Basket | Array of unique SKUs ordered in the latest order per subscription. |
Subscription Oms Pre Paid Subscription Id | ID generated by ChordOMS to identify a unique pre-paid subscription. |
Subscription Oms Subscription Id | Unique key generated by Solidus that identifies a subscription. |
Subscription Pre Paid Subscription Id | Chord generated unique id for the pre-pay subscription. |
Subscription State | The current state of the subscription, enhanced with values for `paused` if the subscription is active and paused. |
Subscription Tags | The list of tags associated with a subscription. |
Subscription Tags Count | The number of tags associated with a subscription. |
Subscription Unique Product Basket | Array of unique product names ever ordered per subscription. |
Subscription Unique Variant Basket | Array of unique SKUs ever ordered per subscription. |
User Completed Oms Order Ids | List of completed OMS order ids by a user. |
User Completed Order Ids | List of completed order ids by a user. |
User Credit Category Basket | Array of credit categories (Gift Card, Reimbursement, Referral Credits, Prepaid Subscription, GMA) issued per user. |
User Email | Email address of the user. |
User First Completed Oms Order Id | OMS order id of the first order completed by a user. |
User First Completed Order Id | Unique order id of the first order completed by a user. |
User First Order Unique Ordered Products | Unique products ordered by the user in their first completed order. |
User First Order Unique Ordered Skus | Unique SKUs ordered by the user in their first completed order. |
User Has Ordered A La Carte | Whether or not the user has had at least one order that is not part of a subscription. |
User Has Promo Applied In First Order | Whether or not the user has a promo applied to their first completed order. |
User Has Subscription In First Order | Whether or not the user's first order is linked to a subscription. |
User Id | Unique key generated by Chord to identify a unique user. |
User Is Active Subscriber | Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused. |
User Is Customer | Whether or not the user is a customer. |
User Is New Customer | Whether or not the user is a new customer. |
User Is Not Customer | Whether or not the user is not a customer. |
User Is Returning Customer | Whether or not the user is a returning customer. |
User Is Subscriber | Whether or not the user has completed at least one subscription order. |
User Login | The login email address of the user. |
User Name | Full name of the user. |
User Number Of Completed A La Carte Orders | Total amount of orders completed by a user that are a la carte. |
User Number Of Completed Subscription Orders | Total amount of orders completed by a user that was part of a subscription. |
User Number Of Orders With Promos | The count of completed orders with a promo applied. |
User Number Of Subscriptions | Total amount of subscriptions linked to a user. |
User Oms User Id | Unique key generated by Solidus that identifies a user. |
User Phone | Phone number of the user. |
User Total Completed Order Count | Total amount of orders completed by a user. |
User Unique Ordered Products | Unique products ordered by the user across all orders. |
User Unique Ordered Skus | Unique SKUs ordered by the user across all orders. |
Billing Address Created At (Universal) | Timestamp at which the address row was created - Universal Time Zone. |
Billing Address Updated At (Universal) | Timestamp at which the address row was last updated - Universal Time Zone. |
Order Approved At (Universal) | Reflects when the entity was approved in Solidus - Universal Time Zone. |
Order Canceled At (Universal) | Reflects when the order was cancelled - Universal Time Zone. |
Order Completed At (Central) | Reflects when the entity was moved to the completed state - Cental Time Zone. |
Order Completed At (Eastern) | Reflects when the entity was moved to the completed state - Eastern Time Zone. |
Order Completed At (Mountain) | Reflects when the entity was moved to the completed state - Mountain Time Zone. |
Order Completed At (Pacific) | Reflects when the entity was moved to the completed state - Pacific Time Zone. |
Order Completed At (Universal) | Reflects when the entity was moved to the completed state - Universal Time Zone. |
Order Created At (Central) | Reflects when the entity was first created in Solidus - Cental Time Zone. |
Order Created At (Eastern) | Reflects when the entity was first created in Solidus - Eastern Time Zone. |
Order Created At (Mountain) | Reflects when the entity was first created in Solidus - Mountain Time Zone. |
Order Created At (Pacific) | Reflects when the entity was first created in Solidus - Pacific Time Zone. |
Order Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Order First Fulfillment Fulfilled At (Universal) | Timestamp at which the first shipment for that order was shipped - Universal Time Zone. |
Order Last Adjustment Refund At (Universal) | Timestamp of the last return adjustment for an order - Universal Time Zone. |
Order Last Adjustment Replacement At (Universal) | Timestamp of the last replacement adjustment for an order - Universal Time Zone. |
Order Last Fulfillment Fulfilled At (Universal) | Timestamp at which the last shipment for that order was shipped - Universal Time Zone. |
Order Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
Referral Converted At (Universal) | Reflects when the referral entity was first converted in Solidus - Universal Time Zone. |
Referral Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Referral Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
Referrer Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Referrer Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
Shipping Address Created At (Universal) | Timestamp at which the address row was created - Universal Time Zone. |
Shipping Address Updated At (Universal) | Timestamp at which the address row was last updated - Universal Time Zone. |
Subscription Actionable Date (Universal) | The date of the next subscription installment. This date is updated after each successful installment. Subscriptions in an inactive state will be null - Universal Time Zone. |
Subscription Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Subscription First Order Completed At (Universal) | The timestamp of the subscription's first completed order - Universal Time Zone. |
Subscription Last Order Completed At (Universal) | The timestamp of the subscription's last completed order - Universal Time Zone. |
Subscription Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
User Created At (Universal) | Timestamp at which the users row was created - Universal Time Zone. |
User Date Of Birth (Universal) | Date of birth of the user - Universal Time Zone. |
User Deleted At (Universal) | Timestamp at which the user's account was deleted - Universal Time Zone. |
User First Order Completed At (Universal) | The timestamp of the user's first completed order - Universal Time Zone. |
User First Subscription Order Completed At (Universal) | The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone. |
User Last Order Completed At (Universal) | The timestamp of the user's last completed order - Universal Time Zone. |
User Last Sign In At (Universal) | The last sign in timestamp for the user - Universal Time Zone. |
User Updated At (Universal) | Timestamp at which the users row was last updated - Universal Time Zone. |
Average Additional Tax Total | Total additional taxes for an order. |
Average Adjustment Fulfillment Tax Total | Total adjustment shipment taxes for an order. |
Average Adjustment Fulfillment Total | Total shipment adjustments applied to an order. |
Average Adjustment Other Charges Total | Total of included additional adjustment charges paid for an order. |
Average Adjustment Other Credits Total | Total of credits issued for an order. |
Average Adjustment Refund Total | Total of return dollars for an order. |
Average Adjustment Replacement Total | Total of replacement dollars for an order. |
Average Adjustment Rma Refund Total | Total of refund dollards associated to an order that was returned via the RMA functionality of the Chord OMS. |
Average Adjustment Tax Total | Total adjustment taxes an order. |
Average Adjustment Total | Total of adjustment applied for an order as on the order. |
Average Applied Gift Card Total | Total of gift card dollars that were used as a payment method in the order |
Average Commission Total | Commission for an order. |
Average Fulfillment Total | Total shipment for an order. |
Average Gross Revenue | Gross amount of revenue generated by the order including items and shipments totals. Gross revenue = total - included_tax_total + shipment_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Average Included Tax Total | Total included taxes for an order. |
Average Item Total | Total price for the order before adjustments. |
Average Net Revenue | Net revenue generated by the order's items after promotions. Net revenue = total - included_tax_total + shipment_total + adjustment_total - additional_tax_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Average Pre Paid Purchase Total | The amount of the order that was purchased as a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card. |
Average Pre Paid Redemption Total | The amount of the order that was the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card. |
Average Promo Total | Promotions applied to an order. |
Average Purchased Gift Card Total | Total of gift card dollars that were purchased in the order. |
Average Reimbursement Credit Total | The amount of store credits owed back in an order |
Average Tax Total | Total taxes for an order. |
Average Total Price | Total to be paid by the customer for an order. |
Average Transaction Total | Total paid by the customer for a completed order. |
Additional Tax Total | Total additional taxes for an order. |
Adjustment Fulfillment Tax Total | Total adjustment shipment taxes for an order. |
Adjustment Fulfillment Total | Total shipment adjustments applied to an order. |
Adjustment Other Charges Total | Total of included additional adjustment charges paid for an order. |
Adjustment Other Credits Total | Total of credits issued for an order. |
Adjustment Refund Total | Total of return dollars for an order. |
Adjustment Replacement Total | Total of replacement dollars for an order. |
Adjustment Rma Refund Total | Total of refund dollards associated to an order that was returned via the RMA functionality of the Chord OMS. |
Adjustment Tax Total | Total adjustment taxes an order. |
Adjustment Total | Total of adjustment applied for an order as on the order. |
Applied Gift Card Total | Total of gift card dollars that were used as a payment method in the order |
Commission Total | Commission for an order. |
Fulfillment Total | Total shipment for an order. |
Gross Revenue | Gross amount of revenue generated by the order including items and shipments totals. Gross revenue = total - included_tax_total + shipment_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Included Tax Total | Total included taxes for an order. |
Item Total | Total price for the order before adjustments. |
Net Revenue | Net revenue generated by the order's items after promotions. Net revenue = total - included_tax_total + shipment_total + adjustment_total - additional_tax_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Pre Paid Purchase Total | The amount of the order that was purchased as a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card. |
Pre Paid Redemption Total | The amount of the order that was the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card. |
Total Price | Total to be paid by the customer for an order. |
Promo Total | Promotions applied to an order. |
Purchased Gift Card Total | Total of gift card dollars that were purchased in the order. |
Reimbursement Credit Total | The amount of store credits owed back in an order |
Tax Total | Total taxes for an order. |
Transaction Total | Total paid by the customer for a completed order. |
order_discount_codes
Name | Description |
|---|---|
Billing Address 1 | The street address of the billing address. |
Billing Address 2 | An additional field for the street address of the billing address. |
Billing Address City | The city, town, or village of the billing address. |
Billing Address Company | The company associated to this billing address. |
Billing Address Country | The name of the country of the billing address. |
Billing Address Country Code | The two-letter code (ISO 3166-1 format) for the country of the billing address. |
Billing Address First Name | The first name of the person associated to this billing address. |
Billing Address Id | Unique identifier generated by Chord for a Billing Address. |
Billing Address Last Name | The last name of the person associated to this billing address. |
Billing Address Latitude | The latitude of the billing address. |
Billing Address Longitude | The longitude of the billing address. |
Billing Address Name | The full name of the person associated to this billing address. |
Billing Address Oms Billing Address Id | Unique key generated by Shopify that identifies a billing address. |
Billing Address Phone | The phone number associated to this billing address. |
Billing Address Province | The name of the region (province, state, prefecture, …) of the billing address. |
Billing Address Province Code | The two-letter abbreviation of the region of the billing address. |
Billing Address Zip | The postal code of the billing address. |
First Fulfillment Id | Unique identifier for a Shopify Fulfillment at a specific point in time |
First Fulfillment Oms Fulfillment Id | Unique key generated by Shopify that identifies a fulfillment. |
First Fulfillment Shipment Status | Represent the status of the shipment. |
First Fulfillment Status | The status of the fulfillment. |
First Fulfillment Tracking Company | The name of the tracking company. |
First Fulfillment Tracking Numbers | A list of tracking numbers provided by the tracking company. |
First Fulfillment Tracking Urls | The URLs of tracking pages for the fulfillment. |
Last Transaction Amount | The amount of money included in the transaction. |
Last Transaction Error Code | The error code explaining why the transaction failed. |
Last Transaction Gateway | The name of the gateway the transaction was issued through. |
Last Transaction Id | Unique identifier for a Shopify Transaction at a specific point in time |
Last Transaction Is Failed | Whether or not the transaction / payment has failed. |
Last Transaction Is Successful | Whether or not the transaction / payment has succeeded. |
Last Transaction Is Test | Whether this is a test transaction or not. |
Last Transaction Kind | The type of transaction. |
Last Transaction Message | Additional information provided the payment provider about the transaction. |
Last Transaction Oms Transaction Id | Unique key generated by Shopify that identifies a transaction. |
Last Transaction Status | The status of the transaction. |
Location Id | Unique identifier for a Shopify Location at a specific point in time |
Location Is Active | Whether the location is active or not. |
Location Is Online | Whether or not this location represents an online location. |
Location Is Physical | Whether or not this location represents a physical location. |
Location Name | The name of a location. |
Location Oms Location Id | Unique key generated by Shopify that identifies a location. |
Order Admin Url | Contains the full URL directing to the admin dashboard of Shopify for that given order. |
Order App Id | The ID of the app from Shopify that created the order. |
Order App Name | App name associated with the app id. This field will be generated if the Hub Configuration is enabled and the value has been set. |
Order Applied Discount Codes | The discount codes applied or a given order. |
Order Applied Discount Codes Count | The total number of applied discount code for a given order. |
Order Cancel Reason | The reason as to why the order was cancelled. |
Order Cart Website Locale | When available, this is the shopify international site activated prior to cart creation. |
Order Completed Order Rank By User | Allows to rank customer carts by completion date. In other words, this will rank the customer's completed order from 1 to X (X being the most recent order that was completed). |
Order Completed Subscription Order Rank By User | Allows to rank customer subscription orders by completion date. |
Order Contains First Subscription Order | A boolean value to indicate whether an order contains the first subscription order or not. An order may contain a mix of first and recurring subscriptions. |
Order Created Order Rank By User | Allows to rank customer carts by creation date. In other words, this will rank the customer's creation order from 1 to X (X being the last order that was created). An order can be created but never completed. |
Order Created Subscription Order Rank By User | Allows to rank customer subscription orders by creation date. |
Order Customer Lifetime Month | Number of months between the current order's creation date and the user's first order creation date. First orders have a value of 1. |
Order Customer Lifetime Week | Number of weeks between the current order's creation date and the user's first order creation date. First orders always have a value of 1. |
Order Filtered Order | Whether or not this order will be flagged by custom filter. |
Order Financial State | The status of transaction associated with the order. |
Order Fulfillment State | The summarized status of the shipment/fulfillment associated with the order. |
Order Has Discount | Whether or not the order has had a discount applied to it. |
Order Has Order Tag | Whether or not the order has an order tag applied to it. |
Order Id | Unique identifier generated by Chord for an order. |
Order Included Fulfillment Codes | Aggregated array of fulfillment codes, represented as a string. |
Order Included Fulfillment Methods | Aggregated array of fulfillment methods, represented as a string. |
Order Included Payment Gateways | This is the rolled up successful payment gateway for an order. Successful payments are included if they are sale or capture transactions. |
Order Included Source Subscription Ids | String list of included source subscription ids per order. Subscription information received from tenant-enabled platforms including Recharge and Shopify Plus. |
Order Included Subscription Ids | String list of included subscription ids per order. Subscription information received from tenant-enabled platforms including Recharge and Shopify Plus. |
Order Is Admin | Whether or not the order was created by an admin. |
Order Is Cancelled | Whether or not the order was cancelled. If `cancelled_at` is non-null then we consider the order has being cancelled. |
Order Is Completed | Whether or not the order was completed. An order is considered completed if it has a closed_at timestamp and has been fully fulfilled. Closed_at is generated for orders in Shopify that are automatically archived. If this feature is not enabled, the last updated closed fulfillment date is used as the completed at date. |
Order Is First Completed Order | Whether the order was the customer's first completed order or not. |
Order Is First Order | Whether the order was the customer's first order or not. |
Order Is First Subscription Completed Order | Whether the order was the customer's first completed subscription order or not. |
Order Is First Subscription Order | Whether the order was the customer's first subscription order or not. |
Order Is Part Of Subscription | Boolean flag to indicate whether the order was a part of a subscription plan or not. |
Order Is Test | Whether this is a test order or not. |
Order Item Id | Unique identifier generated by Chord for an order. |
Order Item Is First Product Type Order | Whether this order contains the first product type basket for the user. |
Order Item Is Last Product Type Order | Whether this order contains the last, most recent, product type basket for the user. |
Order Item Is Repeat Product Type Order | Whether this order contains a repeat product type basket for the user. |
Order Item Product Basket Count | The count of products for a given order. |
Product Basket | The titles of products for a given orderarray converted to a string. |
Order Item Product Purchased Quantity | The total number of product purchased for a given order. |
Order Item Rank Product Type Order | Rank orders with the same product type basket per user. |
Order Item Unique Product Basket Count | The count of unique products for a given order. |
Unique Product Basket | The unique titles of products for a given order array converted to a string. |
Order Item Unique Product Type | The unique line item product types for a given order. |
Order Item Unique Variant Basket Count | The count of unique SKUs for a given order. |
Unique Variant Basket | The unique SKUs of variants for a given order array converted to a string. |
Order Item Variant Basket Count | The count of variants for a given order. |
Variant Basket | The SKUs of variants for a given order array converted to a string. |
Order Item Variant Purchased Quantity | The total number of variants purchased for a given order. |
Order Name | Unique name generated by Shopify that is displayed to the customer (e.g. |
Order Number Of Non Reactivated Subscriptions | Number of non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription. |
Order Number Of Reactivated Subscriptions | Number of reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription. |
Order Oms Order Id | Unique key generated by Shopify that identifies an order. |
Order Tags | The order tags applied to a given order, in alphabetical order. |
Order Tags Count | The total number of order tags for a given order. |
Order Processing Method | How the payment was processed. |
Order Segment Anonymous Id | When available, this is where we store Segment's anonymous_id at the time of checkout. |
Order Source Name | Where did the order get created from. |
Shipping Address 1 | The street address of the shipping address. |
Shipping Address 2 | An additional field for the street address of the shipping address. |
Shipping Address City | The city, town, or village of the shipping address. |
Shipping Address Company | The company associated to this shipping address. |
Shipping Address Country | The name of the country of the shipping address. |
Shipping Address Country Code | The two-letter code (ISO 3166-1 format) for the country of the shipping address. |
Shipping Address First Name | The first name of the person associated to this shipping address. |
Shipping Address Id | Unique identifier generated by Chord for a Shipping Address. |
Shipping Address Last Name | The last name of the person associated to this shipping address. |
Shipping Address Latitude | The latitude of the shipping address. |
Shipping Address Longitude | The longitude of the shipping address. |
Shipping Address Name | The full name of the person associated to this shipping address. |
Shipping Address Oms Shipping Address Id | Unique key generated by Shopify that identifies a shipping address. |
Shipping Address Phone | The phone number associated to this shipping address. |
Shipping Address Province | The name of the region (province, state, prefecture, ...) of the shipping address. |
Shipping Address Province Code | The two-letter abbreviation of the region of the shipping address. |
Shipping Address Zip | The postal code of the shipping address. |
Store Id | Unique key generated by our models that uniquifies a store. |
Store Name | The name of the store. |
Store Oms Admin Url | The Admin URL of that OMS. |
Store Oms Id | Unique key generated by Chord that uniquifies an OMS. |
Store Oms Store Id | Unique key generated by our models that uniquifies a store. |
Store Oms Type | The type of the OMS. |
Store Id | Unique key generated by our models that uniquifies a store. |
Store Tenant Id | Unique key generated by Chord that uniquifies a tenant. |
Store Url | The Storefront URL of of the store. |
User Completed Oms Order Ids | List of all completed OMS order ids for a user. |
User Completed Order Names | List of all completed order names for a user. |
User Email | The email of the customer. |
User First Completed Oms Order Id | Order id from the OMS for the first completed order. |
User First Completed Order Name | Order name for the first completed order. |
User First Name | The first name of the customer. |
User First Name Last Initial | The first name and last name initials of the customer. This appends the value of `first_name` and the first character of last_name together. |
User First Order Unique Ordered Products | List of unique products purchased by the user in their first completed order. |
User First Order Unique Ordered Skus | List of unique variant SKUs purchased by the user in their first completed order. |
User First Subscription Ids | Array of first subscription ids purchased by the user. The user may have more than one subscription created at the same time, resulting in more than one subscription counted as first. |
User Full Name | The full name of the customer. This appends the value of first_name and last_name together. |
User Has Ordered A La Carte | Whether or not the user has had at least one order that is not a part of a subscription. |
User Has Promo Applied In First Order | Whether the first completed order has a promo applied or not. |
User Has Reactivation Subscription | Whether or not the user has at least one subscription created after the first subscription is cancelled. |
User Has Subscription In First Order | Whether or not the user's first order is linked to a subscription. |
User Has Verified Email | Whether the customer has verified their email address. |
User Id | Unique identifier generated by Chord to identify the user. |
User Is Active Subscriber | Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused. Subscribers may have completed subscription orders on inactive subscriptions, but will not be considered active if their current subscription has no completed orders. |
User Is Customer | Whether the user has completed at least one order or not. |
User Is New Customer | Whether the user has completed one order or not. |
User Is Not Customer | Whether the user has no completed orders or not. |
User Is Returning Customer | Whether the user has completed more than one order or not. |
User Is Subscriber | Whether or not the user has completed at least one subscription order. |
User Last Name | The last name of the customer. |
User Last Subscription Ids | Array of last subscription ids purchased by a user. The user may have more than one subscription created at the same time, resulting in more than one subscription counted as last. |
User Number Of Cancelled Subscriptions | Total number of subscriptions the user has cancelled. |
User Number Of Completed A La Carte Orders | Total number of orders completed by a user that are a la carte. |
User Number Of Completed Orders | Total count of completed orders by the user. |
User Number Of Completed Subscription Orders | Total number of orders completed by a user that are part of a subscription. |
User Number Of Created Subscription Orders | Total number of orders created by a user that are part of a subscription. |
User Number Of Orders With Promos | Count of completed orders with a promo applied. |
User Number Of Reactivated Subscriptions | Total number of subscriptions for a user that are reactivations. These subscriptions may be active, inactive, or concurrent. |
User Number Of Subscriptions | Total number of subscriptions linked to a user. These subscriptions may be active, inactive, or concurrent. |
User Oms User Id | Unique identifier generated by the OMS to identify the user. |
User Phone | The phone number of the customer. |
User Unique Ordered Product Type | List of unique product types purchased by the user across all completed orders. |
User Unique Ordered Products | List of unique products purchased by the user across all completed orders. |
User Unique Ordered Skus | List of unique variant SKUs purchased by the user across all completed orders. |
Order Cancelled At (Universal) | Reflects when the order was cancelled in Shopify - Universal Time Zone. |
Order Completed At (Central) | The timestamp when this order became completed - Cental Time Zone. |
Order Completed At (Eastern) | The timestamp when this order became completed - Eastern Time Zone. |
Order Completed At (Mountain) | The timestamp when this order became completed - Mountain Time Zone. |
Order Completed At (Pacific) | The timestamp when this order became completed - Pacific Time Zone. |
Order Completed At (Universal) | The timestamp when this order became completed - Universal Time Zone. |
Order Created At (Central) | Reflects when the entity was first created in Shopify - Cental Time Zone. |
Order Created At (Eastern) | Reflects when the entity was first created in Shopify - Eastern Time Zone. |
Order Created At (Mountain) | Reflects when the entity was first created in Shopify - Mountain Time Zone. |
Order Created At (Pacific) | Reflects when the entity was first created in Shopify - Pacific Time Zone. |
Order Created At (Universal) | Reflects when the entity was first created in Shopify - Universal Time Zone. |
Order Last Fulfillment At (Universal) | The maximum timestamp for the last update order fulfillment - Universal Time Zone. |
Order Updated At (Universal) | Reflects when the entity was last updated in Shopify - Universal Time Zone. |
User First Completed Order Completed At (Universal) | Timestamp for the first order completed - Universal Time Zone. |
User First Completed Order Created At (Universal) | Timestamp for the first completed order created - Universal Time Zone. |
User First Order Created At (Universal) | Timestamp of the first created order for the user - Universal Time Zone. |
User First Subscription Created At (Universal) | Timestamp of when the first subscription was created per user - Universal Time Zone. |
User First Subscription Order Completed At (Universal) | The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone. |
User First Subscription Order Created At (Universal) | The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone. |
User Last Completed Order Completed At (Universal) | Timestamp for the most recent order completed - Universal Time Zone. |
User Last Completed Order Created At (Universal) | Timestamp for the most recent completed order created - Universal Time Zone. |
Average Additional Tax Total | When taxes are not included in the subtotal, this is total tax added to the order. |
Average Fulfillment Tax Total | Total tax applied to the order's fulfillment fee. |
Average Fulfillment Total | The sum of all shipping prices in the location's currency. |
Average Gross Revenue | Gross revenue of the order calculated as item_total+fulfillment_total |
Average Included Tax Total | When taxes are included in the subtotal, this is the total tax included in the order. |
Average Item Total | The sum of all line item prices in the location's currency. |
Average Line Item Tax Total | Total tax applied to the line items of the order. |
Average Manual Transaction Total | Sum of all sales transaction with gateway of type manual. |
Average Net Revenue | Net revenue of the order calculated as item_total + fulfillment_total - promo_total - refund_total |
Average Non Reactivated Subscription Unit Total | Sum of unit price for non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription. |
Average Payment Capture Total | Sum of successful capture transactions. |
Average Payment Total | Sum of all sales transaction with gateway of type shopify_payments. |
Average Product Basket Count | The count of products for a given order. |
Average Product Purchased Quantity | The total number of product purchased for a given order. |
Average Promo Total | The total discounts applied to the price of the order in the location's currency. |
Average Reactivated Subscription Unit Total | Sum of unit price for reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription. |
Average Refund Total | Sum of all the transactions that are of kind refund applied to the order. |
Average Tax Total | The sum of all the taxes applied to the order in the location's currency. |
Average Total Price | The sum of all line item prices, discounts, shipping, taxes, and tips in the |
Average Transaction Total | Sum of all sale transactions for the order. |
Average Variant Basket Count | The count of variants for a given order. |
Average Variant Purchased Quantity | The total number of variants purchased for a given order. |
Additional Tax Total | When taxes are not included in the subtotal, this is total tax added to the order. |
Fulfillment Tax Total | Total tax applied to the order's fulfillment fee. |
Fulfillment Total | The sum of all shipping prices in the location's currency. |
Gross Revenue | Gross revenue of the order calculated as item_total + fulfillment_total |
Included Tax Total | When taxes are included in the subtotal, this is the total tax included in the order. |
Item Total | The sum of all line item prices in the location's currency. |
Line Item Tax Total | Total tax applied to the line items of the order. |
Manual Transaction Total | Sum of all sales transaction with gateway of type manual. |
Net Revenue | Net revenue of the order calculated as item_total+ fulfillment_total- promo_total - refund_total |
Non Reactivated Subscription Unit Total | Sum of unit price for non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription. |
Payment Capture Total | Sum of successful capture transactions. |
Payment Total | Sum of all sales transaction with gateway of type shopify_payments. |
Total Price | The sum of all line item prices, discounts, shipping, taxes, and tips in the |
Product Basket Count | The count of products for a given order. |
Product Purchased Quantity | The total number of product purchased for a given order. |
Promo Total | The total discounts applied to the price of the order in the location's currency. |
Reactivated Subscription Unit Total | Sum of unit price for reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription. |
Refund Total | Sum of all the transactions that are of kind refund applied to the order. |
Tax Total | The sum of all the taxes applied to the order in the location's currency. |
Transaction Total | Sum of all sale transactions for the order. |
Variant Basket Count | The count of variants for a given order. |
Variant Purchased Quantity | The total number of variants purchased for a given order. |
Name | Description |
|---|---|
Order Applied Discount Codes | Discount code(s) applied to the order. |
order_discount_names
Name | Description |
|---|---|
Order Applied Discount Names | Discount name(s) applied to the order. |
order_tags
Name | Description |
|---|---|
Order Tags | Order tag(s) applied to the order. |
subscription_tags
Name | Description |
|---|---|
Subscription Tags | Subscription tag(s) applied to the order. |