Introduction

Datasources and destinations

Find all the data sources available at www.catchr.io/connectors
Find all the destinations available at www.catchr.io/destinations

Fields listing for Prestashop

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

23 metrics84 dimensions

107 fields

Customers 33

Customers
Field	Details
Customers Active Indicates if the customer account is active or not	Field ID`customers/active` DimensionTEXT
Customers Ape APE code for the customer	Field ID`customers/ape` DimensionTEXT
Customers Birthday Customer's date of birth	Field ID`customers/birthday` DimensionYEAR_MONTH_DAY_SECOND
Customers Company Customer's company name	Field ID`customers/company` DimensionTEXT
Customers Date Add Date and time when the customer account was created	Field ID`customers/date_add` DimensionYEAR_MONTH_DAY_SECOND
Customers Date Upd Date and time of the last update to the customer account	Field ID`customers/date_upd` DimensionYEAR_MONTH_DAY_SECOND
Customers Deleted Indicates if the customer account has been deleted	Field ID`customers/deleted` DimensionTEXT
Customers Email Customer's email address	Field ID`customers/email` DimensionTEXT
Customers Firstname Customer's first name	Field ID`customers/firstname` DimensionTEXT
Customers Id Unique identifier for the customer	Field ID`customers/id` DimensionNUMBER
Customers Id Default Group The default group id assigned to the customer	Field ID`customers/id_default_group` DimensionNUMBER
Customers Id Gender Gender identifier of the customer	Field ID`customers/id_gender` DimensionNUMBER
Customers Id Lang Language identifier associated with the customer	Field ID`customers/id_lang` DimensionNUMBER
Customers Id Risk Risk level identifier linked to the customer	Field ID`customers/id_risk` DimensionNUMBER
Customers Id Shop Shop identifier to which the customer belongs	Field ID`customers/id_shop` DimensionNUMBER
Customers Id Shop Group Shop group identifier associated with the customer	Field ID`customers/id_shop_group` DimensionNUMBER
Customers Ip Registration Newsletter IP address of the customer when they registered for newsletter	Field ID`customers/ip_registration_newsletter` DimensionTEXT
Customers Is Guest Indicates if the customer is a guest without registering	Field ID`customers/is_guest` DimensionTEXT
Customers Last Passwd Gen Date and time of the last password generation	Field ID`customers/last_passwd_gen` DimensionYEAR_MONTH_DAY
Customers Lastname Customer's last name	Field ID`customers/lastname` DimensionTEXT
Customers Max Payment Days Maximum number of payment days allowed for the customer	Field ID`customers/max_payment_days` MetricNUMBER
Customers Newsletter Indicates if the customer is subscribed to the newsletter	Field ID`customers/newsletter` DimensionTEXT
Customers Newsletter Date Add Date and time when the customer subscribed to the newsletter	Field ID`customers/newsletter_date_add` DimensionYEAR_MONTH_DAY_SECOND
Customers Note Additional notes or comments related to the customer	Field ID`customers/note` DimensionTEXT
Customers Optin Indicates whether the customer has opted-in for promotional communications	Field ID`customers/optin` DimensionTEXT
Customers Outstanding Allow Amount Maximum amount allowed for outstanding payments	Field ID`customers/outstanding_allow_amount` DimensionTEXT
Customers Passwd Customer's password (encrypted)	Field ID`customers/passwd` DimensionTEXT
Customers Reset Password Token Token generated for resetting customer's password	Field ID`customers/reset_password_token` DimensionTEXT
Customers Reset Password Validity Validity period for the password reset token	Field ID`customers/reset_password_validity` DimensionYEAR_MONTH_DAY_SECOND
Customers Secure Key Security key associated with the customer account	Field ID`customers/secure_key` DimensionTEXT
Customers Show Public Prices Indicates if the customer prefers to view public prices	Field ID`customers/show_public_prices` DimensionTEXT
Customers Siret SIRET code for the customer	Field ID`customers/siret` DimensionTEXT
Customers Website Customer's website URL	Field ID`customers/website` DimensionTEXT

Date 14

