BigCommerce fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

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

33 metrics70 dimensions

BILLING

billing_first_name
Field label Billing first name
Description First name of the billing address
Field type dimension
Data type string.text.value
billing_last_name
Field label Billing last name
Description Last name of the billing address
Field type dimension
Data type string.text.value
billing_company
Field label Billing company
Description Company name of the billing address
Field type dimension
Data type string.text.value
billing_street_1
Field label Billing street 1
Description Street address of the billing address
Field type dimension
Data type string.geo.street
billing_street_2
Field label Billing street 2
Description Additional street address of the billing address
Field type dimension
Data type string.geo.street
billing_city
Field label Billing city
Description City of the billing address
Field type dimension
Data type string.geo.city
billing_state
Field label Billing state
Description State/province of the billing address
Field type dimension
Data type string.geo.region
billing_zip
Field label Billing zip
Description Zip/postal code of the billing address
Field type dimension
Data type string.geo.zip
billing_country
Field label Billing country
Description Country of the billing address
Field type dimension
Data type string.geo.country
billing_country_iso2
Field label Billing country (ISO2)
Description ISO 2-letter code for the billing country
Field type dimension
Data type string.geo.country.twolettercode
billing_phone
Field label Billing phone
Description Phone number of the billing address
Field type dimension
Data type string.text.phone
billing_email
Field label Billing email
Description Email address of the billing address
Field type dimension
Data type string.text.email

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

DISCOUNT

store_credit
Field label Store credit
Description The store credit that the shopper has redeemed on this individual order
Field type metric
Data type float.currency.value
gift_certificate
Field label Gift certificate
Description The gift certificate that the shopper has redeemed on this individual order
Field type metric
Data type float.currency.value
coupon
Field label Coupon
Description The coupon amount that the shopper has redeemed on this individual order
Field type metric
Data type float.currency.value
refunded_amount
Field label Refunded amount
Description The amount refunded from this transaction
Field type metric
Data type float.currency.value

EXCLUDING TAX

subtotal_ex_tax
Field label Subtotal (ex tax)
Description The value of subtotal, excluding tax
Field type metric
Data type float.currency.value
shipping_ex_tax
Field label Shipping (ex tax)
Description The value of shipping cost, excluding tax
Field type metric
Data type float.currency.value
handling_ex_tax
Field label Handling (ex tax)
Description The value of the handling cost, excluding tax
Field type metric
Data type float.currency.value
wrapping_ex_tax
Field label Wrapping (ex tax)
Description The value of the wrapping cost, excluding tax
Field type metric
Data type float.currency.value
total_ex_taxes
Field label Total (ex tax)
Description The value of the order, excluding tax
Field type metric
Data type float.currency.value

ITEMS

items_total
Field label Items total
Description The total number of items in the order
Field type metric
Data type int.number.value
items_shipped
Field label Items shipped
Description The number of items that have been shipped
Field type metric
Data type int.number.value

ORDER

order_id
Field label Order ID
Description Unique identifier for the order
Field type dimension
Data type string.text.value
customer_id
Field label Customer ID
Description Unique identifier for the customer
Field type dimension
Data type string.text.value
status_id
Field label Status ID
Description The status ID of the order
Field type dimension
Data type string.text.value
status
Field label Status
Description Current status of the order
Field type dimension
Data type string.text.value
custom_status
Field label Custom status
Description Custom status of the order
Field type dimension
Data type string.text.value
customer_message
Field label Customer message
Description Message that the customer entered
Field type dimension
Data type string.text.value
order_is_digital
Field label Order is digital
Description Whether this is an order for digital products
Field type dimension
Data type bool
ip_address
Field label IP address
Description IPv4 Address of the customer, if known
Field type dimension
Data type string.text.value
ip_address_v6
Field label IP address v6
Description IPv6 Address of the customer, if known
Field type dimension
Data type string.text.value
geoip_country
Field label GeoIP country
Description The full name of the country where the customer made the purchase, based on the IP
Field type dimension
Data type string.geo.country
geoip_country_iso2
Field label GeoIP country (ISO2)
Description The country where the customer made the purchase, in ISO2 format, based on the IP
Field type dimension
Data type string.geo.country.twolettercode
order_source
Field label Order source
Description Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing
Field type dimension
Data type string.text.value
channel_id
Field label Channel ID
Description Shows where the order originated
Field type dimension
Data type string.text.value
external_id
Field label External ID
Description The order ID in another system, such as the Amazon order ID if this is an Amazon order
Field type dimension
Data type string.text.value
orders
Field label Orders
Description Number of orders
Field type metric
Data type int.number.value
subtotal
Field label Subtotal
Description The value of subtotal including tax
Field type metric
Data type float.currency.value
discount_amount
Field label Discount
Description Amount of discount for this transaction
Field type metric
Data type float.currency.value
shipping
Field label Shipping
Description The value of shipping cost, including tax
Field type metric
Data type float.currency.value
handling
Field label Handling
Description The value of the handling cost, including tax
Field type metric
Data type float.currency.value
wrapping
Field label Wrapping
Description The value of the wrapping cost, including tax
Field type metric
Data type float.currency.value
total
Field label Total
Description Total value of the order including tax
Field type metric
Data type float.currency.value

