Shopify fields

  • Updated on Oct 2, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Shopify data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

21 metrics114 dimensions

CUSTOMER

customer_count
Field label Customer count
Description The total count of the customers
Field type metric
Data type int.number.value

CUSTOMER DETAILS

customer_id
Field label Customer ID
Description The unique identifier of the customer
Field type dimension
Data type string.text.value
customer_first_name
Field label First name
Description The first name of the customer
Field type dimension
Data type string.text.value
customer_last_name
Field label Last name
Description The last name of the customer
Field type dimension
Data type string.text.value
customer_email
Field label Email
Description The email of the customer
Field type dimension
Data type string.text.email
customer_tags
Field label Customer tags
Description The email of the customer
Field type dimension
Data type string.text.json
customer_last_order_created_at
Field label Last order created datetime
Description The date and time the last order of the customer was created
Field type dimension
Data type string.time.datetime
customer_last_order_created_at_iso
Field label Last order created date (ISO)
Description The date and time the last order of the customer was created in ISO format
Field type dimension
Data type string.time.datetime
Destinations Data warehouse
customer_last_order_created_at_date
Field label Last order created date
Description The date the last order of the customer was created
Field type dimension
Data type string.time.date
customer_lifetime_duration
Field label Account age in days
Description The amount of days since the customer was first added to the online store
Field type dimension
Data type string.text.value
customer_created_at
Field label Account created datetime
Description The date and time the customer was added to the online store
Field type dimension
Data type string.time.datetime
customer_created_at_iso
Field label Account created time (ISO)
Description The date and time the customer was added to the online store in ISO format
Field type dimension
Data type string.time.datetime
Destinations Data warehouse
customer_created_at_date
Field label Account created date
Description The date the customer was added to the online store
Field type dimension
Data type string.time.date
customer_notes
Field label Customer notes
Description Note about the customer
Field type dimension
Data type string.text.value

CUSTOMER GEO

customer_country
Field label Country
Description The country of the customer
Field type dimension
Data type string.geo.country
customer_country_code
Field label Country code
Description The country code of the customer
Field type dimension
Data type string.geo.country.twolettercode
customer_city
Field label City
Description The city of the customer
Field type dimension
Data type string.geo.city

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEPRECATED

items
Field label Items
Description The amount of the line item.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2025-01-30
avg_items
Field label Avg. number of items
Description The average number of sold items. Order adjustments and shipping is not calculated towards this metric.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2025-01-30

INVENTORY ITEM

inventory_item_cost_per_item
Field label Cost per item
Description Cost of the inventory item
Field type dimension
Data type float.currency.value
cost_of_goods_sold
Field label Cost of goods sold
Description The total cost of all the units of goods sold
Field type metric
Data type float.currency.value
gross_profit
Field label Gross profit
Description The total profit made calculated by subtracting the cost from net sales
Field type metric
Data type float.currency.value

LINE ITEM

line_item_id
Field label Line item ID
Description ID of the line item row
Field type dimension
Data type string.text.value
line_item_type
Field label Line item type
Description Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping"
Field type dimension
Data type string.text.value
line_item_properties
Field label Line item properties
Description An array of custom information for the line item in the order
Field type dimension
Data type string.text.json
line_item_fulfillment_date
Field label Line item fulfillment date
Description The date that the specific line item fulfillment was completed
Field type dimension
Data type string.time.datetime
line_item_is_gift_card
Field label Is gift card
Description Whether or not the line item is a gift card
Field type dimension
Data type bool

ORDER

