PrestaShop fields

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

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

16 metrics49 dimensions

CUSTOMER

customer_id
Field label Customer ID
Description The unique identifier for the customer
Field type dimension
Data type string.text.value
customer_firstname
Field label Customer first name
Description The first name of the customer
Field type dimension
Data type string.text.value
customer_lastname
Field label Customer last name
Description The last name of the customer
Field type dimension
Data type string.text.value
customer_email
Field label Customer email
Description The email address of the customer
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

ORDER

order_id
Field label Order ID
Description The unique identifier for the order
Field type dimension
Data type string.text.value
carrier_id
Field label Carrier ID
Description The unique identifier for the shipping carrier
Field type dimension
Data type string.text.value
current_state
Field label Order current state
Description The current status of the order
Field type dimension
Data type string.text.value
invoice_number
Field label Order invoice number
Description The unique number assigned to the invoice
Field type dimension
Data type string.text.value
shipping_number
Field label Order shipping number
Description The tracking number provided by the shipping carrier
Field type dimension
Data type string.text.value
note
Field label Order note
Description Any additional notes or comments related to the order
Field type dimension
Data type string.text.value
payment
Field label Order payment
Description The method of payment used for the order
Field type dimension
Data type string.text.value
reference
Field label Order reference
Description The order reference number
Field type dimension
Data type string.text.value
currency
Field label Order currency
Description ISO 4217 code (e.g. USD for Dollars, EUR for Euros, etc.)
Field type dimension
Data type string.currency.code
carrier_tax_rate
Field label Order carrier tax rate
Description The tax rate applied by the shipping carrier
Field type dimension
Data type float.number.percentage
total_products
Field label Total products
Description The total cost of the products in the order. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_products_with_tax
Field label Total products (with tax)
Description The total cost of the products in the order, including applicable taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_shipping
Field label Total shipping
Description The total cost of shipping for the order. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_shipping_tax_included
Field label Total shipping (tax included)
Description The total cost of shipping for the order, including applicable taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_shipping_tax_excluded
Field label Total shipping (tax excluded)
Description The total cost of shipping for the order, excluding taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_wrapping
Field label Total wrapping
Description The total cost of gift wrapping for the order. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_wrapping_tax_included
Field label Total wrapping (tax included)
Description The total cost of gift wrapping for the order, including applicable taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_wrapping_tax_excluded
Field label Total wrapping (tax excluded)
Description The total cost of gift wrapping for the order, excluding taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_discounts
Field label Total discounts
Description The total amount of discounts applied to the order. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_discounts_tax_included
Field label Total discounts (tax included)
Description The total amount of discounts applied to the order, including applicable taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_discounts_tax_excluded
Field label Total discounts (tax excluded)
Description The total amount of discounts applied to the order, excluding taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_paid
Field label Total paid
Description The total amount paid by the customer for the order. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_paid_tax_included
Field label Total paid (tax included)
Description The total amount paid by the customer, including all applicable taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_paid_tax_excluded
Field label Total paid (tax excluded)
Description The total amount paid by the customer, excluding any taxes. This value is returned in the order's currency
Field type metric
Data type float.currency.value
total_paid_real
Field label Total paid real
Description The actual total amount received for the order. This value is returned in the order's currency
Field type metric
Data type float.currency.value
orders
Field label Orders
Description The number of orders for selected date range
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

STORE

store_name
Field label Store name
Description The name of the store
Field type dimension
Data type string.text.value
store_id
Field label Store ID
Description The unique identifier for the store
Field type dimension
Data type string.text.value
store_group_id
Field label Store group ID
Description The unique identifier for the store group this store belongs to
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
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 initially 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 initially 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
order_invoice_date
Field label Order invoice date
Description The date when the invoice was issued
Field type dimension
Data type string.time.date
order_invoice_datetime
Field label Order invoice datetime
Description The date and time when the invoice was issued
Field type dimension
Data type string.time.datetime