PAYMENT

payment_method
Field label Payment method
Description The payment method for this order
Field type dimension
Data type string.text.value
payment_provider_id
Field label Payment provider ID
Description The external transaction ID/payment ID within this order’s payment provider
Field type dimension
Data type string.text.value
payment_status
Field label Payment status
Description Status of the payment
Field type dimension
Data type string.text.value
currency_id
Field label Currency ID
Description The active currency ID
Field type dimension
Data type string.text.value
currency_code
Field label Currency code
Description The currency code associated with the price record being acted upon
Field type dimension
Data type string.currency.code

PRODUCT

product_id
Field label Product ID
Description Numeric ID of the product
Field type dimension
Data type string.text.value
product_name
Field label Product name
Description Name of the product
Field type dimension
Data type string.text.value
sku
Field label SKU
Description User-defined product code/stock keeping unit (SKU)
Field type dimension
Data type string.text.value
upc
Field label UPC
Description Universal product code. Can be written to for custom products and catalog products
Field type dimension
Data type string.text.value
type
Field label Type
Description Type of product
Field type dimension
Data type string.text.value
brand
Field label Brand
Description The products brand
Field type dimension
Data type string.text.value
quantity
Field label Quantity
Description Quantity of the product ordered
Field type metric
Data type int.number.value
quantity_refunded
Field label Quantity refunded
Description The total quantity of product refunded from this transaction
Field type metric
Data type int.number.value
price_base
Field label Price (base)
Description The product’s cost price
Field type metric
Data type float.currency.value
price_ex_tax
Field label Price (ex tax)
Description The product cost price excluding tax
Field type metric
Data type float.currency.value
price_inc_tax
Field label Price (inc tax)
Description The product’s cost price including tax
Field type metric
Data type float.currency.value
price_tax
Field label Price tax
Description The product cost price excluding tax
Field type metric
Data type float.currency.value
total_base
Field label Total (base)
Description Total base price
Field type metric
Data type float.currency.value
total_ex_tax
Field label Total (ex tax)
Description Total base price excluding tax
Field type metric
Data type float.currency.value
total_inc_tax
Field label Total (inc tax)
Description Total base price including tax
Field type metric
Data type float.currency.value
total_tax
Field label Total tax
Description Total tax applied to products
Field type metric
Data type float.currency.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

STORE

store_hash
Field label Store hash
Description The name of the store
Field type dimension
Data type string.text.value

TAX

shipping_tax
Field label Shipping tax
Description Tax amount for shipping
Field type metric
Data type float.currency.value
handling_tax
Field label Handling tax
Description Tax amount for handling
Field type metric
Data type float.currency.value
wrapping_tax
Field label Wrapping tax
Description Tax amount for wrapping
Field type metric
Data type float.currency.value
subtotal_tax
Field label Subtotal tax
Description Tax amount for the subtotal
Field type metric
Data type float.currency.value
total_taxes
Field label Total tax
Description Total tax amount for the order
Field type metric
Data type float.currency.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
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

created_date
Field label Created date
Description Date the order was created
Field type dimension
Data type string.time.date
created_datetime
Field label Created datetime
Description Date and time the order was created
Field type dimension
Data type string.time.datetime
modified_date
Field label Modified date
Description Date the order was last modified
Field type dimension
Data type string.time.date
modified_datetime
Field label Modified datetime
Description Date and time the order was last modified
Field type dimension
Data type string.time.datetime
shipped_date
Field label Shipped date
Description Date the order was shipped
Field type dimension
Data type string.time.date
shipped_datetime
Field label Shipped datetime
Description Date and time the order was shipped
Field type dimension
Data type string.time.datetime