Shopware fields

  • Updated on Nov 20, 2025
  • Published on Nov 20, 2025
Prev Next

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

Early Access10 metrics66 dimensions

BILLING

billing_address
Field label Billing address
Description Complete billing address
Field type dimension
Data type string.text.value
billing_country
Field label Billing country
Description Billing address country name
Field type dimension
Data type string.geo.country
billing_country_code
Field label Billing country code
Description Billing address country code
Field type dimension
Data type string.geo.country.twolettercode
billing_city
Field label Billing city
Description Billing address city
Field type dimension
Data type string.geo.city

CUSTOMER

customer_id
Field label Customer ID
Description Unique identifier of the customer
Field type dimension
Data type string.text.value
customer_number
Field label Customer number
Description Customer number
Field type dimension
Data type string.text.value
customer_first_name
Field label Customer first name
Description First name of the customer
Field type dimension
Data type string.text.value
customer_last_name
Field label Customer last name
Description Last name of the customer
Field type dimension
Data type string.text.value
customer_email
Field label Customer email
Description Email address of the customer
Field type dimension
Data type string.text.email
customer_company
Field label Customer company
Description Company name of the customer
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

ITEM

item_id
Field label Item ID
Description Unique identifier of the line item
Field type dimension
Data type string.text.value
item_name
Field label Item name
Description Name/label of the line item
Field type dimension
Data type string.text.value
product_number
Field label Product number
Description Product number/SKU
Field type dimension
Data type string.text.value
product_id
Field label Product ID
Description Unique identifier 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
product_ean
Field label Product EAN
Description EAN code of the product
Field type dimension
Data type string.text.value
total_price
Field label Total price
Description Total price of the line item
Field type metric
Data type float.currency.value
unit_price
Field label Unit price
Description Unit price of the line item
Field type metric
Data type float.currency.value
item_tax
Field label Tax
Description Tax amount for the line item
Field type metric
Data type float.currency.value
quantity
Field label Quantity
Description Quantity of items ordered
Field type metric
Data type int.number.value

ORDER

order_id
Field label Order ID
Description Unique identifier of the order
Field type dimension
Data type string.text.value
order_number
Field label Order number
Description Human-readable order number
Field type dimension
Data type string.text.value
order_status
Field label Order status
Description Current status of the order
Field type dimension
Data type string.text.value
payment_status
Field label Payment status
Description Payment status of the order
Field type dimension
Data type string.text.value
delivery_status
Field label Delivery status
Description Delivery status of the order
Field type dimension
Data type string.text.value
currency
Field label Currency
Description Currency code of the order
Field type dimension
Data type string.currency.code
affiliate_code
Field label Affiliate code
Description Affiliate tracking code
Field type dimension
Data type string.text.value
campaign_code
Field label Campaign code
Description Campaign tracking code
Field type dimension
Data type string.text.value
promotion_code
Field label Promotion code
Description Promotion ID applied to the line items
Field type dimension
Data type string.text.value
total_gross
Field label Total (gross)
Description Total order value including tax
Field type metric
Data type float.currency.value
total_net
Field label Total (net)
Description Total order value excluding tax
Field type metric
Data type float.currency.value
position_price
Field label Position price
Description Total price of all line items
Field type metric
Data type float.currency.value
shipping_total
Field label Shipping total
Description Total shipping costs
Field type metric
Data type float.currency.value
order_tax
Field label Tax
Description Total tax amount
Field type metric
Data type float.currency.value
orders
Field label Orders
Description Number of orders
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 CHANNEL

sales_channel_name
Field label Sales channel name
Description Name of the sales channel
Field type dimension
Data type string.text.value
sales_channel_id
Field label Sales channel ID
Description ID of the sales channel
Field type dimension
Data type string.text.value
sales_channel_url
Field label Sales channel URL
Description URL of the sales channel
Field type dimension
Data type string.text.value

SHIPPING

shipping_address
Field label Shipping address
Description Complete shipping address
Field type dimension
Data type string.text.value
shipping_country
Field label Shipping country
Description Shipping address country name
Field type dimension
Data type string.geo.country
shipping_country_code
Field label Shipping country code
Description Shipping address country code
Field type dimension
Data type string.geo.country.twolettercode
shipping_city
Field label Shipping city
Description Shipping address city
Field type dimension
Data type string.geo.city

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_date
Field label Order date
Description Date when the order was placed
Field type dimension
Data type string.time.date
order_datetime
Field label Order datetime
Description Date and time when the order was placed
Field type dimension
Data type string.time.datetime
order_created_date
Field label Order created date
Description Date when the order was created in the system
Field type dimension
Data type string.time.date
order_created_datetime
Field label Order created datetime
Description Date and time when the order was created in the system
Field type dimension
Data type string.time.datetime
order_modified_date
Field label Order modified date
Description Date when the order was last modified
Field type dimension
Data type string.time.date
order_modified_datetime
Field label Order modified datetime
Description Date and time when the order was last modified
Field type dimension
Data type string.time.datetime
item_created_date
Field label Item created date
Description Date when the line item was created
Field type dimension
Data type string.time.date
item_created_datetime
Field label Item created datetime
Description Date and time when the line item was created
Field type dimension
Data type string.time.datetime