Orders
A Shopify report of orders.
Live
Ecommerce brands and their agencies use Shopify in Datapipe to see orders, products, and sales from the store.
Shopify OAuth for a custom app, or an Admin API access token you paste with the shop domain. Orders and products use the Admin API. The default Admin API version in this app is 2026-10.
Protected customer fields stay empty until Shopify approves that access. New public custom apps are created in the Dev Dashboard. This page's long field list is the Admin API catalog, not the columns the reports request.
Last reviewed 2026-10-29. Owner: Datapipe.
Live with your own API key
Live with a custom app admin token from your own store. Orders and products work. Protected customer data stays empty until Shopify approves that access.
Fields present in the official Admin REST order example. Protected customer fields may be empty until Shopify approves protected customer data. Source: https://shopify.dev/docs/api/admin-rest/2026-01/resources/order. Read on 2026-10-27. 351 fields.
created_atshipping_countryfinancial_statusordersgross_salesdiscountsnet_salesaverage_order_value| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| session hash | client_details.session_hash | Documented on this resource as client_details.session_hash (string). | dimension · string | Audience | |
| user agent | client_details.user_agent | Documented on this resource as client_details.user_agent (string). | dimension · string | Audience | |
| user id | user_id | Documented on this resource as user_id (string). | dimension · string | Audience |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| landing site | landing_site | Documented on this resource as landing_site (string). | dimension · string | Content | |
| landing site ref | landing_site_ref | Documented on this resource as landing_site_ref (string). | dimension · string | Content | |
| order status url | order_status_url | Documented on this resource as order_status_url (string). | dimension · string | Content | |
| tracking url | fulfillments[].tracking_url | Documented on this resource as fulfillments[].tracking_url (string). | dimension · string | Content | |
| tracking urls | fulfillments[].tracking_urls | Documented on this resource as fulfillments[].tracking_urls (array). | dimension · string | Content |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| admin graphql api id | admin_graphql_api_id | Documented on this resource as admin_graphql_api_id (string). | dimension · string | Dimensions | |
| app id | app_id | Documented on this resource as app_id (string). | dimension · string | Dimensions | |
| buyer accepts marketing | buyer_accepts_marketing | Documented on this resource as buyer_accepts_marketing (boolean). | dimension · boolean | Dimensions | |
| cancel reason | cancel_reason | Documented on this resource as cancel_reason (string). | dimension · string | Dimensions | |
| cancelled at | cancelled_at | Documented on this resource as cancelled_at (string). | dimension · string | Dimensions | |
| client details | client_details | Documented on this resource as client_details (object). | dimension · string | Dimensions | |
| confirmation number | confirmation_number | Documented on this resource as confirmation_number (string). | dimension · string | Dimensions | |
| confirmed | confirmed | Documented on this resource as confirmed (boolean). | dimension · boolean | Dimensions | |
| contact email | contact_email | Documented on this resource as contact_email (string). | dimension · string | Dimensions | |
| created at · Synced today | created_at | Documented on this resource as created_at (string). | dimension · string | Dimensions | |
| currency | currency | Documented on this resource as currency (string). | dimension · string | Dimensions | |
| current total discounts | current_total_discounts | Documented on this resource as current_total_discounts (string). | dimension · string | Dimensions | |
| current total discounts set | current_total_discounts_set | Documented on this resource as current_total_discounts_set (object). | dimension · string | Dimensions | |
| shop money | current_total_discounts_set.shop_money | Documented on this resource as current_total_discounts_set.shop_money (object). | dimension · string | Dimensions | |
| currency code | current_total_discounts_set.shop_money.currency_code | Documented on this resource as current_total_discounts_set.shop_money.currency_code (string). | dimension · string | Dimensions | |
| current total duties set | current_total_duties_set | Documented on this resource as current_total_duties_set (string). | dimension · string | Dimensions | |
| current total tax | current_total_tax | Documented on this resource as current_total_tax (string). | dimension · string | Dimensions | |
| current total tax set | current_total_tax_set | Documented on this resource as current_total_tax_set (object). | dimension · string | Dimensions | |
| shop money | current_total_tax_set.shop_money | Documented on this resource as current_total_tax_set.shop_money (object). | dimension · string | Dimensions | |
| currency code | current_total_tax_set.shop_money.currency_code | Documented on this resource as current_total_tax_set.shop_money.currency_code (string). | dimension · string | Dimensions | |
| customer locale | customer_locale | Documented on this resource as customer_locale (string). | dimension · string | Dimensions | |
| discount codes | discount_codes | Documented on this resource as discount_codes (array). | dimension · string | Dimensions | |
| code | discount_codes[].code | Documented on this resource as discount_codes[].code (string). | dimension · string | Dimensions | |
| type | discount_codes[].type | Documented on this resource as discount_codes[].type (string). | dimension · string | Dimensions | |
| duties included | duties_included | Documented on this resource as duties_included (boolean). | dimension · boolean | Dimensions | |
email | Documented on this resource as email (string). | dimension · string | Dimensions | ||
| estimated taxes | estimated_taxes | Documented on this resource as estimated_taxes (boolean). | dimension · boolean | Dimensions | |
| financial status · Synced today | financial_status | Documented on this resource as financial_status (string). | dimension · string | Dimensions | |
| fulfillment status | fulfillment_status | Documented on this resource as fulfillment_status (string). | dimension · string | Dimensions | |
| merchant business entity id | merchant_business_entity_id | Documented on this resource as merchant_business_entity_id (string). | dimension · string | Dimensions | |
| merchant of record app id | merchant_of_record_app_id | Documented on this resource as merchant_of_record_app_id (string). | dimension · string | Dimensions | |
| name | name | Documented on this resource as name (string). | dimension · string | Dimensions | |
| note | note | Documented on this resource as note (string). | dimension · string | Dimensions | |
| note attributes | note_attributes | Documented on this resource as note_attributes (array). | dimension · string | Dimensions | |
| name | note_attributes[].name | Documented on this resource as note_attributes[].name (string). | dimension · string | Dimensions | |
| value | note_attributes[].value | Documented on this resource as note_attributes[].value (string). | dimension · string | Dimensions | |
| original total duties set | original_total_duties_set | Documented on this resource as original_total_duties_set (string). | dimension · string | Dimensions | |
| payment gateway names | payment_gateway_names | Documented on this resource as payment_gateway_names (array). | dimension · string | Dimensions | |
| phone | phone | Documented on this resource as phone (string). | dimension · string | Dimensions | |
| po number | po_number | Documented on this resource as po_number (string). | dimension · string | Dimensions | |
| processed at | processed_at | Documented on this resource as processed_at (string). | dimension · string | Dimensions | |
| reference | reference | Documented on this resource as reference (string). | dimension · string | Dimensions | |
| tags | tags | Documented on this resource as tags (string). | dimension · string | Dimensions | |
| tax exempt | tax_exempt | Documented on this resource as tax_exempt (boolean). | dimension · boolean | Dimensions | |
| tax lines | tax_lines | Documented on this resource as tax_lines (array). | dimension · string | Dimensions | |
| title | tax_lines[].title | Documented on this resource as tax_lines[].title (string). | dimension · string | Dimensions | |
| taxes included | taxes_included | Documented on this resource as taxes_included (boolean). | dimension · boolean | Dimensions | |
| test | test | Documented on this resource as test (boolean). | dimension · boolean | Dimensions | |
| token | token | Documented on this resource as token (string). | dimension · string | Dimensions | |
| total cash rounding payment adjustment set | total_cash_rounding_payment_adjustment_set | Documented on this resource as total_cash_rounding_payment_adjustment_set (object). | dimension · string | Dimensions | |
| shop money | total_cash_rounding_payment_adjustment_set.shop_money | Documented on this resource as total_cash_rounding_payment_adjustment_set.shop_money (object). | dimension · string | Dimensions | |
| currency code | total_cash_rounding_payment_adjustment_set.shop_money.currency_code | Documented on this resource as total_cash_rounding_payment_adjustment_set.shop_money.currency_code (string). | dimension · string | Dimensions | |
| total discounts | total_discounts | Documented on this resource as total_discounts (string). | dimension · string | Dimensions | |
| total discounts set | total_discounts_set | Documented on this resource as total_discounts_set (object). | dimension · string | Dimensions | |
| shop money | total_discounts_set.shop_money | Documented on this resource as total_discounts_set.shop_money (object). | dimension · string | Dimensions | |
| currency code | total_discounts_set.shop_money.currency_code | Documented on this resource as total_discounts_set.shop_money.currency_code (string). | dimension · string | Dimensions | |
| total outstanding | total_outstanding | Documented on this resource as total_outstanding (string). | dimension · string | Dimensions | |
| total tax | total_tax | Documented on this resource as total_tax (string). | dimension · string | Dimensions | |
| total tax set | total_tax_set | Documented on this resource as total_tax_set (object). | dimension · string | Dimensions | |
| shop money | total_tax_set.shop_money | Documented on this resource as total_tax_set.shop_money (object). | dimension · string | Dimensions | |
| currency code | total_tax_set.shop_money.currency_code | Documented on this resource as total_tax_set.shop_money.currency_code (string). | dimension · string | Dimensions | |
| total tip received | total_tip_received | Documented on this resource as total_tip_received (string). | dimension · string | Dimensions | |
| billing address | billing_address | Documented on this resource as billing_address (object). | dimension · string | Dimensions | |
| first name | billing_address.first_name | Documented on this resource as billing_address.first_name (string). | dimension · string | Dimensions | |
| address1 | billing_address.address1 | Documented on this resource as billing_address.address1 (string). | dimension · string | Dimensions | |
| phone | billing_address.phone | Documented on this resource as billing_address.phone (string). | dimension · string | Dimensions | |
| zip | billing_address.zip | Documented on this resource as billing_address.zip (string). | dimension · string | Dimensions | |
| province | billing_address.province | Documented on this resource as billing_address.province (string). | dimension · string | Dimensions | |
| last name | billing_address.last_name | Documented on this resource as billing_address.last_name (string). | dimension · string | Dimensions | |
| address2 | billing_address.address2 | Documented on this resource as billing_address.address2 (string). | dimension · string | Dimensions | |
| company | billing_address.company | Documented on this resource as billing_address.company (string). | dimension · string | Dimensions | |
| name | billing_address.name | Documented on this resource as billing_address.name (string). | dimension · string | Dimensions | |
| province code | billing_address.province_code | Documented on this resource as billing_address.province_code (string). | dimension · string | Dimensions | |
| customer | customer | Documented on this resource as customer (object). | dimension · string | Dimensions | |
| created at · Synced today | customer.created_at | Documented on this resource as customer.created_at (string). | dimension · string | Dimensions | |
| first name | customer.first_name | Documented on this resource as customer.first_name (string). | dimension · string | Dimensions | |
| last name | customer.last_name | Documented on this resource as customer.last_name (string). | dimension · string | Dimensions | |
| state | customer.state | Documented on this resource as customer.state (string). | dimension · string | Dimensions | |
| note | customer.note | Documented on this resource as customer.note (string). | dimension · string | Dimensions | |
| verified email | customer.verified_email | Documented on this resource as customer.verified_email (boolean). | dimension · boolean | Dimensions | |
| multipass identifier | customer.multipass_identifier | Documented on this resource as customer.multipass_identifier (string). | dimension · string | Dimensions | |
| tax exempt | customer.tax_exempt | Documented on this resource as customer.tax_exempt (boolean). | dimension · boolean | Dimensions | |
| tags | customer.tags | Documented on this resource as customer.tags (string). | dimension · string | Dimensions | |
customer.email | Documented on this resource as customer.email (string). | dimension · string | Dimensions | ||
| phone | customer.phone | Documented on this resource as customer.phone (string). | dimension · string | Dimensions | |
| currency | customer.currency | Documented on this resource as customer.currency (string). | dimension · string | Dimensions | |
| tax exemptions | customer.tax_exemptions | Documented on this resource as customer.tax_exemptions (array). | dimension · string | Dimensions | |
| admin graphql api id | customer.admin_graphql_api_id | Documented on this resource as customer.admin_graphql_api_id (string). | dimension · string | Dimensions | |
| default address | customer.default_address | Documented on this resource as customer.default_address (object). | dimension · string | Dimensions | |
| first name | customer.default_address.first_name | Documented on this resource as customer.default_address.first_name (string). | dimension · string | Dimensions | |
| last name | customer.default_address.last_name | Documented on this resource as customer.default_address.last_name (string). | dimension · string | Dimensions | |
| company | customer.default_address.company | Documented on this resource as customer.default_address.company (string). | dimension · string | Dimensions | |
| address1 | customer.default_address.address1 | Documented on this resource as customer.default_address.address1 (string). | dimension · string | Dimensions | |
| address2 | customer.default_address.address2 | Documented on this resource as customer.default_address.address2 (string). | dimension · string | Dimensions | |
| province | customer.default_address.province | Documented on this resource as customer.default_address.province (string). | dimension · string | Dimensions | |
| zip | customer.default_address.zip | Documented on this resource as customer.default_address.zip (string). | dimension · string | Dimensions | |
| phone | customer.default_address.phone | Documented on this resource as customer.default_address.phone (string). | dimension · string | Dimensions | |
| name | customer.default_address.name | Documented on this resource as customer.default_address.name (string). | dimension · string | Dimensions | |
| province code | customer.default_address.province_code | Documented on this resource as customer.default_address.province_code (string). | dimension · string | Dimensions | |
| default | customer.default_address.default | Documented on this resource as customer.default_address.default (boolean). | dimension · boolean | Dimensions | |
| discount applications | discount_applications | Documented on this resource as discount_applications (array). | dimension · string | Dimensions | |
| target type | discount_applications[].target_type | Documented on this resource as discount_applications[].target_type (string). | dimension · string | Dimensions | |
| type | discount_applications[].type | Documented on this resource as discount_applications[].type (string). | dimension · string | Dimensions | |
| value | discount_applications[].value | Documented on this resource as discount_applications[].value (string). | dimension · string | Dimensions | |
| value type | discount_applications[].value_type | Documented on this resource as discount_applications[].value_type (string). | dimension · string | Dimensions | |
| target selection | discount_applications[].target_selection | Documented on this resource as discount_applications[].target_selection (string). | dimension · string | Dimensions | |
| code | discount_applications[].code | Documented on this resource as discount_applications[].code (string). | dimension · string | Dimensions | |
| fulfillments | fulfillments | Documented on this resource as fulfillments (array). | dimension · string | Dimensions | |
| admin graphql api id | fulfillments[].admin_graphql_api_id | Documented on this resource as fulfillments[].admin_graphql_api_id (string). | dimension · string | Dimensions | |
| created at · Synced today | fulfillments[].created_at | Documented on this resource as fulfillments[].created_at (string). | dimension · string | Dimensions | |
| name | fulfillments[].name | Documented on this resource as fulfillments[].name (string). | dimension · string | Dimensions | |
| origin address | fulfillments[].origin_address | Documented on this resource as fulfillments[].origin_address (object). | dimension · string | Dimensions | |
| receipt | fulfillments[].receipt | Documented on this resource as fulfillments[].receipt (object). | dimension · string | Dimensions | |
| testcase | fulfillments[].receipt.testcase | Documented on this resource as fulfillments[].receipt.testcase (boolean). | dimension · boolean | Dimensions | |
| authorization | fulfillments[].receipt.authorization | Documented on this resource as fulfillments[].receipt.authorization (string). | dimension · string | Dimensions | |
| service | fulfillments[].service | Documented on this resource as fulfillments[].service (string). | dimension · string | Dimensions | |
| shipment status | fulfillments[].shipment_status | Documented on this resource as fulfillments[].shipment_status (string). | dimension · string | Dimensions | |
| status | fulfillments[].status | Documented on this resource as fulfillments[].status (string). | dimension · string | Dimensions | |
| tracking company | fulfillments[].tracking_company | Documented on this resource as fulfillments[].tracking_company (string). | dimension · string | Dimensions | |
| tracking number | fulfillments[].tracking_number | Documented on this resource as fulfillments[].tracking_number (string). | dimension · string | Dimensions | |
| tracking numbers | fulfillments[].tracking_numbers | Documented on this resource as fulfillments[].tracking_numbers (array). | dimension · string | Dimensions | |
| payment terms | payment_terms | Documented on this resource as payment_terms (string). | dimension · string | Dimensions | |
| shipping address | shipping_address | Documented on this resource as shipping_address (object). | dimension · string | Dimensions | |
| first name | shipping_address.first_name | Documented on this resource as shipping_address.first_name (string). | dimension · string | Dimensions | |
| address1 | shipping_address.address1 | Documented on this resource as shipping_address.address1 (string). | dimension · string | Dimensions | |
| phone | shipping_address.phone | Documented on this resource as shipping_address.phone (string). | dimension · string | Dimensions | |
| zip | shipping_address.zip | Documented on this resource as shipping_address.zip (string). | dimension · string | Dimensions | |
| province | shipping_address.province | Documented on this resource as shipping_address.province (string). | dimension · string | Dimensions | |
| last name | shipping_address.last_name | Documented on this resource as shipping_address.last_name (string). | dimension · string | Dimensions | |
| address2 | shipping_address.address2 | Documented on this resource as shipping_address.address2 (string). | dimension · string | Dimensions | |
| company | shipping_address.company | Documented on this resource as shipping_address.company (string). | dimension · string | Dimensions | |
| name | shipping_address.name | Documented on this resource as shipping_address.name (string). | dimension · string | Dimensions | |
| province code | shipping_address.province_code | Documented on this resource as shipping_address.province_code (string). | dimension · string | Dimensions | |
| shipping lines | shipping_lines | Documented on this resource as shipping_lines (array). | dimension · string | Dimensions | |
| carrier identifier | shipping_lines[].carrier_identifier | Documented on this resource as shipping_lines[].carrier_identifier (string). | dimension · string | Dimensions | |
| code | shipping_lines[].code | Documented on this resource as shipping_lines[].code (string). | dimension · string | Dimensions | |
| is removed | shipping_lines[].is_removed | Documented on this resource as shipping_lines[].is_removed (boolean). | dimension · boolean | Dimensions | |
| phone | shipping_lines[].phone | Documented on this resource as shipping_lines[].phone (string). | dimension · string | Dimensions | |
| requested fulfillment service id | shipping_lines[].requested_fulfillment_service_id | Documented on this resource as shipping_lines[].requested_fulfillment_service_id (string). | dimension · string | Dimensions | |
| title | shipping_lines[].title | Documented on this resource as shipping_lines[].title (string). | dimension · string | Dimensions | |
| tax lines | shipping_lines[].tax_lines | Documented on this resource as shipping_lines[].tax_lines (array). | dimension · string | Dimensions |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| cart token | cart_token | Documented on this resource as cart_token (string). | dimension · string | Ecommerce | |
| checkout id | checkout_id | Documented on this resource as checkout_id (integer). | metric · integer | Ecommerce | |
| checkout token | checkout_token | Documented on this resource as checkout_token (string). | dimension · string | Ecommerce | |
| current subtotal price | current_subtotal_price | Documented on this resource as current_subtotal_price (string). | dimension · string | Ecommerce | |
| current subtotal price set | current_subtotal_price_set | Documented on this resource as current_subtotal_price_set (object). | dimension · string | Ecommerce | |
| shop money | current_subtotal_price_set.shop_money | Documented on this resource as current_subtotal_price_set.shop_money (object). | dimension · string | Ecommerce | |
| amount | current_subtotal_price_set.shop_money.amount | Documented on this resource as current_subtotal_price_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| currency code | current_subtotal_price_set.shop_money.currency_code | Documented on this resource as current_subtotal_price_set.shop_money.currency_code (string). | dimension · string | Ecommerce | |
| presentment money | current_subtotal_price_set.presentment_money | Documented on this resource as current_subtotal_price_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | current_subtotal_price_set.presentment_money.amount | Documented on this resource as current_subtotal_price_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| currency code | current_subtotal_price_set.presentment_money.currency_code | Documented on this resource as current_subtotal_price_set.presentment_money.currency_code (string). | dimension · string | Ecommerce | |
| current total additional fees set | current_total_additional_fees_set | Documented on this resource as current_total_additional_fees_set (string). | dimension · string | Ecommerce | |
| amount | current_total_discounts_set.shop_money.amount | Documented on this resource as current_total_discounts_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| amount | current_total_discounts_set.presentment_money.amount | Documented on this resource as current_total_discounts_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| current total price | current_total_price | Documented on this resource as current_total_price (string). | dimension · string | Ecommerce | |
| current total price set | current_total_price_set | Documented on this resource as current_total_price_set (object). | dimension · string | Ecommerce | |
| shop money | current_total_price_set.shop_money | Documented on this resource as current_total_price_set.shop_money (object). | dimension · string | Ecommerce | |
| amount | current_total_price_set.shop_money.amount | Documented on this resource as current_total_price_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| currency code | current_total_price_set.shop_money.currency_code | Documented on this resource as current_total_price_set.shop_money.currency_code (string). | dimension · string | Ecommerce | |
| presentment money | current_total_price_set.presentment_money | Documented on this resource as current_total_price_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | current_total_price_set.presentment_money.amount | Documented on this resource as current_total_price_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| currency code | current_total_price_set.presentment_money.currency_code | Documented on this resource as current_total_price_set.presentment_money.currency_code (string). | dimension · string | Ecommerce | |
| amount | current_total_tax_set.shop_money.amount | Documented on this resource as current_total_tax_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| amount | current_total_tax_set.presentment_money.amount | Documented on this resource as current_total_tax_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| amount | discount_codes[].amount | Documented on this resource as discount_codes[].amount (string). | dimension · string | Ecommerce | |
| order number | order_number | Documented on this resource as order_number (integer). | metric · integer | Ecommerce | |
| original total additional fees set | original_total_additional_fees_set | Documented on this resource as original_total_additional_fees_set (string). | dimension · string | Ecommerce | |
| subtotal price | subtotal_price | Documented on this resource as subtotal_price (string). | dimension · string | Ecommerce | |
| subtotal price set | subtotal_price_set | Documented on this resource as subtotal_price_set (object). | dimension · string | Ecommerce | |
| shop money | subtotal_price_set.shop_money | Documented on this resource as subtotal_price_set.shop_money (object). | dimension · string | Ecommerce | |
| amount | subtotal_price_set.shop_money.amount | Documented on this resource as subtotal_price_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| currency code | subtotal_price_set.shop_money.currency_code | Documented on this resource as subtotal_price_set.shop_money.currency_code (string). | dimension · string | Ecommerce | |
| presentment money | subtotal_price_set.presentment_money | Documented on this resource as subtotal_price_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | subtotal_price_set.presentment_money.amount | Documented on this resource as subtotal_price_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| currency code | subtotal_price_set.presentment_money.currency_code | Documented on this resource as subtotal_price_set.presentment_money.currency_code (string). | dimension · string | Ecommerce | |
| price | tax_lines[].price | Documented on this resource as tax_lines[].price (string). | dimension · string | Ecommerce | |
| price set | tax_lines[].price_set | Documented on this resource as tax_lines[].price_set (object). | dimension · string | Ecommerce | |
| shop money | tax_lines[].price_set.shop_money | Documented on this resource as tax_lines[].price_set.shop_money (object). | dimension · string | Ecommerce | |
| presentment money | tax_lines[].price_set.presentment_money | Documented on this resource as tax_lines[].price_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | total_cash_rounding_payment_adjustment_set.shop_money.amount | Documented on this resource as total_cash_rounding_payment_adjustment_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| amount | total_cash_rounding_payment_adjustment_set.presentment_money.amount | Documented on this resource as total_cash_rounding_payment_adjustment_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| total cash rounding refund adjustment set | total_cash_rounding_refund_adjustment_set | Documented on this resource as total_cash_rounding_refund_adjustment_set (object). | dimension · string | Ecommerce | |
| shop money | total_cash_rounding_refund_adjustment_set.shop_money | Documented on this resource as total_cash_rounding_refund_adjustment_set.shop_money (object). | dimension · string | Ecommerce | |
| amount | total_cash_rounding_refund_adjustment_set.shop_money.amount | Documented on this resource as total_cash_rounding_refund_adjustment_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_cash_rounding_refund_adjustment_set.shop_money.currency_code | Documented on this resource as total_cash_rounding_refund_adjustment_set.shop_money.currency_code (string). | dimension · string | Ecommerce | |
| presentment money | total_cash_rounding_refund_adjustment_set.presentment_money | Documented on this resource as total_cash_rounding_refund_adjustment_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | total_cash_rounding_refund_adjustment_set.presentment_money.amount | Documented on this resource as total_cash_rounding_refund_adjustment_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_cash_rounding_refund_adjustment_set.presentment_money.currency_code | Documented on this resource as total_cash_rounding_refund_adjustment_set.presentment_money.currency_code (string). | dimension · string | Ecommerce | |
| amount | total_discounts_set.shop_money.amount | Documented on this resource as total_discounts_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| amount | total_discounts_set.presentment_money.amount | Documented on this resource as total_discounts_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| total line items price | total_line_items_price | Documented on this resource as total_line_items_price (string). | dimension · string | Ecommerce | |
| total line items price set | total_line_items_price_set | Documented on this resource as total_line_items_price_set (object). | dimension · string | Ecommerce | |
| shop money | total_line_items_price_set.shop_money | Documented on this resource as total_line_items_price_set.shop_money (object). | dimension · string | Ecommerce | |
| amount | total_line_items_price_set.shop_money.amount | Documented on this resource as total_line_items_price_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_line_items_price_set.shop_money.currency_code | Documented on this resource as total_line_items_price_set.shop_money.currency_code (string). | dimension · string | Ecommerce | |
| presentment money | total_line_items_price_set.presentment_money | Documented on this resource as total_line_items_price_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | total_line_items_price_set.presentment_money.amount | Documented on this resource as total_line_items_price_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_line_items_price_set.presentment_money.currency_code | Documented on this resource as total_line_items_price_set.presentment_money.currency_code (string). | dimension · string | Ecommerce | |
| total price | total_price | Documented on this resource as total_price (string). | dimension · string | Ecommerce | |
| total price set | total_price_set | Documented on this resource as total_price_set (object). | dimension · string | Ecommerce | |
| shop money | total_price_set.shop_money | Documented on this resource as total_price_set.shop_money (object). | dimension · string | Ecommerce | |
| amount | total_price_set.shop_money.amount | Documented on this resource as total_price_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_price_set.shop_money.currency_code | Documented on this resource as total_price_set.shop_money.currency_code (string). | dimension · string | Ecommerce | |
| presentment money | total_price_set.presentment_money | Documented on this resource as total_price_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | total_price_set.presentment_money.amount | Documented on this resource as total_price_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_price_set.presentment_money.currency_code | Documented on this resource as total_price_set.presentment_money.currency_code (string). | dimension · string | Ecommerce | |
| total shipping price set | total_shipping_price_set | Documented on this resource as total_shipping_price_set (object). | dimension · string | Ecommerce | |
| shop money | total_shipping_price_set.shop_money | Documented on this resource as total_shipping_price_set.shop_money (object). | dimension · string | Ecommerce | |
| amount | total_shipping_price_set.shop_money.amount | Documented on this resource as total_shipping_price_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_shipping_price_set.shop_money.currency_code | Documented on this resource as total_shipping_price_set.shop_money.currency_code (string). | dimension · string | Ecommerce | |
| presentment money | total_shipping_price_set.presentment_money | Documented on this resource as total_shipping_price_set.presentment_money (object). | dimension · string | Ecommerce | |
| amount | total_shipping_price_set.presentment_money.amount | Documented on this resource as total_shipping_price_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| currency code | total_shipping_price_set.presentment_money.currency_code | Documented on this resource as total_shipping_price_set.presentment_money.currency_code (string). | dimension · string | Ecommerce | |
| amount | total_tax_set.shop_money.amount | Documented on this resource as total_tax_set.shop_money.amount (string). | dimension · string | Ecommerce | |
| amount | total_tax_set.presentment_money.amount | Documented on this resource as total_tax_set.presentment_money.amount (string). | dimension · string | Ecommerce | |
| order id | fulfillments[].order_id | Documented on this resource as fulfillments[].order_id (integer). | metric · integer | Ecommerce | |
| line items | fulfillments[].line_items | Documented on this resource as fulfillments[].line_items (array). | dimension · string | Ecommerce | |
| line items | line_items | Documented on this resource as line_items (array). | dimension · string | Ecommerce | |
| id | line_items[].id | Documented on this resource as line_items[].id (integer). | metric · integer | Ecommerce | |
| admin graphql api id | line_items[].admin_graphql_api_id | Documented on this resource as line_items[].admin_graphql_api_id (string). | dimension · string | Ecommerce | |
| attributed staffs | line_items[].attributed_staffs | Documented on this resource as line_items[].attributed_staffs (array). | dimension · string | Ecommerce | |
| current quantity | line_items[].current_quantity | Documented on this resource as line_items[].current_quantity (integer). | metric · integer | Ecommerce | |
| fulfillable quantity | line_items[].fulfillable_quantity | Documented on this resource as line_items[].fulfillable_quantity (integer). | metric · integer | Ecommerce | |
| fulfillment service | line_items[].fulfillment_service | Documented on this resource as line_items[].fulfillment_service (string). | dimension · string | Ecommerce | |
| fulfillment status | line_items[].fulfillment_status | Documented on this resource as line_items[].fulfillment_status (string). | dimension · string | Ecommerce | |
| gift card | line_items[].gift_card | Documented on this resource as line_items[].gift_card (boolean). | dimension · boolean | Ecommerce | |
| grams | line_items[].grams | Documented on this resource as line_items[].grams (integer). | metric · integer | Ecommerce | |
| name | line_items[].name | Documented on this resource as line_items[].name (string). | dimension · string | Ecommerce | |
| price | line_items[].price | Documented on this resource as line_items[].price (string). | dimension · string | Ecommerce | |
| price set | line_items[].price_set | Documented on this resource as line_items[].price_set (object). | dimension · string | Ecommerce | |
| shop money | line_items[].price_set.shop_money | Documented on this resource as line_items[].price_set.shop_money (object). | dimension · string | Ecommerce | |
| presentment money | line_items[].price_set.presentment_money | Documented on this resource as line_items[].price_set.presentment_money (object). | dimension · string | Ecommerce | |
| product exists | line_items[].product_exists | Documented on this resource as line_items[].product_exists (boolean). | dimension · boolean | Ecommerce | |
| product id | line_items[].product_id | Documented on this resource as line_items[].product_id (integer). | metric · integer | Ecommerce | |
| properties | line_items[].properties | Documented on this resource as line_items[].properties (array). | dimension · string | Ecommerce | |
| quantity | line_items[].quantity | Documented on this resource as line_items[].quantity (integer). | metric · integer | Ecommerce | |
| requires shipping | line_items[].requires_shipping | Documented on this resource as line_items[].requires_shipping (boolean). | dimension · boolean | Ecommerce | |
| sku | line_items[].sku | Documented on this resource as line_items[].sku (string). | dimension · string | Ecommerce | |
| taxable | line_items[].taxable | Documented on this resource as line_items[].taxable (boolean). | dimension · boolean | Ecommerce | |
| title | line_items[].title | Documented on this resource as line_items[].title (string). | dimension · string | Ecommerce | |
| total discount | line_items[].total_discount | Documented on this resource as line_items[].total_discount (string). | dimension · string | Ecommerce | |
| total discount set | line_items[].total_discount_set | Documented on this resource as line_items[].total_discount_set (object). | dimension · string | Ecommerce | |
| shop money | line_items[].total_discount_set.shop_money | Documented on this resource as line_items[].total_discount_set.shop_money (object). | dimension · string | Ecommerce | |
| presentment money | line_items[].total_discount_set.presentment_money | Documented on this resource as line_items[].total_discount_set.presentment_money (object). | dimension · string | Ecommerce | |
| variant id | line_items[].variant_id | Documented on this resource as line_items[].variant_id (integer). | metric · integer | Ecommerce | |
| variant inventory management | line_items[].variant_inventory_management | Documented on this resource as line_items[].variant_inventory_management (string). | dimension · string | Ecommerce | |
| variant title | line_items[].variant_title | Documented on this resource as line_items[].variant_title (string). | dimension · string | Ecommerce | |
| vendor | line_items[].vendor | Documented on this resource as line_items[].vendor (string). | dimension · string | Ecommerce | |
| tax lines | line_items[].tax_lines | Documented on this resource as line_items[].tax_lines (array). | dimension · string | Ecommerce | |
| duties | line_items[].duties | Documented on this resource as line_items[].duties (array). | dimension · string | Ecommerce | |
| refunds | refunds | Documented on this resource as refunds (array). | dimension · string | Ecommerce | |
| id | refunds[].id | Documented on this resource as refunds[].id (integer). | metric · integer | Ecommerce | |
| admin graphql api id | refunds[].admin_graphql_api_id | Documented on this resource as refunds[].admin_graphql_api_id (string). | dimension · string | Ecommerce | |
| created at · Synced today | refunds[].created_at | Documented on this resource as refunds[].created_at (string). | dimension · string | Ecommerce | |
| note | refunds[].note | Documented on this resource as refunds[].note (string). | dimension · string | Ecommerce | |
| order id | refunds[].order_id | Documented on this resource as refunds[].order_id (integer). | metric · integer | Ecommerce | |
| processed at | refunds[].processed_at | Documented on this resource as refunds[].processed_at (string). | dimension · string | Ecommerce | |
| restock | refunds[].restock | Documented on this resource as refunds[].restock (boolean). | dimension · boolean | Ecommerce | |
| total additional fees set | refunds[].total_additional_fees_set | Documented on this resource as refunds[].total_additional_fees_set (object). | dimension · string | Ecommerce | |
| shop money | refunds[].total_additional_fees_set.shop_money | Documented on this resource as refunds[].total_additional_fees_set.shop_money (object). | dimension · string | Ecommerce | |
| presentment money | refunds[].total_additional_fees_set.presentment_money | Documented on this resource as refunds[].total_additional_fees_set.presentment_money (object). | dimension · string | Ecommerce | |
| total duties set | refunds[].total_duties_set | Documented on this resource as refunds[].total_duties_set (object). | dimension · string | Ecommerce | |
| shop money | refunds[].total_duties_set.shop_money | Documented on this resource as refunds[].total_duties_set.shop_money (object). | dimension · string | Ecommerce | |
| presentment money | refunds[].total_duties_set.presentment_money | Documented on this resource as refunds[].total_duties_set.presentment_money (object). | dimension · string | Ecommerce | |
| user id | refunds[].user_id | Documented on this resource as refunds[].user_id (string). | dimension · string | Ecommerce | |
| order adjustments | refunds[].order_adjustments | Documented on this resource as refunds[].order_adjustments (array). | dimension · string | Ecommerce | |
| transactions | refunds[].transactions | Documented on this resource as refunds[].transactions (array). | dimension · string | Ecommerce | |
| refund line items | refunds[].refund_line_items | Documented on this resource as refunds[].refund_line_items (array). | dimension · string | Ecommerce | |
| duties | refunds[].duties | Documented on this resource as refunds[].duties (array). | dimension · string | Ecommerce | |
| additional fees | refunds[].additional_fees | Documented on this resource as refunds[].additional_fees (array). | dimension · string | Ecommerce | |
| discounted price | shipping_lines[].discounted_price | Documented on this resource as shipping_lines[].discounted_price (string). | dimension · string | Ecommerce | |
| discounted price set | shipping_lines[].discounted_price_set | Documented on this resource as shipping_lines[].discounted_price_set (object). | dimension · string | Ecommerce | |
| shop money | shipping_lines[].discounted_price_set.shop_money | Documented on this resource as shipping_lines[].discounted_price_set.shop_money (object). | dimension · string | Ecommerce | |
| presentment money | shipping_lines[].discounted_price_set.presentment_money | Documented on this resource as shipping_lines[].discounted_price_set.presentment_money (object). | dimension · string | Ecommerce | |
| price | shipping_lines[].price | Documented on this resource as shipping_lines[].price (string). | dimension · string | Ecommerce | |
| price set | shipping_lines[].price_set | Documented on this resource as shipping_lines[].price_set (object). | dimension · string | Ecommerce | |
| shop money | shipping_lines[].price_set.shop_money | Documented on this resource as shipping_lines[].price_set.shop_money (object). | dimension · string | Ecommerce | |
| presentment money | shipping_lines[].price_set.presentment_money | Documented on this resource as shipping_lines[].price_set.presentment_money (object). | dimension · string | Ecommerce |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| presentment money | current_total_discounts_set.presentment_money | Documented on this resource as current_total_discounts_set.presentment_money (object). | dimension · string | Engagement | |
| currency code | current_total_discounts_set.presentment_money.currency_code | Documented on this resource as current_total_discounts_set.presentment_money.currency_code (string). | dimension · string | Engagement | |
| presentment money | current_total_tax_set.presentment_money | Documented on this resource as current_total_tax_set.presentment_money (object). | dimension · string | Engagement | |
| currency code | current_total_tax_set.presentment_money.currency_code | Documented on this resource as current_total_tax_set.presentment_money.currency_code (string). | dimension · string | Engagement | |
| presentment currency | presentment_currency | Documented on this resource as presentment_currency (string). | dimension · string | Engagement | |
| presentment money | total_cash_rounding_payment_adjustment_set.presentment_money | Documented on this resource as total_cash_rounding_payment_adjustment_set.presentment_money (object). | dimension · string | Engagement | |
| currency code | total_cash_rounding_payment_adjustment_set.presentment_money.currency_code | Documented on this resource as total_cash_rounding_payment_adjustment_set.presentment_money.currency_code (string). | dimension · string | Engagement | |
| presentment money | total_discounts_set.presentment_money | Documented on this resource as total_discounts_set.presentment_money (object). | dimension · string | Engagement | |
| currency code | total_discounts_set.presentment_money.currency_code | Documented on this resource as total_discounts_set.presentment_money.currency_code (string). | dimension · string | Engagement | |
| presentment money | total_tax_set.presentment_money | Documented on this resource as total_tax_set.presentment_money (object). | dimension · string | Engagement | |
| currency code | total_tax_set.presentment_money.currency_code | Documented on this resource as total_tax_set.presentment_money.currency_code (string). | dimension · string | Engagement | |
| email marketing consent | customer.email_marketing_consent | Documented on this resource as customer.email_marketing_consent (object). | dimension · string | Engagement | |
| state | customer.email_marketing_consent.state | Documented on this resource as customer.email_marketing_consent.state (string). | dimension · string | Engagement | |
| opt in level | customer.email_marketing_consent.opt_in_level | Documented on this resource as customer.email_marketing_consent.opt_in_level (string). | dimension · string | Engagement | |
| sms marketing consent | customer.sms_marketing_consent | Documented on this resource as customer.sms_marketing_consent (object). | dimension · string | Engagement | |
| state | customer.sms_marketing_consent.state | Documented on this resource as customer.sms_marketing_consent.state (string). | dimension · string | Engagement | |
| opt in level | customer.sms_marketing_consent.opt_in_level | Documented on this resource as customer.sms_marketing_consent.opt_in_level (string). | dimension · string | Engagement | |
| consent collected from | customer.sms_marketing_consent.consent_collected_from | Documented on this resource as customer.sms_marketing_consent.consent_collected_from (string). | dimension · string | Engagement |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| location id | location_id | Documented on this resource as location_id (string). | dimension · string | Geography | |
| city | billing_address.city | Documented on this resource as billing_address.city (string). | dimension · string | Geography | |
| country · Synced today | billing_address.country | Documented on this resource as billing_address.country (string). | dimension · string | Geography | |
| country code | billing_address.country_code | Documented on this resource as billing_address.country_code (string). | dimension · string | Geography | |
| city | customer.default_address.city | Documented on this resource as customer.default_address.city (string). | dimension · string | Geography | |
| country · Synced today | customer.default_address.country | Documented on this resource as customer.default_address.country (string). | dimension · string | Geography | |
| country code | customer.default_address.country_code | Documented on this resource as customer.default_address.country_code (string). | dimension · string | Geography | |
| country name | customer.default_address.country_name | Documented on this resource as customer.default_address.country_name (string). | dimension · string | Geography | |
| allocation method | discount_applications[].allocation_method | Documented on this resource as discount_applications[].allocation_method (string). | dimension · string | Geography | |
| location id | fulfillments[].location_id | Documented on this resource as fulfillments[].location_id (integer). | metric · integer | Geography | |
| discount allocations | line_items[].discount_allocations | Documented on this resource as line_items[].discount_allocations (array). | dimension · string | Geography | |
| city | shipping_address.city | Documented on this resource as shipping_address.city (string). | dimension · string | Geography | |
| country · Synced today | shipping_address.country | Documented on this resource as shipping_address.country (string). | dimension · string | Geography | |
| country code | shipping_address.country_code | Documented on this resource as shipping_address.country_code (string). | dimension · string | Geography | |
| discount allocations | shipping_lines[].discount_allocations | Documented on this resource as shipping_lines[].discount_allocations (array). | dimension · string | Geography |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| id | id | Documented on this resource as id (integer). | metric · integer | Metrics | |
| number | number | Documented on this resource as number (integer). | metric · integer | Metrics | |
| rate | tax_lines[].rate | Documented on this resource as tax_lines[].rate (number). | metric · number | Metrics | |
| total weight | total_weight | Documented on this resource as total_weight (integer). | metric · integer | Metrics | |
| latitude | billing_address.latitude | Documented on this resource as billing_address.latitude (number). | metric · number | Metrics | |
| longitude | billing_address.longitude | Documented on this resource as billing_address.longitude (number). | metric · number | Metrics | |
| id | customer.id | Documented on this resource as customer.id (integer). | metric · integer | Metrics | |
| id | customer.default_address.id | Documented on this resource as customer.default_address.id (integer). | metric · integer | Metrics | |
| customer id | customer.default_address.customer_id | Documented on this resource as customer.default_address.customer_id (integer). | metric · integer | Metrics | |
| id | fulfillments[].id | Documented on this resource as fulfillments[].id (integer). | metric · integer | Metrics | |
| latitude | shipping_address.latitude | Documented on this resource as shipping_address.latitude (number). | metric · number | Metrics | |
| longitude | shipping_address.longitude | Documented on this resource as shipping_address.longitude (number). | metric · number | Metrics | |
| id | shipping_lines[].id | Documented on this resource as shipping_lines[].id (integer). | metric · integer | Metrics |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| browser ip | browser_ip | Documented on this resource as browser_ip (string). | dimension · string | Technology | |
| accept language | client_details.accept_language | Documented on this resource as client_details.accept_language (string). | dimension · string | Technology | |
| browser height | client_details.browser_height | Documented on this resource as client_details.browser_height (string). | dimension · string | Technology | |
| browser ip | client_details.browser_ip | Documented on this resource as client_details.browser_ip (string). | dimension · string | Technology | |
| browser width | client_details.browser_width | Documented on this resource as client_details.browser_width (string). | dimension · string | Technology | |
| closed at | closed_at | Documented on this resource as closed_at (string). | dimension · string | Technology | |
| device id | device_id | Documented on this resource as device_id (string). | dimension · string | Technology |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| updated at | updated_at | Documented on this resource as updated_at (string). | dimension · string | Time | |
| updated at | customer.updated_at | Documented on this resource as customer.updated_at (string). | dimension · string | Time | |
| consent updated at | customer.email_marketing_consent.consent_updated_at | Documented on this resource as customer.email_marketing_consent.consent_updated_at (string). | dimension · string | Time | |
| consent updated at | customer.sms_marketing_consent.consent_updated_at | Documented on this resource as customer.sms_marketing_consent.consent_updated_at (string). | dimension · string | Time | |
| updated at | fulfillments[].updated_at | Documented on this resource as fulfillments[].updated_at (string). | dimension · string | Time |
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| referring site | referring_site | Documented on this resource as referring_site (string). | dimension · string | Traffic | |
| source identifier | source_identifier | Documented on this resource as source_identifier (string). | dimension · string | Traffic | |
| source name | source_name | Documented on this resource as source_name (string). | dimension · string | Traffic | |
| source url | source_url | Documented on this resource as source_url (string). | dimension · string | Traffic | |
| channel liable | tax_lines[].channel_liable | Documented on this resource as tax_lines[].channel_liable (string). | dimension · string | Traffic | |
| source | shipping_lines[].source | Documented on this resource as shipping_lines[].source (string). | dimension · string | Traffic |
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
A Shopify report of orders.
A sheet you can open, share, and refresh.
Included on every plan.
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
A warehouse table for the same columns.
Pro and Agency plans.
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Download the rows as CSV or JSON from the report.
Included on every plan.
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
Live with a custom app admin token from your own store. Orders and products work. Protected customer data stays empty until Shopify approves that access.
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.