API Connectors

users-love-us medal soc2
Send your PrestaShop data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

PrestaShop Connector Reference

86 metrics716 dimensions
Fields

The PrestaShop connector exposes 802 fields (86 metrics, 716 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


PrestaShop Fields

PrestaShop addresses fields

The addresses report of the PrestaShop connector includes 23 fields.

ID Type Name Description
addresses__address1 TEXT addresses.address1 addresses.address1
addresses__address2 TEXT addresses.address2 addresses.address2
addresses__alias TEXT addresses.alias addresses.alias
addresses__city CITY addresses.city addresses.city
addresses__company TEXT addresses.company addresses.company
addresses__date_add TIMESTAMP addresses.date_add addresses.date_add
addresses__date_upd TIMESTAMP addresses.date_upd addresses.date_upd
addresses__deleted TEXT addresses.deleted addresses.deleted
addresses__dni TEXT addresses.dni addresses.dni
addresses__firstname TEXT addresses.firstname addresses.firstname
addresses__id TEXT addresses.id addresses.id
addresses__id_country COUNTRY addresses.id_country addresses.id_country
addresses__id_customer TEXT addresses.id_customer addresses.id_customer
addresses__id_manufacturer TEXT addresses.id_manufacturer addresses.id_manufacturer
addresses__id_state TEXT addresses.id_state addresses.id_state
addresses__id_supplier TEXT addresses.id_supplier addresses.id_supplier
addresses__id_warehouse TEXT addresses.id_warehouse addresses.id_warehouse
addresses__lastname TEXT addresses.lastname addresses.lastname
addresses__other TEXT addresses.other addresses.other
addresses__phone TEXT addresses.phone addresses.phone
addresses__phone_mobile TEXT addresses.phone_mobile addresses.phone_mobile
addresses__postcode TEXT addresses.postcode addresses.postcode
addresses__vat_number TEXT addresses.vat_number addresses.vat_number

PrestaShop carriers fields

The carriers report of the PrestaShop connector includes 22 fields.

ID Type Name Description
carriers__active TEXT carriers.active carriers.active
carriers__delay TEXT carriers.delay carriers.delay
carriers__deleted TEXT carriers.deleted carriers.deleted
carriers__external_module_name TEXT carriers.external_module_name carriers.external_module_name
carriers__grade TEXT carriers.grade carriers.grade
carriers__id TEXT carriers.id carriers.id
carriers__id_reference TEXT carriers.id_reference carriers.id_reference
carriers__id_tax_rules_group TEXT carriers.id_tax_rules_group carriers.id_tax_rules_group
carriers__is_free TEXT carriers.is_free carriers.is_free
carriers__is_module TEXT carriers.is_module carriers.is_module
carriers__max_depth NUMERIC carriers.max_depth carriers.max_depth
carriers__max_height NUMERIC carriers.max_height carriers.max_height
carriers__max_weight NUMERIC carriers.max_weight carriers.max_weight
carriers__max_width NUMERIC carriers.max_width carriers.max_width
carriers__name TEXT carriers.name carriers.name
carriers__need_range TEXT carriers.need_range carriers.need_range
carriers__position TEXT carriers.position carriers.position
carriers__range_behavior TEXT carriers.range_behavior carriers.range_behavior
carriers__shipping_external TEXT carriers.shipping_external carriers.shipping_external
carriers__shipping_handling TEXT carriers.shipping_handling carriers.shipping_handling
carriers__shipping_method TEXT carriers.shipping_method carriers.shipping_method
carriers__url TEXT carriers.url carriers.url

PrestaShop cart_rules fields

The cart_rules report of the PrestaShop connector includes 34 fields.

ID Type Name Description
cart_rules__active TEXT cart_rules.active cart_rules.active
cart_rules__carrier_restriction TEXT cart_rules.carrier_restriction cart_rules.carrier_restriction
cart_rules__cart_rule_restriction TEXT cart_rules.cart_rule_restriction cart_rules.cart_rule_restriction
cart_rules__code TEXT cart_rules.code cart_rules.code
cart_rules__country_restriction TEXT cart_rules.country_restriction cart_rules.country_restriction
cart_rules__date_add TIMESTAMP cart_rules.date_add cart_rules.date_add
cart_rules__date_from DATE cart_rules.date_from cart_rules.date_from
cart_rules__date_to DATE cart_rules.date_to cart_rules.date_to
cart_rules__date_upd TIMESTAMP cart_rules.date_upd cart_rules.date_upd
cart_rules__description TEXT cart_rules.description cart_rules.description
cart_rules__free_shipping TEXT cart_rules.free_shipping cart_rules.free_shipping
cart_rules__gift_product TEXT cart_rules.gift_product cart_rules.gift_product
cart_rules__gift_product_attribute TEXT cart_rules.gift_product_attribute cart_rules.gift_product_attribute
cart_rules__group_restriction TEXT cart_rules.group_restriction cart_rules.group_restriction
cart_rules__highlight TEXT cart_rules.highlight cart_rules.highlight
cart_rules__id TEXT cart_rules.id cart_rules.id
cart_rules__id_customer TEXT cart_rules.id_customer cart_rules.id_customer
cart_rules__minimum_amount NUMERIC cart_rules.minimum_amount cart_rules.minimum_amount
cart_rules__minimum_amount_currency NUMERIC cart_rules.minimum_amount_currency cart_rules.minimum_amount_currency
cart_rules__minimum_amount_shipping NUMERIC cart_rules.minimum_amount_shipping cart_rules.minimum_amount_shipping
cart_rules__minimum_amount_tax NUMERIC cart_rules.minimum_amount_tax cart_rules.minimum_amount_tax
cart_rules__name TEXT cart_rules.name cart_rules.name
cart_rules__partial_use TEXT cart_rules.partial_use cart_rules.partial_use
cart_rules__priority TEXT cart_rules.priority cart_rules.priority
cart_rules__product_restriction TEXT cart_rules.product_restriction cart_rules.product_restriction
cart_rules__quantity NUMERIC cart_rules.quantity cart_rules.quantity
cart_rules__quantity_per_user TEXT cart_rules.quantity_per_user cart_rules.quantity_per_user
cart_rules__reduction_amount NUMERIC cart_rules.reduction_amount cart_rules.reduction_amount
cart_rules__reduction_currency TEXT cart_rules.reduction_currency cart_rules.reduction_currency
cart_rules__reduction_exclude_special TEXT cart_rules.reduction_exclude_special cart_rules.reduction_exclude_special
cart_rules__reduction_percent TEXT cart_rules.reduction_percent cart_rules.reduction_percent
cart_rules__reduction_product TEXT cart_rules.reduction_product cart_rules.reduction_product
cart_rules__reduction_tax TEXT cart_rules.reduction_tax cart_rules.reduction_tax
cart_rules__shop_restriction TEXT cart_rules.shop_restriction cart_rules.shop_restriction

PrestaShop carts fields

The carts report of the PrestaShop connector includes 20 fields.

ID Type Name Description
carts__allow_seperated_package TEXT carts.allow_seperated_package carts.allow_seperated_package
carts__associations OBJECT carts.associations carts.associations
carts__date_add TIMESTAMP carts.date_add carts.date_add
carts__date_upd TIMESTAMP carts.date_upd carts.date_upd
carts__delivery_option TEXT carts.delivery_option carts.delivery_option
carts__gift TEXT carts.gift carts.gift
carts__gift_message TEXT carts.gift_message carts.gift_message
carts__id TEXT carts.id carts.id
carts__id_address_delivery TEXT carts.id_address_delivery carts.id_address_delivery
carts__id_address_invoice TEXT carts.id_address_invoice carts.id_address_invoice
carts__id_carrier TEXT carts.id_carrier carts.id_carrier
carts__id_currency TEXT carts.id_currency carts.id_currency
carts__id_customer TEXT carts.id_customer carts.id_customer
carts__id_guest TEXT carts.id_guest carts.id_guest
carts__id_lang TEXT carts.id_lang carts.id_lang
carts__id_shop TEXT carts.id_shop carts.id_shop
carts__id_shop_group TEXT carts.id_shop_group carts.id_shop_group
carts__mobile_theme TEXT carts.mobile_theme carts.mobile_theme
carts__recyclable TEXT carts.recyclable carts.recyclable
carts__secure_key TEXT carts.secure_key carts.secure_key

PrestaShop categories fields

The categories report of the PrestaShop connector includes 17 fields.

ID Type Name Description
categories__active TEXT categories.active categories.active
categories__associations OBJECT categories.associations categories.associations
categories__date_add TIMESTAMP categories.date_add categories.date_add
categories__date_upd TIMESTAMP categories.date_upd categories.date_upd
categories__description TEXT categories.description categories.description
categories__id TEXT categories.id categories.id
categories__id_parent TEXT categories.id_parent categories.id_parent
categories__id_shop_default TEXT categories.id_shop_default categories.id_shop_default
categories__is_root_category TEXT categories.is_root_category categories.is_root_category
categories__level_depth TEXT categories.level_depth categories.level_depth
categories__link_rewrite TEXT categories.link_rewrite categories.link_rewrite
categories__meta_description TEXT categories.meta_description categories.meta_description
categories__meta_keywords TEXT categories.meta_keywords categories.meta_keywords
categories__meta_title TEXT categories.meta_title categories.meta_title
categories__name TEXT categories.name categories.name
categories__nb_products_recursive TEXT categories.nb_products_recursive categories.nb_products_recursive
categories__position TEXT categories.position categories.position

PrestaShop combinations fields

The combinations report of the PrestaShop connector includes 21 fields.

ID Type Name Description
combinations__associations OBJECT combinations.associations combinations.associations
combinations__available_date DATE combinations.available_date combinations.available_date
combinations__default_on TEXT combinations.default_on combinations.default_on
combinations__ean13 TEXT combinations.ean13 combinations.ean13
combinations__ecotax TEXT combinations.ecotax combinations.ecotax
combinations__id TEXT combinations.id combinations.id
combinations__id_product TEXT combinations.id_product combinations.id_product
combinations__isbn TEXT combinations.isbn combinations.isbn
combinations__location TEXT combinations.location combinations.location
combinations__low_stock_alert TEXT combinations.low_stock_alert combinations.low_stock_alert
combinations__low_stock_threshold TEXT combinations.low_stock_threshold combinations.low_stock_threshold
combinations__minimal_quantity NUMERIC combinations.minimal_quantity combinations.minimal_quantity
combinations__mpn TEXT combinations.mpn combinations.mpn
combinations__price NUMERIC combinations.price combinations.price
combinations__quantity NUMERIC combinations.quantity combinations.quantity
combinations__reference TEXT combinations.reference combinations.reference
combinations__supplier_reference TEXT combinations.supplier_reference combinations.supplier_reference
combinations__unit_price_impact TEXT combinations.unit_price_impact combinations.unit_price_impact
combinations__upc TEXT combinations.upc combinations.upc
combinations__weight NUMERIC combinations.weight combinations.weight
combinations__wholesale_price NUMERIC combinations.wholesale_price combinations.wholesale_price

PrestaShop configurations fields

The configurations report of the PrestaShop connector includes 7 fields.

ID Type Name Description
configurations__date_add TIMESTAMP configurations.date_add configurations.date_add
configurations__date_upd TIMESTAMP configurations.date_upd configurations.date_upd
configurations__id TEXT configurations.id configurations.id
configurations__id_shop TEXT configurations.id_shop configurations.id_shop
configurations__id_shop_group TEXT configurations.id_shop_group configurations.id_shop_group
configurations__name TEXT configurations.name configurations.name
configurations__value TEXT configurations.value configurations.value

PrestaShop contacts fields

The contacts report of the PrestaShop connector includes 5 fields.

ID Type Name Description
contacts__customer_service TEXT contacts.customer_service contacts.customer_service
contacts__description TEXT contacts.description contacts.description
contacts__email TEXT contacts.email contacts.email
contacts__id TEXT contacts.id contacts.id
contacts__name TEXT contacts.name contacts.name

PrestaShop content_management_system fields

The content_management_system report of the PrestaShop connector includes 11 fields.

ID Type Name Description
content_management_system__active TEXT content_management_system.active content_management_system.active
content_management_system__content TEXT content_management_system.content content_management_system.content
content_management_system__head_seo_title TEXT content_management_system.head_seo_title content_management_system.head_seo_title
content_management_system__id TEXT content_management_system.id content_management_system.id
content_management_system__id_cms_category TEXT content_management_system.id_cms_category content_management_system.id_cms_category
content_management_system__indexation TEXT content_management_system.indexation content_management_system.indexation
content_management_system__link_rewrite TEXT content_management_system.link_rewrite content_management_system.link_rewrite
content_management_system__meta_description TEXT content_management_system.meta_description content_management_system.meta_description
content_management_system__meta_keywords TEXT content_management_system.meta_keywords content_management_system.meta_keywords
content_management_system__meta_title TEXT content_management_system.meta_title content_management_system.meta_title
content_management_system__position TEXT content_management_system.position content_management_system.position

PrestaShop countries fields

The countries report of the PrestaShop connector includes 12 fields.

ID Type Name Description
countries__active TEXT countries.active countries.active
countries__call_prefix TEXT countries.call_prefix countries.call_prefix
countries__contains_states TEXT countries.contains_states countries.contains_states
countries__display_tax_label TEXT countries.display_tax_label countries.display_tax_label
countries__id TEXT countries.id countries.id
countries__id_currency TEXT countries.id_currency countries.id_currency
countries__id_zone TEXT countries.id_zone countries.id_zone
countries__iso_code TEXT countries.iso_code countries.iso_code
countries__name TEXT countries.name countries.name
countries__need_identification_number TEXT countries.need_identification_number countries.need_identification_number
countries__need_zip_code TEXT countries.need_zip_code countries.need_zip_code
countries__zip_code_format TEXT countries.zip_code_format countries.zip_code_format

PrestaShop currencies fields

The currencies report of the PrestaShop connector includes 13 fields.

ID Type Name Description
currencies__active TEXT currencies.active currencies.active
currencies__conversion_rate NUMERIC currencies.conversion_rate currencies.conversion_rate
currencies__deleted TEXT currencies.deleted currencies.deleted
currencies__id TEXT currencies.id currencies.id
currencies__iso_code TEXT currencies.iso_code currencies.iso_code
currencies__modified TEXT currencies.modified currencies.modified
currencies__name TEXT currencies.name currencies.name
currencies__names TEXT currencies.names currencies.names
currencies__numeric_iso_code TEXT currencies.numeric_iso_code currencies.numeric_iso_code
currencies__pattern TEXT currencies.pattern currencies.pattern
currencies__precision TEXT currencies.precision currencies.precision
currencies__symbol TEXT currencies.symbol currencies.symbol
currencies__unofficial TEXT currencies.unofficial currencies.unofficial

PrestaShop customer_messages fields

The customer_messages report of the PrestaShop connector includes 11 fields.

ID Type Name Description
customer_messages__date_add TIMESTAMP customer_messages.date_add customer_messages.date_add
customer_messages__date_upd TIMESTAMP customer_messages.date_upd customer_messages.date_upd
customer_messages__file_name TEXT customer_messages.file_name customer_messages.file_name
customer_messages__id TEXT customer_messages.id customer_messages.id
customer_messages__id_customer_thread TEXT customer_messages.id_customer_thread customer_messages.id_customer_thread
customer_messages__id_employee TEXT customer_messages.id_employee customer_messages.id_employee
customer_messages__ip_address TEXT customer_messages.ip_address customer_messages.ip_address
customer_messages__message TEXT customer_messages.message customer_messages.message
customer_messages__private TEXT customer_messages.private customer_messages.private
customer_messages__read TEXT customer_messages.read customer_messages.read
customer_messages__user_agent TEXT customer_messages.user_agent customer_messages.user_agent

PrestaShop customer_threads fields

The customer_threads report of the PrestaShop connector includes 13 fields.

ID Type Name Description
customer_threads__associations OBJECT customer_threads.associations customer_threads.associations
customer_threads__date_add TIMESTAMP customer_threads.date_add customer_threads.date_add
customer_threads__date_upd TIMESTAMP customer_threads.date_upd customer_threads.date_upd
customer_threads__email TEXT customer_threads.email customer_threads.email
customer_threads__id TEXT customer_threads.id customer_threads.id
customer_threads__id_contact TEXT customer_threads.id_contact customer_threads.id_contact
customer_threads__id_customer TEXT customer_threads.id_customer customer_threads.id_customer
customer_threads__id_lang TEXT customer_threads.id_lang customer_threads.id_lang
customer_threads__id_order TEXT customer_threads.id_order customer_threads.id_order
customer_threads__id_product TEXT customer_threads.id_product customer_threads.id_product
customer_threads__id_shop TEXT customer_threads.id_shop customer_threads.id_shop
customer_threads__status TEXT customer_threads.status customer_threads.status
customer_threads__token TEXT customer_threads.token customer_threads.token

PrestaShop customers fields

The customers report of the PrestaShop connector includes 34 fields.

ID Type Name Description
customers__active TEXT customers.active customers.active
customers__ape TEXT customers.ape customers.ape
customers__associations OBJECT customers.associations customers.associations
customers__birthday TEXT customers.birthday customers.birthday
customers__company TEXT customers.company customers.company
customers__date_add TIMESTAMP customers.date_add customers.date_add
customers__date_upd TIMESTAMP customers.date_upd customers.date_upd
customers__deleted TEXT customers.deleted customers.deleted
customers__email TEXT customers.email customers.email
customers__firstname TEXT customers.firstname customers.firstname
customers__id TEXT customers.id customers.id
customers__id_default_group TEXT customers.id_default_group customers.id_default_group
customers__id_gender TEXT customers.id_gender customers.id_gender
customers__id_lang TEXT customers.id_lang customers.id_lang
customers__id_risk TEXT customers.id_risk customers.id_risk
customers__id_shop TEXT customers.id_shop customers.id_shop
customers__id_shop_group TEXT customers.id_shop_group customers.id_shop_group
customers__ip_registration_newsletter TEXT customers.ip_registration_newsletter customers.ip_registration_newsletter
customers__is_guest TEXT customers.is_guest customers.is_guest
customers__last_passwd_gen TEXT customers.last_passwd_gen customers.last_passwd_gen
customers__lastname TEXT customers.lastname customers.lastname
customers__max_payment_days TEXT customers.max_payment_days customers.max_payment_days
customers__newsletter TEXT customers.newsletter customers.newsletter
customers__newsletter_date_add DATE customers.newsletter_date_add customers.newsletter_date_add
customers__note TEXT customers.note customers.note
customers__optin TEXT customers.optin customers.optin
customers__outstanding_allow_amount TEXT customers.outstanding_allow_amount customers.outstanding_allow_amount
customers__passwd TEXT customers.passwd customers.passwd
customers__reset_password_token TEXT customers.reset_password_token customers.reset_password_token
customers__reset_password_validity TEXT customers.reset_password_validity customers.reset_password_validity
customers__secure_key TEXT customers.secure_key customers.secure_key
customers__show_public_prices TEXT customers.show_public_prices customers.show_public_prices
customers__siret TEXT customers.siret customers.siret
customers__website TEXT customers.website customers.website

PrestaShop deliveries fields

The deliveries report of the PrestaShop connector includes 8 fields.

ID Type Name Description
deliveries__id TEXT deliveries.id deliveries.id
deliveries__id_carrier TEXT deliveries.id_carrier deliveries.id_carrier
deliveries__id_range_price TEXT deliveries.id_range_price deliveries.id_range_price
deliveries__id_range_weight TEXT deliveries.id_range_weight deliveries.id_range_weight
deliveries__id_shop TEXT deliveries.id_shop deliveries.id_shop
deliveries__id_shop_group TEXT deliveries.id_shop_group deliveries.id_shop_group
deliveries__id_zone TEXT deliveries.id_zone deliveries.id_zone
deliveries__price NUMERIC deliveries.price deliveries.price

PrestaShop employees fields

The employees report of the PrestaShop connector includes 26 fields.

ID Type Name Description
employees__active TEXT employees.active employees.active
employees__bo_color TEXT employees.bo_color employees.bo_color
employees__bo_css TEXT employees.bo_css employees.bo_css
employees__bo_menu TEXT employees.bo_menu employees.bo_menu
employees__bo_theme TEXT employees.bo_theme employees.bo_theme
employees__bo_width TEXT employees.bo_width employees.bo_width
employees__default_tab TEXT employees.default_tab employees.default_tab
employees__email TEXT employees.email employees.email
employees__firstname TEXT employees.firstname employees.firstname
employees__id TEXT employees.id employees.id
employees__id_lang TEXT employees.id_lang employees.id_lang
employees__id_last_customer TEXT employees.id_last_customer employees.id_last_customer
employees__id_last_customer_message TEXT employees.id_last_customer_message employees.id_last_customer_message
employees__id_last_order TEXT employees.id_last_order employees.id_last_order
employees__id_profile TEXT employees.id_profile employees.id_profile
employees__last_passwd_gen TEXT employees.last_passwd_gen employees.last_passwd_gen
employees__lastname TEXT employees.lastname employees.lastname
employees__passwd TEXT employees.passwd employees.passwd
employees__preselect_date_range TEXT employees.preselect_date_range employees.preselect_date_range
employees__reset_password_token TEXT employees.reset_password_token employees.reset_password_token
employees__reset_password_validity TEXT employees.reset_password_validity employees.reset_password_validity
employees__stats_compare_from TEXT employees.stats_compare_from employees.stats_compare_from
employees__stats_compare_option TEXT employees.stats_compare_option employees.stats_compare_option
employees__stats_compare_to TEXT employees.stats_compare_to employees.stats_compare_to
employees__stats_date_from DATE employees.stats_date_from employees.stats_date_from
employees__stats_date_to DATE employees.stats_date_to employees.stats_date_to

PrestaShop groups fields

The groups report of the PrestaShop connector includes 7 fields.

ID Type Name Description
groups__date_add TIMESTAMP groups.date_add groups.date_add
groups__date_upd TIMESTAMP groups.date_upd groups.date_upd
groups__id TEXT groups.id groups.id
groups__name TEXT groups.name groups.name
groups__price_display_method TEXT groups.price_display_method groups.price_display_method
groups__reduction TEXT groups.reduction groups.reduction
groups__show_prices TEXT groups.show_prices groups.show_prices

PrestaShop guests fields

The guests report of the PrestaShop connector includes 16 fields.

ID Type Name Description
guests__accept_language TEXT guests.accept_language guests.accept_language
guests__adobe_director TEXT guests.adobe_director guests.adobe_director
guests__adobe_flash TEXT guests.adobe_flash guests.adobe_flash
guests__apple_quicktime TEXT guests.apple_quicktime guests.apple_quicktime
guests__id TEXT guests.id guests.id
guests__id_customer TEXT guests.id_customer guests.id_customer
guests__id_operating_system TEXT guests.id_operating_system guests.id_operating_system
guests__id_web_browser TEXT guests.id_web_browser guests.id_web_browser
guests__javascript TEXT guests.javascript guests.javascript
guests__mobile_theme TEXT guests.mobile_theme guests.mobile_theme
guests__real_player TEXT guests.real_player guests.real_player
guests__screen_color TEXT guests.screen_color guests.screen_color
guests__screen_resolution_x TEXT guests.screen_resolution_x guests.screen_resolution_x
guests__screen_resolution_y TEXT guests.screen_resolution_y guests.screen_resolution_y
guests__sun_java TEXT guests.sun_java guests.sun_java
guests__windows_media TEXT guests.windows_media guests.windows_media

PrestaShop image_types fields

The image_types report of the PrestaShop connector includes 9 fields.

ID Type Name Description
image_types__categories TEXT image_types.categories image_types.categories
image_types__height TEXT image_types.height image_types.height
image_types__id TEXT image_types.id image_types.id
image_types__manufacturers TEXT image_types.manufacturers image_types.manufacturers
image_types__name TEXT image_types.name image_types.name
image_types__products TEXT image_types.products image_types.products
image_types__stores TEXT image_types.stores image_types.stores
image_types__suppliers TEXT image_types.suppliers image_types.suppliers
image_types__width TEXT image_types.width image_types.width

PrestaShop languages fields

The languages report of the PrestaShop connector includes 9 fields.

ID Type Name Description
languages__active TEXT languages.active languages.active
languages__date_format_full TEXT languages.date_format_full languages.date_format_full
languages__date_format_lite TEXT languages.date_format_lite languages.date_format_lite
languages__id TEXT languages.id languages.id
languages__is_rtl TEXT languages.is_rtl languages.is_rtl
languages__iso_code TEXT languages.iso_code languages.iso_code
languages__language_code TEXT languages.language_code languages.language_code
languages__locale TEXT languages.locale languages.locale
languages__name TEXT languages.name languages.name

PrestaShop manufacturers fields

The manufacturers report of the PrestaShop connector includes 12 fields.

ID Type Name Description
manufacturers__active TEXT manufacturers.active manufacturers.active
manufacturers__associations OBJECT manufacturers.associations manufacturers.associations
manufacturers__date_add TIMESTAMP manufacturers.date_add manufacturers.date_add
manufacturers__date_upd TIMESTAMP manufacturers.date_upd manufacturers.date_upd
manufacturers__description TEXT manufacturers.description manufacturers.description
manufacturers__id TEXT manufacturers.id manufacturers.id
manufacturers__link_rewrite TEXT manufacturers.link_rewrite manufacturers.link_rewrite
manufacturers__meta_description TEXT manufacturers.meta_description manufacturers.meta_description
manufacturers__meta_keywords TEXT manufacturers.meta_keywords manufacturers.meta_keywords
manufacturers__meta_title TEXT manufacturers.meta_title manufacturers.meta_title
manufacturers__name TEXT manufacturers.name manufacturers.name
manufacturers__short_description TEXT manufacturers.short_description manufacturers.short_description

PrestaShop messages fields

The messages report of the PrestaShop connector includes 8 fields.

ID Type Name Description
messages__date_add TIMESTAMP messages.date_add messages.date_add
messages__id TEXT messages.id messages.id
messages__id_cart TEXT messages.id_cart messages.id_cart
messages__id_customer TEXT messages.id_customer messages.id_customer
messages__id_employee TEXT messages.id_employee messages.id_employee
messages__id_order TEXT messages.id_order messages.id_order
messages__message TEXT messages.message messages.message
messages__private TEXT messages.private messages.private

PrestaShop order_carriers fields

The order_carriers report of the PrestaShop connector includes 9 fields.

ID Type Name Description
order_carriers__date_add TIMESTAMP order_carriers.date_add order_carriers.date_add
order_carriers__id TEXT order_carriers.id order_carriers.id
order_carriers__id_carrier TEXT order_carriers.id_carrier order_carriers.id_carrier
order_carriers__id_order TEXT order_carriers.id_order order_carriers.id_order
order_carriers__id_order_invoice TEXT order_carriers.id_order_invoice order_carriers.id_order_invoice
order_carriers__shipping_cost_tax_excl NUMERIC order_carriers.shipping_cost_tax_excl order_carriers.shipping_cost_tax_excl
order_carriers__shipping_cost_tax_incl NUMERIC order_carriers.shipping_cost_tax_incl order_carriers.shipping_cost_tax_incl
order_carriers__tracking_number TEXT order_carriers.tracking_number order_carriers.tracking_number
order_carriers__weight NUMERIC order_carriers.weight order_carriers.weight

PrestaShop order_details fields

The order_details report of the PrestaShop connector includes 51 fields.

PrestaShop order_details fields (order_details__discount_quantity_applied to order_details__reduction_amount_tax_excl)

ID Type Name Description
order_details__discount_quantity_applied TEXT order_details.discount_quantity_applied order_details.discount_quantity_applied
order_details__download_deadline TEXT order_details.download_deadline order_details.download_deadline
order_details__download_hash TEXT order_details.download_hash order_details.download_hash
order_details__download_nb TEXT order_details.download_nb order_details.download_nb
order_details__ecotax NUMERIC order_details.ecotax order_details.ecotax
order_details__ecotax_tax_rate NUMERIC order_details.ecotax_tax_rate order_details.ecotax_tax_rate
order_details__group_reduction TEXT order_details.group_reduction order_details.group_reduction
order_details__id TEXT order_details.id order_details.id
order_details__id_customization TEXT order_details.id_customization order_details.id_customization
order_details__id_order TEXT order_details.id_order order_details.id_order
order_details__id_order_invoice TEXT order_details.id_order_invoice order_details.id_order_invoice
order_details__id_shop TEXT order_details.id_shop order_details.id_shop
order_details__id_tax_rules_group TEXT order_details.id_tax_rules_group order_details.id_tax_rules_group
order_details__id_warehouse TEXT order_details.id_warehouse order_details.id_warehouse
order_details__order_date_add TIMESTAMP order_details.order_date_add orders.date_add of the parent order
order_details__order_date_upd TIMESTAMP order_details.order_date_upd orders.date_upd of the parent order
order_details__order_delivery_date DATE order_details.order_delivery_date orders.delivery_date of the parent order
order_details__order_invoice_date DATE order_details.order_invoice_date orders.invoice_date of the parent order
order_details__original_product_price NUMERIC order_details.original_product_price order_details.original_product_price
order_details__original_wholesale_price NUMERIC order_details.original_wholesale_price order_details.original_wholesale_price
order_details__product_attribute_id TEXT order_details.product_attribute_id order_details.product_attribute_id
order_details__product_ean13 TEXT order_details.product_ean13 order_details.product_ean13
order_details__product_id TEXT order_details.product_id order_details.product_id
order_details__product_isbn TEXT order_details.product_isbn order_details.product_isbn
order_details__product_mpn TEXT order_details.product_mpn order_details.product_mpn
order_details__product_name TEXT order_details.product_name order_details.product_name
order_details__product_price NUMERIC order_details.product_price order_details.product_price
order_details__product_quantity NUMERIC order_details.product_quantity order_details.product_quantity
order_details__product_quantity_discount NUMERIC order_details.product_quantity_discount order_details.product_quantity_discount
order_details__product_quantity_in_stock TEXT order_details.product_quantity_in_stock order_details.product_quantity_in_stock
order_details__product_quantity_refunded TEXT order_details.product_quantity_refunded order_details.product_quantity_refunded
order_details__product_quantity_reinjected TEXT order_details.product_quantity_reinjected order_details.product_quantity_reinjected
order_details__product_quantity_return NUMERIC order_details.product_quantity_return order_details.product_quantity_return
order_details__product_reference TEXT order_details.product_reference order_details.product_reference
order_details__product_supplier_reference TEXT order_details.product_supplier_reference order_details.product_supplier_reference
order_details__product_upc TEXT order_details.product_upc order_details.product_upc
order_details__product_weight NUMERIC order_details.product_weight order_details.product_weight
order_details__purchase_supplier_price NUMERIC order_details.purchase_supplier_price order_details.purchase_supplier_price
order_details__reduction_amount TEXT order_details.reduction_amount order_details.reduction_amount
order_details__reduction_amount_tax_excl TEXT order_details.reduction_amount_tax_excl order_details.reduction_amount_tax_excl

PrestaShop order_details fields (order_details__reduction_amount_tax_incl to order_details__unit_price_tax_incl)

ID Type Name Description
order_details__reduction_amount_tax_incl TEXT order_details.reduction_amount_tax_incl order_details.reduction_amount_tax_incl
order_details__reduction_percent TEXT order_details.reduction_percent order_details.reduction_percent
order_details__tax_computation_method TEXT order_details.tax_computation_method order_details.tax_computation_method
order_details__total_price_tax_excl NUMERIC order_details.total_price_tax_excl order_details.total_price_tax_excl
order_details__total_price_tax_incl NUMERIC order_details.total_price_tax_incl order_details.total_price_tax_incl
order_details__total_refunded_tax_excl NUMERIC order_details.total_refunded_tax_excl order_details.total_refunded_tax_excl
order_details__total_refunded_tax_incl NUMERIC order_details.total_refunded_tax_incl order_details.total_refunded_tax_incl
order_details__total_shipping_price_tax_excl NUMERIC order_details.total_shipping_price_tax_excl order_details.total_shipping_price_tax_excl
order_details__total_shipping_price_tax_incl NUMERIC order_details.total_shipping_price_tax_incl order_details.total_shipping_price_tax_incl
order_details__unit_price_tax_excl NUMERIC order_details.unit_price_tax_excl order_details.unit_price_tax_excl
order_details__unit_price_tax_incl NUMERIC order_details.unit_price_tax_incl order_details.unit_price_tax_incl

PrestaShop order_histories fields

The order_histories report of the PrestaShop connector includes 5 fields.

ID Type Name Description
order_histories__date_add TIMESTAMP order_histories.date_add order_histories.date_add
order_histories__id TEXT order_histories.id order_histories.id
order_histories__id_employee TEXT order_histories.id_employee order_histories.id_employee
order_histories__id_order TEXT order_histories.id_order order_histories.id_order
order_histories__id_order_state TEXT order_histories.id_order_state order_histories.id_order_state

PrestaShop order_invoices fields

The order_invoices report of the PrestaShop connector includes 19 fields.

ID Type Name Description
order_invoices__date_add TIMESTAMP order_invoices.date_add order_invoices.date_add
order_invoices__delivery_date DATE order_invoices.delivery_date order_invoices.delivery_date
order_invoices__delivery_number TEXT order_invoices.delivery_number order_invoices.delivery_number
order_invoices__id TEXT order_invoices.id order_invoices.id
order_invoices__id_order TEXT order_invoices.id_order order_invoices.id_order
order_invoices__note TEXT order_invoices.note order_invoices.note
order_invoices__number TEXT order_invoices.number order_invoices.number
order_invoices__shipping_tax_computation_method TEXT order_invoices.shipping_tax_computation_method order_invoices.shipping_tax_computation_method
order_invoices__shop_address TEXT order_invoices.shop_address order_invoices.shop_address
order_invoices__total_discount_tax_excl NUMERIC order_invoices.total_discount_tax_excl order_invoices.total_discount_tax_excl
order_invoices__total_discount_tax_incl NUMERIC order_invoices.total_discount_tax_incl order_invoices.total_discount_tax_incl
order_invoices__total_paid_tax_excl NUMERIC order_invoices.total_paid_tax_excl order_invoices.total_paid_tax_excl
order_invoices__total_paid_tax_incl NUMERIC order_invoices.total_paid_tax_incl order_invoices.total_paid_tax_incl
order_invoices__total_products TEXT order_invoices.total_products order_invoices.total_products
order_invoices__total_products_wt TEXT order_invoices.total_products_wt order_invoices.total_products_wt
order_invoices__total_shipping_tax_excl NUMERIC order_invoices.total_shipping_tax_excl order_invoices.total_shipping_tax_excl
order_invoices__total_shipping_tax_incl NUMERIC order_invoices.total_shipping_tax_incl order_invoices.total_shipping_tax_incl
order_invoices__total_wrapping_tax_excl NUMERIC order_invoices.total_wrapping_tax_excl order_invoices.total_wrapping_tax_excl
order_invoices__total_wrapping_tax_incl NUMERIC order_invoices.total_wrapping_tax_incl order_invoices.total_wrapping_tax_incl

PrestaShop order_payments fields

The order_payments report of the PrestaShop connector includes 12 fields.

ID Type Name Description
order_payments__amount NUMERIC order_payments.amount order_payments.amount
order_payments__card_brand TEXT order_payments.card_brand order_payments.card_brand
order_payments__card_expiration TEXT order_payments.card_expiration order_payments.card_expiration
order_payments__card_holder TEXT order_payments.card_holder order_payments.card_holder
order_payments__card_number TEXT order_payments.card_number order_payments.card_number
order_payments__conversion_rate TEXT order_payments.conversion_rate order_payments.conversion_rate
order_payments__date_add TIMESTAMP order_payments.date_add order_payments.date_add
order_payments__id TEXT order_payments.id order_payments.id
order_payments__id_currency TEXT order_payments.id_currency order_payments.id_currency
order_payments__order_reference TEXT order_payments.order_reference order_payments.order_reference
order_payments__payment_method TEXT order_payments.payment_method order_payments.payment_method
order_payments__transaction_id TEXT order_payments.transaction_id order_payments.transaction_id

PrestaShop order_slip fields

The order_slip report of the PrestaShop connector includes 15 fields.

ID Type Name Description
order_slip__amount NUMERIC order_slip.amount order_slip.amount
order_slip__conversion_rate TEXT order_slip.conversion_rate order_slip.conversion_rate
order_slip__date_add TIMESTAMP order_slip.date_add order_slip.date_add
order_slip__date_upd TIMESTAMP order_slip.date_upd order_slip.date_upd
order_slip__id TEXT order_slip.id order_slip.id
order_slip__id_customer TEXT order_slip.id_customer order_slip.id_customer
order_slip__id_order TEXT order_slip.id_order order_slip.id_order
order_slip__order_slip_type TEXT order_slip.order_slip_type order_slip.order_slip_type
order_slip__partial TEXT order_slip.partial order_slip.partial
order_slip__shipping_cost NUMERIC order_slip.shipping_cost order_slip.shipping_cost
order_slip__shipping_cost_amount NUMERIC order_slip.shipping_cost_amount order_slip.shipping_cost_amount
order_slip__total_products_tax_excl NUMERIC order_slip.total_products_tax_excl order_slip.total_products_tax_excl
order_slip__total_products_tax_incl NUMERIC order_slip.total_products_tax_incl order_slip.total_products_tax_incl
order_slip__total_shipping_tax_excl NUMERIC order_slip.total_shipping_tax_excl order_slip.total_shipping_tax_excl
order_slip__total_shipping_tax_incl NUMERIC order_slip.total_shipping_tax_incl order_slip.total_shipping_tax_incl

PrestaShop order_states fields

The order_states report of the PrestaShop connector includes 16 fields.

ID Type Name Description
order_states__color TEXT order_states.color order_states.color
order_states__deleted TEXT order_states.deleted order_states.deleted
order_states__delivery TEXT order_states.delivery order_states.delivery
order_states__hidden TEXT order_states.hidden order_states.hidden
order_states__id TEXT order_states.id order_states.id
order_states__invoice TEXT order_states.invoice order_states.invoice
order_states__logable TEXT order_states.logable order_states.logable
order_states__module_name TEXT order_states.module_name order_states.module_name
order_states__name TEXT order_states.name order_states.name
order_states__paid TEXT order_states.paid order_states.paid
order_states__pdf_delivery TEXT order_states.pdf_delivery order_states.pdf_delivery
order_states__pdf_invoice TEXT order_states.pdf_invoice order_states.pdf_invoice
order_states__send_email TEXT order_states.send_email order_states.send_email
order_states__shipped TEXT order_states.shipped order_states.shipped
order_states__template TEXT order_states.template order_states.template
order_states__unremovable TEXT order_states.unremovable order_states.unremovable

PrestaShop orders fields

The orders report of the PrestaShop connector includes 47 fields.

PrestaShop orders fields (orders__associations to orders__total_products_wt)

ID Type Name Description
orders__associations OBJECT orders.associations orders.associations
orders__carrier_tax_rate TEXT orders.carrier_tax_rate orders.carrier_tax_rate
orders__conversion_rate TEXT orders.conversion_rate orders.conversion_rate
orders__current_state TEXT orders.current_state orders.current_state
orders__date_add TIMESTAMP orders.date_add orders.date_add
orders__date_upd TIMESTAMP orders.date_upd orders.date_upd
orders__delivery_date DATE orders.delivery_date orders.delivery_date
orders__delivery_number TEXT orders.delivery_number orders.delivery_number
orders__gift TEXT orders.gift orders.gift
orders__gift_message TEXT orders.gift_message orders.gift_message
orders__id TEXT orders.id orders.id
orders__id_address_delivery TEXT orders.id_address_delivery orders.id_address_delivery
orders__id_address_invoice TEXT orders.id_address_invoice orders.id_address_invoice
orders__id_carrier TEXT orders.id_carrier orders.id_carrier
orders__id_cart TEXT orders.id_cart orders.id_cart
orders__id_currency TEXT orders.id_currency orders.id_currency
orders__id_customer TEXT orders.id_customer orders.id_customer
orders__id_lang TEXT orders.id_lang orders.id_lang
orders__id_shop TEXT orders.id_shop orders.id_shop
orders__id_shop_group TEXT orders.id_shop_group orders.id_shop_group
orders__invoice_date DATE orders.invoice_date orders.invoice_date
orders__invoice_number TEXT orders.invoice_number orders.invoice_number
orders__mobile_theme TEXT orders.mobile_theme orders.mobile_theme
orders__module TEXT orders.module orders.module
orders__payment TEXT orders.payment orders.payment
orders__recyclable TEXT orders.recyclable orders.recyclable
orders__reference TEXT orders.reference orders.reference
orders__round_mode TEXT orders.round_mode orders.round_mode
orders__round_type TEXT orders.round_type orders.round_type
orders__secure_key TEXT orders.secure_key orders.secure_key
orders__shipping_number TEXT orders.shipping_number orders.shipping_number
orders__total_discounts NUMERIC orders.total_discounts orders.total_discounts
orders__total_discounts_tax_excl NUMERIC orders.total_discounts_tax_excl orders.total_discounts_tax_excl
orders__total_discounts_tax_incl NUMERIC orders.total_discounts_tax_incl orders.total_discounts_tax_incl
orders__total_paid NUMERIC orders.total_paid orders.total_paid
orders__total_paid_real NUMERIC orders.total_paid_real orders.total_paid_real
orders__total_paid_tax_excl NUMERIC orders.total_paid_tax_excl orders.total_paid_tax_excl
orders__total_paid_tax_incl NUMERIC orders.total_paid_tax_incl orders.total_paid_tax_incl
orders__total_products NUMERIC orders.total_products orders.total_products
orders__total_products_wt NUMERIC orders.total_products_wt orders.total_products_wt

PrestaShop orders fields (orders__total_shipping to orders__valid)

ID Type Name Description
orders__total_shipping NUMERIC orders.total_shipping orders.total_shipping
orders__total_shipping_tax_excl NUMERIC orders.total_shipping_tax_excl orders.total_shipping_tax_excl
orders__total_shipping_tax_incl NUMERIC orders.total_shipping_tax_incl orders.total_shipping_tax_incl
orders__total_wrapping NUMERIC orders.total_wrapping orders.total_wrapping
orders__total_wrapping_tax_excl NUMERIC orders.total_wrapping_tax_excl orders.total_wrapping_tax_excl
orders__total_wrapping_tax_incl NUMERIC orders.total_wrapping_tax_incl orders.total_wrapping_tax_incl
orders__valid TEXT orders.valid orders.valid

PrestaShop price_ranges fields

The price_ranges report of the PrestaShop connector includes 4 fields.

ID Type Name Description
price_ranges__delimiter1 TEXT price_ranges.delimiter1 price_ranges.delimiter1
price_ranges__delimiter2 TEXT price_ranges.delimiter2 price_ranges.delimiter2
price_ranges__id TEXT price_ranges.id price_ranges.id
price_ranges__id_carrier TEXT price_ranges.id_carrier price_ranges.id_carrier

PrestaShop product_customization_fields fields

The product_customization_fields report of the PrestaShop connector includes 7 fields.

ID Type Name Description
product_customization_fields__id TEXT product_customization_fields.id product_customization_fields.id
product_customization_fields__id_product TEXT product_customization_fields.id_product product_customization_fields.id_product
product_customization_fields__is_deleted TEXT product_customization_fields.is_deleted product_customization_fields.is_deleted
product_customization_fields__is_module TEXT product_customization_fields.is_module product_customization_fields.is_module
product_customization_fields__name TEXT product_customization_fields.name product_customization_fields.name
product_customization_fields__required TEXT product_customization_fields.required product_customization_fields.required
product_customization_fields__type TEXT product_customization_fields.type product_customization_fields.type

PrestaShop product_feature_values fields

The product_feature_values report of the PrestaShop connector includes 4 fields.

ID Type Name Description
product_feature_values__custom TEXT product_feature_values.custom product_feature_values.custom
product_feature_values__id TEXT product_feature_values.id product_feature_values.id
product_feature_values__id_feature TEXT product_feature_values.id_feature product_feature_values.id_feature
product_feature_values__value TEXT product_feature_values.value product_feature_values.value

PrestaShop product_features fields

The product_features report of the PrestaShop connector includes 3 fields.

ID Type Name Description
product_features__id TEXT product_features.id product_features.id
product_features__name TEXT product_features.name product_features.name
product_features__position TEXT product_features.position product_features.position

PrestaShop product_option_values fields

The product_option_values report of the PrestaShop connector includes 5 fields.

ID Type Name Description
product_option_values__color TEXT product_option_values.color product_option_values.color
product_option_values__id TEXT product_option_values.id product_option_values.id
product_option_values__id_attribute_group TEXT product_option_values.id_attribute_group product_option_values.id_attribute_group
product_option_values__name TEXT product_option_values.name product_option_values.name
product_option_values__position TEXT product_option_values.position product_option_values.position

PrestaShop product_options fields

The product_options report of the PrestaShop connector includes 7 fields.

ID Type Name Description
product_options__associations OBJECT product_options.associations product_options.associations
product_options__group_type TEXT product_options.group_type product_options.group_type
product_options__id TEXT product_options.id product_options.id
product_options__is_color_group TEXT product_options.is_color_group product_options.is_color_group
product_options__name TEXT product_options.name product_options.name
product_options__position TEXT product_options.position product_options.position
product_options__public_name TEXT product_options.public_name product_options.public_name

PrestaShop product_suppliers fields

The product_suppliers report of the PrestaShop connector includes 7 fields.

ID Type Name Description
product_suppliers__id TEXT product_suppliers.id product_suppliers.id
product_suppliers__id_currency TEXT product_suppliers.id_currency product_suppliers.id_currency
product_suppliers__id_product TEXT product_suppliers.id_product product_suppliers.id_product
product_suppliers__id_product_attribute TEXT product_suppliers.id_product_attribute product_suppliers.id_product_attribute
product_suppliers__id_supplier TEXT product_suppliers.id_supplier product_suppliers.id_supplier
product_suppliers__product_supplier_price_te TEXT product_suppliers.product_supplier_price_te product_suppliers.product_supplier_price_te
product_suppliers__product_supplier_reference TEXT product_suppliers.product_supplier_reference product_suppliers.product_supplier_reference

PrestaShop products fields

The products report of the PrestaShop connector includes 71 fields.

PrestaShop products fields (products__active to products__low_stock_threshold)

ID Type Name Description
products__active TEXT products.active products.active
products__additional_delivery_times TEXT products.additional_delivery_times products.additional_delivery_times
products__additional_shipping_cost NUMERIC products.additional_shipping_cost products.additional_shipping_cost
products__advanced_stock_management TEXT products.advanced_stock_management products.advanced_stock_management
products__associations OBJECT products.associations products.associations
products__available_date DATE products.available_date products.available_date
products__available_for_order TEXT products.available_for_order products.available_for_order
products__available_later TEXT products.available_later products.available_later
products__available_now TEXT products.available_now products.available_now
products__cache_default_attribute TEXT products.cache_default_attribute products.cache_default_attribute
products__cache_has_attachments TEXT products.cache_has_attachments products.cache_has_attachments
products__cache_is_pack TEXT products.cache_is_pack products.cache_is_pack
products__condition TEXT products.condition products.condition
products__customizable TEXT products.customizable products.customizable
products__date_add TIMESTAMP products.date_add products.date_add
products__date_upd TIMESTAMP products.date_upd products.date_upd
products__delivery_in_stock TEXT products.delivery_in_stock products.delivery_in_stock
products__delivery_out_stock TEXT products.delivery_out_stock products.delivery_out_stock
products__depth NUMERIC products.depth products.depth
products__description TEXT products.description products.description
products__description_short TEXT products.description_short products.description_short
products__ean13 TEXT products.ean13 products.ean13
products__ecotax TEXT products.ecotax products.ecotax
products__height NUMERIC products.height products.height
products__id TEXT products.id products.id
products__id_category_default TEXT products.id_category_default products.id_category_default
products__id_default_combination TEXT products.id_default_combination products.id_default_combination
products__id_default_image TEXT products.id_default_image products.id_default_image
products__id_manufacturer TEXT products.id_manufacturer products.id_manufacturer
products__id_shop_default TEXT products.id_shop_default products.id_shop_default
products__id_supplier TEXT products.id_supplier products.id_supplier
products__id_tax_rules_group TEXT products.id_tax_rules_group products.id_tax_rules_group
products__id_type_redirected TEXT products.id_type_redirected products.id_type_redirected
products__indexed TEXT products.indexed products.indexed
products__is_virtual TEXT products.is_virtual products.is_virtual
products__isbn TEXT products.isbn products.isbn
products__link_rewrite TEXT products.link_rewrite products.link_rewrite
products__location TEXT products.location products.location
products__low_stock_alert TEXT products.low_stock_alert products.low_stock_alert
products__low_stock_threshold TEXT products.low_stock_threshold products.low_stock_threshold

PrestaShop products fields (products__manufacturer_name to products__width)

ID Type Name Description
products__manufacturer_name TEXT products.manufacturer_name products.manufacturer_name
products__meta_description TEXT products.meta_description products.meta_description
products__meta_keywords TEXT products.meta_keywords products.meta_keywords
products__meta_title TEXT products.meta_title products.meta_title
products__minimal_quantity TEXT products.minimal_quantity products.minimal_quantity
products__mpn TEXT products.mpn products.mpn
products__name TEXT products.name products.name
products__new TEXT products.new products.new
products__on_sale BOOLEAN products.on_sale products.on_sale
products__online_only TEXT products.online_only products.online_only
products__pack_stock_type TEXT products.pack_stock_type products.pack_stock_type
products__position_in_category TEXT products.position_in_category products.position_in_category
products__price NUMERIC products.price products.price
products__quantity NUMERIC products.quantity products.quantity
products__quantity_discount NUMERIC products.quantity_discount products.quantity_discount
products__redirect_type TEXT products.redirect_type products.redirect_type
products__reference TEXT products.reference products.reference
products__show_condition TEXT products.show_condition products.show_condition
products__show_price TEXT products.show_price products.show_price
products__state TEXT products.state products.state
products__supplier_reference TEXT products.supplier_reference products.supplier_reference
products__text_fields TEXT products.text_fields products.text_fields
products__type TEXT products.type products.type
products__unit_price_ratio NUMERIC products.unit_price_ratio products.unit_price_ratio
products__unity TEXT products.unity products.unity
products__upc TEXT products.upc products.upc
products__uploadable_files TEXT products.uploadable_files products.uploadable_files
products__visibility TEXT products.visibility products.visibility
products__weight NUMERIC products.weight products.weight
products__wholesale_price NUMERIC products.wholesale_price products.wholesale_price
products__width NUMERIC products.width products.width

PrestaShop shop_groups fields

The shop_groups report of the PrestaShop connector includes 7 fields.

ID Type Name Description
shop_groups__active TEXT shop_groups.active shop_groups.active
shop_groups__deleted TEXT shop_groups.deleted shop_groups.deleted
shop_groups__id TEXT shop_groups.id shop_groups.id
shop_groups__name TEXT shop_groups.name shop_groups.name
shop_groups__share_customer TEXT shop_groups.share_customer shop_groups.share_customer
shop_groups__share_order TEXT shop_groups.share_order shop_groups.share_order
shop_groups__share_stock TEXT shop_groups.share_stock shop_groups.share_stock

PrestaShop shop_urls fields

The shop_urls report of the PrestaShop connector includes 8 fields.

ID Type Name Description
shop_urls__active TEXT shop_urls.active shop_urls.active
shop_urls__domain TEXT shop_urls.domain shop_urls.domain
shop_urls__domain_ssl TEXT shop_urls.domain_ssl shop_urls.domain_ssl
shop_urls__id TEXT shop_urls.id shop_urls.id
shop_urls__id_shop TEXT shop_urls.id_shop shop_urls.id_shop
shop_urls__main TEXT shop_urls.main shop_urls.main
shop_urls__physical_uri TEXT shop_urls.physical_uri shop_urls.physical_uri
shop_urls__virtual_uri TEXT shop_urls.virtual_uri shop_urls.virtual_uri

PrestaShop shops fields

The shops report of the PrestaShop connector includes 7 fields.

ID Type Name Description
shops__active TEXT shops.active shops.active
shops__deleted TEXT shops.deleted shops.deleted
shops__id TEXT shops.id shops.id
shops__id_category TEXT shops.id_category shops.id_category
shops__id_shop_group TEXT shops.id_shop_group shops.id_shop_group
shops__name TEXT shops.name shops.name
shops__theme_name TEXT shops.theme_name shops.theme_name

PrestaShop specific_price_rules fields

The specific_price_rules report of the PrestaShop connector includes 13 fields.

ID Type Name Description
specific_price_rules__from TEXT specific_price_rules.from specific_price_rules.from
specific_price_rules__from_quantity TEXT specific_price_rules.from_quantity specific_price_rules.from_quantity
specific_price_rules__id TEXT specific_price_rules.id specific_price_rules.id
specific_price_rules__id_country COUNTRY specific_price_rules.id_country specific_price_rules.id_country
specific_price_rules__id_currency TEXT specific_price_rules.id_currency specific_price_rules.id_currency
specific_price_rules__id_group TEXT specific_price_rules.id_group specific_price_rules.id_group
specific_price_rules__id_shop TEXT specific_price_rules.id_shop specific_price_rules.id_shop
specific_price_rules__name TEXT specific_price_rules.name specific_price_rules.name
specific_price_rules__price NUMERIC specific_price_rules.price specific_price_rules.price
specific_price_rules__reduction TEXT specific_price_rules.reduction specific_price_rules.reduction
specific_price_rules__reduction_tax TEXT specific_price_rules.reduction_tax specific_price_rules.reduction_tax
specific_price_rules__reduction_type TEXT specific_price_rules.reduction_type specific_price_rules.reduction_type
specific_price_rules__to NUMERIC specific_price_rules.to specific_price_rules.to

PrestaShop specific_prices fields

The specific_prices report of the PrestaShop connector includes 18 fields.

ID Type Name Description
specific_prices__from NUMERIC specific_prices.from specific_prices.from
specific_prices__from_quantity NUMERIC specific_prices.from_quantity specific_prices.from_quantity
specific_prices__id TEXT specific_prices.id specific_prices.id
specific_prices__id_cart TEXT specific_prices.id_cart specific_prices.id_cart
specific_prices__id_country COUNTRY specific_prices.id_country specific_prices.id_country
specific_prices__id_currency TEXT specific_prices.id_currency specific_prices.id_currency
specific_prices__id_customer TEXT specific_prices.id_customer specific_prices.id_customer
specific_prices__id_group TEXT specific_prices.id_group specific_prices.id_group
specific_prices__id_product TEXT specific_prices.id_product specific_prices.id_product
specific_prices__id_product_attribute TEXT specific_prices.id_product_attribute specific_prices.id_product_attribute
specific_prices__id_shop TEXT specific_prices.id_shop specific_prices.id_shop
specific_prices__id_shop_group TEXT specific_prices.id_shop_group specific_prices.id_shop_group
specific_prices__id_specific_price_rule TEXT specific_prices.id_specific_price_rule specific_prices.id_specific_price_rule
specific_prices__price NUMERIC specific_prices.price specific_prices.price
specific_prices__reduction TEXT specific_prices.reduction specific_prices.reduction
specific_prices__reduction_tax TEXT specific_prices.reduction_tax specific_prices.reduction_tax
specific_prices__reduction_type TEXT specific_prices.reduction_type specific_prices.reduction_type
specific_prices__to TEXT specific_prices.to specific_prices.to

PrestaShop states fields

The states report of the PrestaShop connector includes 6 fields.

ID Type Name Description
states__active TEXT states.active states.active
states__id TEXT states.id states.id
states__id_country COUNTRY states.id_country states.id_country
states__id_zone TEXT states.id_zone states.id_zone
states__iso_code TEXT states.iso_code states.iso_code
states__name TEXT states.name states.name

PrestaShop stock_availables fields

The stock_availables report of the PrestaShop connector includes 9 fields.

ID Type Name Description
stock_availables__depends_on_stock TEXT stock_availables.depends_on_stock stock_availables.depends_on_stock
stock_availables__id TEXT stock_availables.id stock_availables.id
stock_availables__id_product TEXT stock_availables.id_product stock_availables.id_product
stock_availables__id_product_attribute TEXT stock_availables.id_product_attribute stock_availables.id_product_attribute
stock_availables__id_shop TEXT stock_availables.id_shop stock_availables.id_shop
stock_availables__id_shop_group TEXT stock_availables.id_shop_group stock_availables.id_shop_group
stock_availables__location TEXT stock_availables.location stock_availables.location
stock_availables__out_of_stock TEXT stock_availables.out_of_stock stock_availables.out_of_stock
stock_availables__quantity NUMERIC stock_availables.quantity stock_availables.quantity

PrestaShop stock_movement_reasons fields

The stock_movement_reasons report of the PrestaShop connector includes 6 fields.

ID Type Name Description
stock_movement_reasons__date_add TIMESTAMP stock_movement_reasons.date_add stock_movement_reasons.date_add
stock_movement_reasons__date_upd TIMESTAMP stock_movement_reasons.date_upd stock_movement_reasons.date_upd
stock_movement_reasons__deleted TEXT stock_movement_reasons.deleted stock_movement_reasons.deleted
stock_movement_reasons__id TEXT stock_movement_reasons.id stock_movement_reasons.id
stock_movement_reasons__name TEXT stock_movement_reasons.name stock_movement_reasons.name
stock_movement_reasons__sign TEXT stock_movement_reasons.sign stock_movement_reasons.sign

PrestaShop stock_movements fields

The stock_movements report of the PrestaShop connector includes 22 fields.

ID Type Name Description
stock_movements__current_wa TEXT stock_movements.current_wa stock_movements.current_wa
stock_movements__date_add TIMESTAMP stock_movements.date_add stock_movements.date_add
stock_movements__ean13 TEXT stock_movements.ean13 stock_movements.ean13
stock_movements__id TEXT stock_movements.id stock_movements.id
stock_movements__id_currency TEXT stock_movements.id_currency stock_movements.id_currency
stock_movements__id_employee TEXT stock_movements.id_employee stock_movements.id_employee
stock_movements__id_order TEXT stock_movements.id_order stock_movements.id_order
stock_movements__id_product TEXT stock_movements.id_product stock_movements.id_product
stock_movements__id_product_attribute TEXT stock_movements.id_product_attribute stock_movements.id_product_attribute
stock_movements__id_stock TEXT stock_movements.id_stock stock_movements.id_stock
stock_movements__id_stock_mvt_reason TEXT stock_movements.id_stock_mvt_reason stock_movements.id_stock_mvt_reason
stock_movements__id_supply_order TEXT stock_movements.id_supply_order stock_movements.id_supply_order
stock_movements__id_warehouse TEXT stock_movements.id_warehouse stock_movements.id_warehouse
stock_movements__last_wa TEXT stock_movements.last_wa stock_movements.last_wa
stock_movements__management_type TEXT stock_movements.management_type stock_movements.management_type
stock_movements__mpn TEXT stock_movements.mpn stock_movements.mpn
stock_movements__physical_quantity NUMERIC stock_movements.physical_quantity stock_movements.physical_quantity
stock_movements__price_te TEXT stock_movements.price_te stock_movements.price_te
stock_movements__product_name BOOLEAN stock_movements.product_name stock_movements.product_name
stock_movements__reference TEXT stock_movements.reference stock_movements.reference
stock_movements__sign TEXT stock_movements.sign stock_movements.sign
stock_movements__upc TEXT stock_movements.upc stock_movements.upc

PrestaShop stores fields

The stores report of the PrestaShop connector includes 18 fields.

ID Type Name Description
stores__active TEXT stores.active stores.active
stores__address1 TEXT stores.address1 stores.address1
stores__address2 TEXT stores.address2 stores.address2
stores__city CITY stores.city stores.city
stores__date_add TIMESTAMP stores.date_add stores.date_add
stores__date_upd TIMESTAMP stores.date_upd stores.date_upd
stores__email TEXT stores.email stores.email
stores__fax TEXT stores.fax stores.fax
stores__hours TEXT stores.hours stores.hours
stores__id TEXT stores.id stores.id
stores__id_country COUNTRY stores.id_country stores.id_country
stores__id_state TEXT stores.id_state stores.id_state
stores__latitude TEXT stores.latitude stores.latitude
stores__longitude TEXT stores.longitude stores.longitude
stores__name TEXT stores.name stores.name
stores__note TEXT stores.note stores.note
stores__phone TEXT stores.phone stores.phone
stores__postcode TEXT stores.postcode stores.postcode

PrestaShop suppliers fields

The suppliers report of the PrestaShop connector includes 10 fields.

ID Type Name Description
suppliers__active TEXT suppliers.active suppliers.active
suppliers__date_add TIMESTAMP suppliers.date_add suppliers.date_add
suppliers__date_upd TIMESTAMP suppliers.date_upd suppliers.date_upd
suppliers__description TEXT suppliers.description suppliers.description
suppliers__id TEXT suppliers.id suppliers.id
suppliers__link_rewrite TEXT suppliers.link_rewrite suppliers.link_rewrite
suppliers__meta_description TEXT suppliers.meta_description suppliers.meta_description
suppliers__meta_keywords TEXT suppliers.meta_keywords suppliers.meta_keywords
suppliers__meta_title TEXT suppliers.meta_title suppliers.meta_title
suppliers__name TEXT suppliers.name suppliers.name

PrestaShop tags fields

The tags report of the PrestaShop connector includes 3 fields.

ID Type Name Description
tags__id TEXT tags.id tags.id
tags__id_lang TEXT tags.id_lang tags.id_lang
tags__name TEXT tags.name tags.name

PrestaShop tax_rule_groups fields

The tax_rule_groups report of the PrestaShop connector includes 6 fields.

ID Type Name Description
tax_rule_groups__active TEXT tax_rule_groups.active tax_rule_groups.active
tax_rule_groups__date_add TIMESTAMP tax_rule_groups.date_add tax_rule_groups.date_add
tax_rule_groups__date_upd TIMESTAMP tax_rule_groups.date_upd tax_rule_groups.date_upd
tax_rule_groups__deleted TEXT tax_rule_groups.deleted tax_rule_groups.deleted
tax_rule_groups__id TEXT tax_rule_groups.id tax_rule_groups.id
tax_rule_groups__name TEXT tax_rule_groups.name tax_rule_groups.name

PrestaShop tax_rules fields

The tax_rules report of the PrestaShop connector includes 9 fields.

ID Type Name Description
tax_rules__behavior TEXT tax_rules.behavior tax_rules.behavior
tax_rules__description TEXT tax_rules.description tax_rules.description
tax_rules__id TEXT tax_rules.id tax_rules.id
tax_rules__id_country COUNTRY tax_rules.id_country tax_rules.id_country
tax_rules__id_state TEXT tax_rules.id_state tax_rules.id_state
tax_rules__id_tax TEXT tax_rules.id_tax tax_rules.id_tax
tax_rules__id_tax_rules_group TEXT tax_rules.id_tax_rules_group tax_rules.id_tax_rules_group
tax_rules__zipcode_from TEXT tax_rules.zipcode_from tax_rules.zipcode_from
tax_rules__zipcode_to TEXT tax_rules.zipcode_to tax_rules.zipcode_to

PrestaShop taxes fields

The taxes report of the PrestaShop connector includes 5 fields.

ID Type Name Description
taxes__active TEXT taxes.active taxes.active
taxes__deleted TEXT taxes.deleted taxes.deleted
taxes__id TEXT taxes.id taxes.id
taxes__name TEXT taxes.name taxes.name
taxes__rate TEXT taxes.rate taxes.rate

PrestaShop translated_configurations fields

The translated_configurations report of the PrestaShop connector includes 7 fields.

ID Type Name Description
translated_configurations__date_add TIMESTAMP translated_configurations.date_add translated_configurations.date_add
translated_configurations__date_upd TIMESTAMP translated_configurations.date_upd translated_configurations.date_upd
translated_configurations__id TEXT translated_configurations.id translated_configurations.id
translated_configurations__id_shop TEXT translated_configurations.id_shop translated_configurations.id_shop
translated_configurations__id_shop_group TEXT translated_configurations.id_shop_group translated_configurations.id_shop_group
translated_configurations__name TEXT translated_configurations.name translated_configurations.name
translated_configurations__value TEXT translated_configurations.value translated_configurations.value

PrestaShop weight_ranges fields

The weight_ranges report of the PrestaShop connector includes 4 fields.

ID Type Name Description
weight_ranges__delimiter1 TEXT weight_ranges.delimiter1 weight_ranges.delimiter1
weight_ranges__delimiter2 TEXT weight_ranges.delimiter2 weight_ranges.delimiter2
weight_ranges__id TEXT weight_ranges.id weight_ranges.id
weight_ranges__id_carrier TEXT weight_ranges.id_carrier weight_ranges.id_carrier

PrestaShop zones fields

The zones report of the PrestaShop connector includes 3 fields.

ID Type Name Description
zones__active TEXT zones.active zones.active
zones__id TEXT zones.id zones.id
zones__name TEXT zones.name zones.name

PrestaShop other fields

The PrestaShop connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID Account ID.
account_name TEXT Account Name Account name.
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date Date.
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20