PrestaShop fields

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
customer_firstname
customer_lastname
customer_email

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

ORDER

order_id
carrier_id
current_state
invoice_number
shipping_number
note
payment
reference
currency
carrier_tax_rate
total_products
total_products_with_tax
total_shipping
total_shipping_tax_included
total_shipping_tax_excluded
total_wrapping
total_wrapping_tax_included
total_wrapping_tax_excluded
total_discounts
total_discounts_tax_included
total_discounts_tax_excluded
total_paid
total_paid_tax_included
total_paid_tax_excluded
total_paid_real
orders

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

STORE

store_name
store_id
store_group_id

TIME

today
year
year_of_week
year_of_week_iso
year_month
month
year_week
year_week_iso
week
week_iso
day_of_month
day_of_week_name
day_of_week_name_iso
date
atom

TIMESTAMP

order_created_date
order_created_datetime
order_updated_date
order_updated_datetime
order_invoice_date
order_invoice_datetime