order_id
Field label Order ID
Description The unique identifier of the order
Field type dimension
Data type string.text.value
order_name
Field label Order name
Description The name of the order
Field type dimension
Data type string.text.value
order_note
Field label Order note
Description The note on the order
Field type dimension
Data type string.text.value
order_tags
Field label Order tags
Description Tags attached to the order
Field type dimension
Data type string.text.value
order_financial_status
Field label Financial status
Description The status of payments associated with the order. Possible values include: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided
Field type dimension
Data type string.text.value
order_note_attributes
Field label Order note attributes
Description Extra information that is added to the order. Appears in the Additional details section of an order details page
Field type dimension
Data type string.text.json
order_created_at
Field label Order created datetime
Description The date and time the order was created
Field type dimension
Data type string.time.datetime
order_created_at_iso
Field label Order created time (ISO)
Description The date and time the order was created in ISO format
Field type dimension
Data type string.time.datetime
Destinations Data warehouse
order_created_at_date
Field label Order created date
Description The date the order was created
Field type dimension
Data type string.time.date
order_closed_at
Field label Order closed datetime
Description The date and time the order was closed
Field type dimension
Data type string.time.datetime
order_closed_at_iso
Field label Order closed time (ISO)
Description The date and time the order was closed in ISO format
Field type dimension
Data type string.time.datetime
Destinations Data warehouse
order_closed_at_date
Field label Order closed date
Description The date the order was closed
Field type dimension
Data type string.time.date
order_cancelled_at
Field label Order cancelled datetime
Description The date and time of the order cancellation
Field type dimension
Data type string.time.datetime
order_cancelled_at_iso
Field label Order cancelled time (ISO)
Description The date and time when the order was cancelled in ISO format
Field type dimension
Data type string.time.datetime
Destinations Data warehouse
order_cancelled_at_date
Field label Order cancelled date
Description The date of the order cancellation
Field type dimension
Data type string.time.date
order_shipping_address1
Field label Shipping address 1
Description The street address of the shipping address
Field type dimension
Data type string.text.value
order_shipping_address2
Field label Shipping address 2
Description An optional additional field for the street address of the shipping address
Field type dimension
Data type string.text.value
order_shipping_phone
Field label Shipping phone
Description The phone number at the shipping address
Field type dimension
Data type string.text.phone
order_shipping_post_code
Field label Shipping post code
Description The postal code (zip, postcode, Eircode, …) of the shipping address
Field type dimension
Data type string.geo.zip
order_shipping_city
Field label Shipping city
Description The city, town, or village of the shipping address
Field type dimension
Data type string.geo.city
order_shipping_province
Field label Shipping province
Description The name of the region (province, state, prefecture, …) of the shipping address
Field type dimension
Data type string.geo.region
order_shipping_country
Field label Shipping country
Description The name of the country of the shipping address
Field type dimension
Data type string.geo.country
order_billing_address1
Field label Billing address 1
Description The street address of the billing address
Field type dimension
Data type string.text.value
order_billing_address2
Field label Billing address 2
Description An optional additional field for the street address of the billing address
Field type dimension
Data type string.text.value
order_billing_phone
Field label Billing phone
Description The phone number at the billing address
Field type dimension
Data type string.text.phone
order_billing_post_code
Field label Billing post code
Description The postal code (for example, zip, postcode, or Eircode) of the billing address
Field type dimension
Data type string.geo.zip
order_billing_city
Field label Billing city
Description The city, town, or village of the billing address
Field type dimension
Data type string.geo.city
order_billing_province
Field label Billing province
Description The name of the region (for example, province, state, or prefecture) of the billing address
Field type dimension
Data type string.geo.region
order_billing_country
Field label Billing country
Description The name of the country of the billing address
Field type dimension
Data type string.geo.country
order_channel
Field label Channel
Description The sales channel of the order
Field type dimension
Data type string.text.value
order_channel_app_name
Field label Channel (App name)
Description The sales channel's app name of the order
Field type dimension
Data type string.text.value
order_confirmed
Field label Order confirmed
Description Whether inventory has been reserved for the order
Field type dimension
Data type bool
order_currency_code
Field label Currency
Description The currency code of the order
Field type dimension
Data type string.currency.code
order_email
Field label Order email
Description The email associated with the order
Field type dimension
Data type string.text.email
order_fully_paid
Field label Fully paid
Description Whether the order is fully paid or not
Field type dimension
Data type bool
order_discount_code
Field label Discount reason
Description The reason for the applied order's item-level discount
Field type dimension
Data type string.text.value
order_location
Field label Location name
Description The location name
Field type dimension
Data type string.text.value
order_shipping_description
Field label Shipping description
Description Description of the shipping selected for the order
Field type dimension
Data type string.text.value
order_is_returning_customer
Field label Is returning customer
Description Whether the customer is returning or not
Field type dimension
Data type bool
order_display_fulfillment_status
Field label Fulfillment status
Description Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked
Field type dimension
Data type string.text.value
order_fulfillment_date
Field label Fulfillment date
Description The date that the order fulfillment was completed
Field type dimension
Data type string.time.datetime
ordered_quantity
Field label Ordered quantity
Description Total number of items ordered. Calculated by Net quantity + Returned quantity
Field type metric
Data type int.number.value
returned_quantity
Field label Returned quantity
Description Total number of items returned
Field type metric
Data type int.number.value
net_quantity
Field label Net quantity
Description Net quantity of line items ordered. It shows number of sold items minus the number of returned items
Field type metric
Data type int.number.value
units_per_transaction
Field label Units per transaction
Description Average number of items per transaction. Calculated by Net quantity / Orders
Field type metric
Data type float.number.ratio
sm_order_count
Field label Orders
Description The amount of orders
Field type metric
Data type int.number.value
avg_total_sales
Field label Avg. order value
Description The average total sales
Field type metric
Data type float.currency.value