Date
Field	Details
Date Year, month, and day.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY` DimensionYEAR_MONTH_DAY
Day of the month Day of the year	Field ID`_NORMALIZED_DATE_FIELD_DAY` DimensionDAY
Day of the week Week of the year	Field ID`_NORMALIZED_DATE_FIELD_DAY_OF_WEEK` DimensionDAY_OF_WEEK
Hour of the day Hour of the day	Field ID`_NORMALIZED_DATE_FIELD_HOUR` DimensionHOUR
Month and day Month and day	Field ID`_NORMALIZED_DATE_FIELD_MONTH_DAY` DimensionMONTH_DAY
Month of the year Month of the year	Field ID`_NORMALIZED_DATE_FIELD_MONTH` DimensionMONTH
Quarter of the year Quarter of the year	Field ID`_NORMALIZED_DATE_FIELD_QUARTER` DimensionQUARTER
Week of the year Week of the year	Field ID`_NORMALIZED_DATE_FIELD_WEEK` DimensionWEEK
Week of the year (start Sunday) Week of the year	Field ID`_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY` DimensionWEEK
Year Year such as 2017.	Field ID`_NORMALIZED_DATE_FIELD_YEAR` DimensionYEAR
Year month Year and month.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_MONTH` DimensionYEAR_MONTH
Year month day hour Year, month, day, and hour.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR` DimensionYEAR_MONTH_DAY_HOUR
Year Quarter Year and quarter.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_QUARTER` DimensionYEAR_QUARTER
Year week Year and week.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_WEEK` DimensionYEAR_WEEK

Orders 46

Orders
Field	Details
Orders Carrier Tax Rate Tax rate applied to the carrier service	Field ID`orders/carrier_tax_rate` MetricTEXT
Orders Conversion Rate Currency conversion rate at the time of the order	Field ID`orders/conversion_rate` MetricNUMBER
Orders Current State Current status/state of the order	Field ID`orders/current_state` DimensionTEXT
Orders Date Add Date and time when the order was added	Field ID`orders/date_add` DimensionYEAR_MONTH_DAY_SECOND
Orders Date Upd Date and time when the order was last updated	Field ID`orders/date_upd` DimensionYEAR_MONTH_DAY_SECOND
Orders Delivery Date Expected delivery date of the order	Field ID`orders/delivery_date` DimensionYEAR_MONTH_DAY_SECOND
Orders Delivery Number Delivery number associated with the order	Field ID`orders/delivery_number` DimensionNUMBER
Orders Gift Flag indicating if the order is a gift	Field ID`orders/gift` DimensionNUMBER
Orders Gift Message Message included with the gift order	Field ID`orders/gift_message` DimensionTEXT
Orders Id Unique identifier for the order	Field ID`orders/id` DimensionNUMBER
Orders Id Address Delivery Identifier for the delivery address	Field ID`orders/id_address_delivery` DimensionNUMBER
Orders Id Address Invoice Identifier for the invoice address	Field ID`orders/id_address_invoice` DimensionNUMBER
Orders Id Carrier Identifier for the carrier service used for delivery	Field ID`orders/id_carrier` DimensionNUMBER
Orders Id Cart Identifier for the cart associated with the order	Field ID`orders/id_cart` DimensionNUMBER
Orders Id Currency Identifier for the currency used in the order	Field ID`orders/id_currency` DimensionNUMBER
Orders Id Lang Identifier for the language used in the order	Field ID`orders/id_lang` DimensionNUMBER
Orders Id Shop Identifier for the shop where the order was placed	Field ID`orders/id_shop` DimensionNUMBER
Orders Id Shop Group Identifier for the shop group to which the order belongs	Field ID`orders/id_shop_group` DimensionNUMBER
Orders Invoice Date Date of the invoice associated with the order	Field ID`orders/invoice_date` DimensionYEAR_MONTH_DAY_SECOND
Orders Invoice Number Invoice number related to the order	Field ID`orders/invoice_number` DimensionNUMBER
Orders Items Quantity Total quantity of items in the order	Field ID`orders/item_quantity` MetricNUMBER
Orders Mobile Theme Mobile theme used for the order	Field ID`orders/mobile_theme` DimensionNUMBER
Orders Module Payment module used for the order	Field ID`orders/module` DimensionTEXT
Orders Payment Payment method used for the order	Field ID`orders/payment` DimensionTEXT
Orders Recyclable Flag indicating if the order is recyclable	Field ID`orders/recyclable` DimensionNUMBER
Orders Reference Reference code of the order	Field ID`orders/reference` DimensionTEXT
Orders Round Mode Rounding mode used in calculations	Field ID`orders/round_mode` DimensionNUMBER
Orders Round Type Rounding type applied in calculations	Field ID`orders/round_type` DimensionNUMBER
Orders Secure Key Security key associated with the order	Field ID`orders/secure_key` DimensionTEXT
Orders Shipping Number Shipping number linked to the order	Field ID`orders/shipping_number` DimensionTEXT
Orders Total Discounts Total amount of discounts applied to the order	Field ID`orders/total_discounts` MetricNUMBER
Orders Total Discounts Tax Excl Total amount of discounts without tax included	Field ID`orders/total_discounts_tax_excl` MetricNUMBER
Orders Total Discounts Tax Incl Total amount of discounts with tax included	Field ID`orders/total_discounts_tax_incl` MetricNUMBER
Orders Total Paid Total amount paid for the order	Field ID`orders/total_paid` MetricNUMBER
Orders Total Paid Real Actual total amount paid for the order	Field ID`orders/total_paid_real` MetricNUMBER
Orders Total Paid Tax Excl Total amount paid without tax included	Field ID`orders/total_paid_tax_excl` MetricNUMBER
Orders Total Paid Tax Incl Total amount paid with tax included	Field ID`orders/total_paid_tax_incl` MetricNUMBER
Orders Total Products Total cost of products in the order	Field ID`orders/total_products` MetricNUMBER
Orders Total Products Wt Total cost of products with tax included	Field ID`orders/total_products_wt` MetricNUMBER
Orders Total Shipping Total cost of shipping	Field ID`orders/total_shipping` MetricNUMBER
Orders Total Shipping Tax Excl Total cost of shipping without tax included	Field ID`orders/total_shipping_tax_excl` MetricNUMBER
Orders Total Shipping Tax Incl Total cost of shipping with tax included	Field ID`orders/total_shipping_tax_incl` MetricNUMBER
Orders Total Wrapping Total cost of wrapping services	Field ID`orders/total_wrapping` MetricNUMBER
Orders Total Wrapping Tax Excl Total cost of wrapping services without tax included	Field ID`orders/total_wrapping_tax_excl` MetricNUMBER
Orders Total Wrapping Tax Incl Total cost of wrapping services with tax included	Field ID`orders/total_wrapping_tax_incl` MetricNUMBER
Orders Valid Flag indicating if the order is valid	Field ID`orders/valid` DimensionNUMBER

Orders item 13

Orders item
Field	Details
Order Item Unit Price Tax Excl Orders Item Unit Price Tax Excl	Field ID`order_items/unit_price_tax_excl` MetricNUMBER
Order Item Unit Price Tax Incl Orders Item Unit Price Tax Incl	Field ID`order_items/unit_price_tax_incl` MetricNUMBER
Orders Item ID Orders Item ID	Field ID`order_items/id` DimensionNUMBER
Product Attribute ID Orders Item Product Attribute ID	Field ID`order_items/product_attribute_id` DimensionNUMBER
Product Customization ID Orders Item Product Customization ID	Field ID`order_items/id_customization` DimensionNUMBER
Product EAN13 Orders Item Product EAN13	Field ID`order_items/product_ean13` DimensionTEXT
Product ID Orders Item Product ID	Field ID`order_items/product_id` DimensionNUMBER
Product ISBN Orders Item Product ISBN	Field ID`order_items/product_isbn` DimensionTEXT
Product Name Orders Item Product Name	Field ID`order_items/product_name` DimensionTEXT
Product Price Orders Item Product Price	Field ID`order_items/product_price` MetricNUMBER
Product Quantity Orders Item Product Quantity	Field ID`order_items/product_quantity` MetricNUMBER
Product Reference Orders Item Product Reference	Field ID`order_items/product_reference` DimensionTEXT
Product UPC Orders Item Product UPC	Field ID`order_items/product_upc` DimensionTEXT

Other fields 1

Other fields
Field	Details
Customers Customer Group Name Name of the customer's default group	Field ID`customers/customer_group_name` DimensionTEXT

Explore destinations for your data

Introduction

Fields listing for Prestashop

Metrics & dimensions

Customers 33

Date 14

Orders 46

Orders item 13

Other fields 1

Explore destinations for your data

Claude

ChatGPT

Excel

Azure Blob Storage

Google Cloud Storage

Amazon S3

Snowflake

Amazon Redshift

Azure SQL

PostgreSQL

MySQL

Tableau

Power BI

Big Query

Data Studio (formerly Looker Studio)

Google Sheets