Search fields×Table: ORDERS account_name Display name Store URL Description The URL of the store Field type dimension Data type string.text.url billing_address_line_1 Display name Billing address line 1 Description Address line 1 Field type dimension Data type string.text.value billing_address_line_2 Display name Billing address line 2 Description Address line 2 Field type dimension Data type string.text.value billing_city Display name Billing city Description City name Field type dimension Data type string.geo.city billing_company_name Display name Billing company name Description Company name Field type dimension Data type string.text.value billing_country Display name Billing country code Description Shipping country. Country code in ISO 3166-1 alpha-2 format Field type dimension Data type string.geo.country.twolettercode billing_email Display name Billing email Description Email address Field type dimension Data type string.text.email billing_first_name Display name Billing first name Description Billing first name Field type dimension Data type string.text.value billing_last_name Display name Billing last name Description Billing last name Field type dimension Data type string.text.value billing_phone Display name Billing phone Description Phone number Field type dimension Data type string.text.phone billing_postcode Display name Billing post code Description Postal code Field type dimension Data type string.text.value billing_state Display name Billing state Description Shipping state. ISO code or name of the state, province or district Field type dimension Data type string.text.value created_via Display name Order created via Description Shows where the order was created Field type dimension Data type string.text.value customer_id Display name Customer ID Description User ID who owns the order. 0 for guests. Default is 0 Field type dimension Data type string.text.value customer_ip_address Display name Customer IP address Description Customer's IP address Field type dimension Data type string.text.value customer_note Display name Customer note Description Note left by customer during checkout Field type dimension Data type string.text.value customer_user_agent Display name Customer user agent Description User agent of the customer Field type dimension Data type string.text.value dataSourceName Display name Data source Description The name of the source for this data, as listed on supermetrics.com/docs Field type dimension Data type string.text.value date Display name Date Field type dimension Data type string.time.date needs_payment Display name Order is paid Description Define if the order is paid. It will set the status to processing and reduce stock items Field type dimension Data type bool order_cart_tax Display name Order cart tax Description Sum of line item taxes only Field type metric Data type float.currency.value order_completed_date Display name Order completed date Description The date the order was completed, in the site's timezone Field type dimension Data type string.time.date order_completed_date_gmt Display name Order completed date (GMT) Description The date the order was completed, in the GMT timezone Field type dimension Data type string.time.date order_completed_datetime Display name Order completed datetime Description The datetime the order was completed, in the site's timezone Field type dimension Data type string.time.datetime order_completed_datetime_gmt Display name Order completed datetime (GMT) Description The datetime the order was completed, in the GMT timezone Field type dimension Data type string.time.datetime order_created_date Display name Order created date Description The date the order was created, in the site's timezone Field type dimension Data type string.time.date order_created_datetime Display name Order created datetime Description The datetime the order was created, in the site's timezone Field type dimension Data type string.time.datetime order_created_datetime_gmt Display name Order created datetime (GMT) Description The datetime the order was created, in the GMT timezone Field type dimension Data type string.time.datetime order_created_gmt Display name Order created date (GMT) Description The datetime the order was created, in the GMT timezone Field type dimension Data type string.time.date order_currency Display name Order currency Description Currency the order was created with, in ISO format Field type dimension Data type string.currency.code order_discount_tax Display name Order discount tax Description Total discount tax amount for the order Field type metric Data type float.currency.value order_discount_total Display name Order discount total Description Total discount amount for the order Field type metric Data type float.currency.value order_id Display name Order ID Description Unique identifier for the order Field type dimension Data type string.text.value order_key Display name Order key Description Key of the order Field type dimension Data type string.text.value order_modified_date Display name Order modified date Description The date the order was last modified, in the site's timezone Field type dimension Data type string.time.date order_modified_datetime Display name Order modified datetime Description The datetime the order was last modified, in the site's timezone Field type dimension Data type string.time.datetime order_modified_datetime_gmt Display name Order modified datetime (GMT) Description The datetime the order was last modified, in the GMT timezone Field type dimension Data type string.time.datetime order_modified_gmt Display name Order modified date (GMT) Description The datetime the order was last modified, in the GMT timezone Field type dimension Data type string.time.date order_number Display name Order number Description Number of the order Field type dimension Data type string.text.value order_paid_date Display name Order paid date Description The date the order was paid, in the site's timezone Field type dimension Data type string.time.date order_paid_date_gmt Display name Order paid date (GMT) Description The date the order was paid, in the GMT timezone Field type dimension Data type string.time.date order_paid_datetime Display name Order paid datetime Description The datetime the order was paid, in the site's timezone Field type dimension Data type string.time.datetime order_paid_datetime_gmt Display name Order paid datetime (GMT) Description The datetime the order was paid, in the GMT timezone Field type dimension Data type string.time.datetime order_shipping_tax Display name Order shipping tax Description Total shipping tax amount for the order Field type metric Data type float.currency.value order_shipping_total Display name Order shipping total Description Total shipping amount for the order Field type metric Data type float.currency.value order_status Display name Order status Description Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending Field type dimension Data type string.text.value order_total Display name Order total Description Grand total Field type metric Data type float.currency.value order_total_tax Display name Order total tax Description Sum of all taxes Field type metric Data type float.currency.value parent_id Display name Order parent ID Description Parent ID of the order Field type dimension Data type string.text.value payment_method Display name Payment method ID Description Payment method ID Field type dimension Data type string.text.value payment_method_title Display name Payment method title Description Payment method title Field type dimension Data type string.text.value prices_include_tax Display name Prices include tax Description True the prices included tax during checkout Field type dimension Data type bool shipping_address_line_1 Display name Shipping address line 1 Description Shipping address line 1 Field type dimension Data type string.text.value shipping_address_line_2 Display name Shipping address line 2 Description Shipping address line 2 Field type dimension Data type string.text.value shipping_city Display name Shipping city Description Shipping city name Field type dimension Data type string.geo.city shipping_company_name Display name Shipping company name Description Shipping company name Field type dimension Data type string.text.value shipping_country Display name Shipping country code Description Shipping country. Country code in ISO 3166-1 alpha-2 format Field type dimension Data type string.geo.country.twolettercode shipping_first_name Display name Shipping first name Description Shipping first name Field type dimension Data type string.text.value shipping_last_name Display name Shipping last name Description Shipping last name Field type dimension Data type string.text.value shipping_phone Display name Shipping phone Description Shipping phone number Field type dimension Data type string.text.phone shipping_postcode Display name Shipping post code Description Shipping postal code Field type dimension Data type string.text.value shipping_state Display name Shipping state Description Shipping state. ISO code or name of the state, province or district Field type dimension Data type string.text.value transaction_id Display name Unique transaction ID Description Unique transaction ID Field type dimension Data type string.text.valueTable: ORDER_ITEMS account_name Display name Store URL Description The URL of the store Field type dimension Data type string.text.url billing_address_line_1 Display name Billing address line 1 Description Address line 1 Field type dimension Data type string.text.value billing_address_line_2 Display name Billing address line 2 Description Address line 2 Field type dimension Data type string.text.value billing_city Display name Billing city Description City name Field type dimension Data type string.geo.city billing_company_name Display name Billing company name Description Company name Field type dimension Data type string.text.value billing_country Display name Billing country code Description Shipping country. Country code in ISO 3166-1 alpha-2 format Field type dimension Data type string.geo.country.twolettercode billing_email Display name Billing email Description Email address Field type dimension Data type string.text.email billing_first_name Display name Billing first name Description Billing first name Field type dimension Data type string.text.value billing_last_name Display name Billing last name Description Billing last name Field type dimension Data type string.text.value billing_phone Display name Billing phone Description Phone number Field type dimension Data type string.text.phone billing_postcode Display name Billing post code Description Postal code Field type dimension Data type string.text.value billing_state Display name Billing state Description Shipping state. ISO code or name of the state, province or district Field type dimension Data type string.text.value created_via Display name Order created via Description Shows where the order was created Field type dimension Data type string.text.value customer_id Display name Customer ID Description User ID who owns the order. 0 for guests. Default is 0 Field type dimension Data type string.text.value customer_ip_address Display name Customer IP address Description Customer's IP address Field type dimension Data type string.text.value customer_note Display name Customer note Description Note left by customer during checkout Field type dimension Data type string.text.value customer_user_agent Display name Customer user agent Description User agent of the customer Field type dimension Data type string.text.value dataSourceName Display name Data source Description The name of the source for this data, as listed on supermetrics.com/docs Field type dimension Data type string.text.value date Display name Date Field type dimension Data type string.time.date line_item_discount Display name Item discount Description Discount applied for the line-item. (Item discount = Item subtotal - Item total) Field type metric Data type float.currency.value line_item_id Display name Line item ID Description Item ID Field type dimension Data type string.text.value line_item_image_id Display name Line item image ID Description Line item image ID Field type dimension Data type string.text.value line_item_image_url Display name Line item image URL Description Line item image URL Field type dimension Data type string.text.url line_item_name Display name Product name Description Product name Field type dimension Data type string.text.value line_item_parent_name Display name Product parent name Description Product parent name Field type dimension Data type string.text.value line_item_price Display name Item price Description Cost per line item unit Field type metric Data type float.currency.value line_item_product_id Display name Product ID Description Product ID Field type dimension Data type string.text.value line_item_sku Display name Line item SKU Description Product SKU Field type dimension Data type string.text.value line_item_subtotal Display name Item subtotal Description Line item subtotal (before discounts) Field type metric Data type float.currency.value line_item_tax_class Display name Line item tax class Description Slug of the tax class of product Field type dimension Data type string.text.value line_item_total Display name Item total Description Line total (after discounts) Field type metric Data type float.currency.value line_item_total_tax Display name Item tax Description Tax for the line item Field type metric Data type float.currency.value line_item_variation_id Display name Product variation ID Description Variation ID, if applicable Field type dimension Data type string.text.value needs_payment Display name Order is paid Description Define if the order is paid. It will set the status to processing and reduce stock items Field type dimension Data type bool order_completed_date Display name Order completed date Description The date the order was completed, in the site's timezone Field type dimension Data type string.time.date order_completed_date_gmt Display name Order completed date (GMT) Description The date the order was completed, in the GMT timezone Field type dimension Data type string.time.date order_completed_datetime Display name Order completed datetime Description The datetime the order was completed, in the site's timezone Field type dimension Data type string.time.datetime order_completed_datetime_gmt Display name Order completed datetime (GMT) Description The datetime the order was completed, in the GMT timezone Field type dimension Data type string.time.datetime order_created_date Display name Order created date Description The date the order was created, in the site's timezone Field type dimension Data type string.time.date order_created_datetime Display name Order created datetime Description The datetime the order was created, in the site's timezone Field type dimension Data type string.time.datetime order_created_datetime_gmt Display name Order created datetime (GMT) Description The datetime the order was created, in the GMT timezone Field type dimension Data type string.time.datetime order_created_gmt Display name Order created date (GMT) Description The datetime the order was created, in the GMT timezone Field type dimension Data type string.time.date order_currency Display name Order currency Description Currency the order was created with, in ISO format Field type dimension Data type string.currency.code order_id Display name Order ID Description Unique identifier for the order Field type dimension Data type string.text.value order_key Display name Order key Description Key of the order Field type dimension Data type string.text.value order_modified_date Display name Order modified date Description The date the order was last modified, in the site's timezone Field type dimension Data type string.time.date order_modified_datetime Display name Order modified datetime Description The datetime the order was last modified, in the site's timezone Field type dimension Data type string.time.datetime order_modified_datetime_gmt Display name Order modified datetime (GMT) Description The datetime the order was last modified, in the GMT timezone Field type dimension Data type string.time.datetime order_modified_gmt Display name Order modified date (GMT) Description The datetime the order was last modified, in the GMT timezone Field type dimension Data type string.time.date order_number Display name Order number Description Number of the order Field type dimension Data type string.text.value order_paid_date Display name Order paid date Description The date the order was paid, in the site's timezone Field type dimension Data type string.time.date order_paid_date_gmt Display name Order paid date (GMT) Description The date the order was paid, in the GMT timezone Field type dimension Data type string.time.date order_paid_datetime Display name Order paid datetime Description The datetime the order was paid, in the site's timezone Field type dimension Data type string.time.datetime order_paid_datetime_gmt Display name Order paid datetime (GMT) Description The datetime the order was paid, in the GMT timezone Field type dimension Data type string.time.datetime order_status Display name Order status Description Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending Field type dimension Data type string.text.value parent_id Display name Order parent ID Description Parent ID of the order Field type dimension Data type string.text.value payment_method Display name Payment method ID Description Payment method ID Field type dimension Data type string.text.value payment_method_title Display name Payment method title Description Payment method title Field type dimension Data type string.text.value prices_include_tax Display name Prices include tax Description True the prices included tax during checkout Field type dimension Data type bool quantity Display name Item quantity Description Number of line item units Field type metric Data type int.number.value shipping_address_line_1 Display name Shipping address line 1 Description Shipping address line 1 Field type dimension Data type string.text.value shipping_address_line_2 Display name Shipping address line 2 Description Shipping address line 2 Field type dimension Data type string.text.value shipping_city Display name Shipping city Description Shipping city name Field type dimension Data type string.geo.city shipping_company_name Display name Shipping company name Description Shipping company name Field type dimension Data type string.text.value shipping_country Display name Shipping country code Description Shipping country. Country code in ISO 3166-1 alpha-2 format Field type dimension Data type string.geo.country.twolettercode shipping_first_name Display name Shipping first name Description Shipping first name Field type dimension Data type string.text.value shipping_last_name Display name Shipping last name Description Shipping last name Field type dimension Data type string.text.value shipping_phone Display name Shipping phone Description Shipping phone number Field type dimension Data type string.text.phone shipping_postcode Display name Shipping post code Description Shipping postal code Field type dimension Data type string.text.value shipping_state Display name Shipping state Description Shipping state. ISO code or name of the state, province or district Field type dimension Data type string.text.value transaction_id Display name Unique transaction ID Description Unique transaction ID Field type dimension Data type string.text.value