PRODUCT

sku
Field label SKU
Description Variant SKU number
Field type dimension
Data type string.text.value
product_id
Field label Product ID
Description The unique identifier of the product
Field type dimension
Data type string.text.value
variant_id
Field label Variant ID
Description The unique identifier of the product variant
Field type dimension
Data type string.text.value
title
Field label Product title
Description The title of the product
Field type dimension
Data type string.text.value
variant_title
Field label Variant title
Description The title of the product variant
Field type dimension
Data type string.text.value
product_tags
Field label Product tags
Description Tags attached to the product
Field type dimension
Data type string.text.value
product_status
Field label Product status
Description Status of the product, which determines if its ready to be sold. Possible values are ACTIVE, ARCHIVED, and DRAFT
Field type dimension
Data type string.text.value
price
Field label Price
Description The price of the product
Field type dimension
Data type float.currency.value
description
Field label Description
Description Description of the product
Field type dimension
Data type string.text.value
vendor
Field label Vendor
Description The vendor of the product
Field type dimension
Data type string.text.value
type
Field label Type
Description The type of the product
Field type dimension
Data type string.text.value
image_src
Field label Image URL
Description The image URL of the product
Field type dimension
Data type string.text.url
product_created_at
Field label Product created datetime
Description The date and time the product was created
Field type dimension
Data type string.time.datetime
product_created_at_iso
Field label Product created time (ISO)
Description The date and time the product was created in ISO format
Field type dimension
Data type string.time.datetime
Destinations Data warehouse
product_created_at_date
Field label Product created date
Description The date the product was created
Field type dimension
Data type string.time.date
product_inventory_value
Field label Inventory value
Description The sell value of the product inventory
Field type metric
Data type float.currency.value
product_inventory_quantity
Field label Inventory quantity
Description The product quantity in inventory
Field type metric
Data type int.number.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SALES

gross_sales
Field label Gross sales
Description The total price for the line item without any discounts applied
Field type metric
Data type float.currency.value
discounts
Field label Discounts
Description The total amount of discounts applied on the order
Field type metric
Data type float.currency.value
returns
Field label Returns
Description The total amount refunded for the order
Field type metric
Data type float.currency.value
net_sales
Field label Net sales
Description The net sales of the line
Field type metric
Data type float.currency.value
shipping
Field label Shipping
Description The total shipping amount including returns
Field type metric
Data type float.currency.value
tax
Field label Tax
Description The total amount of tax for the line. Takes returns into account
Field type metric
Data type float.currency.value
duties
Field label Duties
Description The total amount of duties based on the order
Field type metric
Data type float.currency.value
total_sales
Field label Total sales
Description The total sales for line
Field type metric
Data type float.currency.value

STORE

shop_id
Field label Store ID
Description The unique identifier of the store
Field type dimension
Data type string.text.value
shop_name
Field label Store name
Description The name of the store
Field type dimension
Data type string.text.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
yearOfWeek
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
yearOfWeekIso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
yearMonth
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
yearWeek
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
yearWeekIso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
weekIso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
dayOfMonth
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
dayOfWeekName
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
dayOfWeekNameIso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
hour
Field label Hour
Description Hour in a 24-hour clock, e.g. 18
Field type dimension
Data type string.time.hour

TRAFFIC SOURCE

order_landing_page_url
Field label Landing page URL
Description The URL of the landing page
Field type dimension
Data type string.text.url
order_referral_code
Field label Referral code
Description Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link
Field type dimension
Data type string.text.value
order_referrer_url
Field label Order referrer URL
Description The web page the customer clicked a link on that sent them to the online store that led to the order
Field type dimension
Data type string.text.url
order_utm_content
Field label UTM content
Description A/B testing and content-targeted ads to differentiate ads or links that point to the same URL
Field type dimension
Data type string.text.value
order_utm_term
Field label UTM term
Description The keywords associated with an ad
Field type dimension
Data type string.text.value
order_utm_medium
Field label UTM medium
Description The ad medium, such as email or cost-per-click (cpc)
Field type dimension
Data type string.text.value
order_utm_source
Field label UTM source
Description Identifies a search engine, a newsletter name, or other source
Field type dimension
Data type string.text.value
order_utm_name
Field label UTM campaign name
Description The name that you give a promotion or campaign to identify it
Field type dimension
Data type string.text.value