Wix Commerce fields

  • Updated on Oct 6, 2025
  • Published on Aug 18, 2025
Prev Next

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

Early Access9 metrics48 dimensions

BILLING

billing_first_name
Field label Billing first name
Description The first name for billing
Field type dimension
Data type string.text.value
billing_last_name
Field label Billing last name
Description The last name for billing
Field type dimension
Data type string.text.value
billing_address_line
Field label Billing address line
Description The address line for billing
Field type dimension
Data type string.text.value
billing_city
Field label Billing city
Description The city for billing
Field type dimension
Data type string.geo.city
billing_country
Field label Billing country
Description The country for billing
Field type dimension
Data type string.geo.country
billing_postal_code
Field label Billing postal code
Description The postal code for billing
Field type dimension
Data type string.geo.zip
billing_phone
Field label Billing phone
Description The phone number for billing
Field type dimension
Data type string.text.phone

BUYER

buyer_email
Field label Buyer email
Description Email of the buyer
Field type dimension
Data type string.text.email
buyer_id
Field label Buyer ID
Description ID of the buyer
Field type dimension
Data type string.text.value

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

ORDER

order_id
Field label Order ID
Description A unique identifier for the order
Field type dimension
Data type string.text.value
order_number
Field label Order number
Description Number of the order
Field type dimension
Data type string.text.value
order_status
Field label Order status
Description The current status of the order (e.g., pending, processing, completed)
Field type dimension
Data type string.text.value
order_payment_status
Field label Order payment status
Description Order payment status
Field type dimension
Data type string.text.value
order_fulfillment_status
Field label Order fulfillment status
Description Order fulfillment status
Field type dimension
Data type string.text.value
order_currency
Field label Order currency
Description The currency used for the order transaction
Field type dimension
Data type string.currency.code
subtotal
Field label Subtotal
Description The subtotal amount in order currency
Field type metric
Data type float.currency.value
shipping
Field label Shipping
Description Shipping costs in order currency
Field type metric
Data type float.currency.value
tax
Field label Tax
Description The tax amount in order currency
Field type metric
Data type float.currency.value
discount
Field label Discount
Description The discount amount in order currency
Field type metric
Data type float.currency.value
total
Field label Total
Description The total amount in order currency
Field type metric
Data type float.currency.value
total_with_gift_card
Field label Total with gift card
Description The total amount with a gift card applied in order currency
Field type metric
Data type float.currency.value
total_without_gift_card
Field label Total without gift card
Description The total amount without a gift card applied in order currency
Field type metric
Data type float.currency.value
total_additional_fees
Field label Total additional fees
Description The additional fees in order currency
Field type metric
Data type float.currency.value
orders
Field label Orders
Description The total number of orders placed in order currency
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

SITE

site_name
Field label Site name
Description The name of the site from which the order was placed
Field type dimension
Data type string.text.value
site_id
Field label Site ID
Description A unique identifier for the site
Field type dimension
Data type string.text.value
site_url
Field label Site URL
Description URL of the site
Field type dimension
Data type string.text.url

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
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
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
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
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
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TIMESTAMP

order_created_date
Field label Order created date
Description The date when the order was created
Field type dimension
Data type string.time.date
order_created_datetime
Field label Order created datetime
Description The date and time when the order was created
Field type dimension
Data type string.time.datetime
order_updated_date
Field label Order updated date
Description The date when the order was last updated
Field type dimension
Data type string.time.date
order_updated_datetime
Field label Order updated datetime
Description The date and time when the order was last updated
Field type dimension
Data type string.time.datetime