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 metrics712 dimensions
Fields

The PrestaShop connector exposes 798 fields (86 metrics, 712 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.

IDTypeNameDescription
addresses__address1TEXTaddresses.address1addresses.address1
addresses__address2TEXTaddresses.address2addresses.address2
addresses__aliasTEXTaddresses.aliasaddresses.alias
addresses__cityCITYaddresses.cityaddresses.city
addresses__companyTEXTaddresses.companyaddresses.company
addresses__date_addTIMESTAMPaddresses.date_addaddresses.date_add
addresses__date_updTIMESTAMPaddresses.date_updaddresses.date_upd
addresses__deletedTEXTaddresses.deletedaddresses.deleted
addresses__dniTEXTaddresses.dniaddresses.dni
addresses__firstnameTEXTaddresses.firstnameaddresses.firstname
addresses__idTEXTaddresses.idaddresses.id
addresses__id_countryCOUNTRYaddresses.id_countryaddresses.id_country
addresses__id_customerTEXTaddresses.id_customeraddresses.id_customer
addresses__id_manufacturerTEXTaddresses.id_manufactureraddresses.id_manufacturer
addresses__id_stateTEXTaddresses.id_stateaddresses.id_state
addresses__id_supplierTEXTaddresses.id_supplieraddresses.id_supplier
addresses__id_warehouseTEXTaddresses.id_warehouseaddresses.id_warehouse
addresses__lastnameTEXTaddresses.lastnameaddresses.lastname
addresses__otherTEXTaddresses.otheraddresses.other
addresses__phoneTEXTaddresses.phoneaddresses.phone
addresses__phone_mobileTEXTaddresses.phone_mobileaddresses.phone_mobile
addresses__postcodeTEXTaddresses.postcodeaddresses.postcode
addresses__vat_numberTEXTaddresses.vat_numberaddresses.vat_number

PrestaShop carriers fields

The carriers report of the PrestaShop connector includes 22 fields.

IDTypeNameDescription
carriers__activeTEXTcarriers.activecarriers.active
carriers__delayTEXTcarriers.delaycarriers.delay
carriers__deletedTEXTcarriers.deletedcarriers.deleted
carriers__external_module_nameTEXTcarriers.external_module_namecarriers.external_module_name
carriers__gradeTEXTcarriers.gradecarriers.grade
carriers__idTEXTcarriers.idcarriers.id
carriers__id_referenceTEXTcarriers.id_referencecarriers.id_reference
carriers__id_tax_rules_groupTEXTcarriers.id_tax_rules_groupcarriers.id_tax_rules_group
carriers__is_freeTEXTcarriers.is_freecarriers.is_free
carriers__is_moduleTEXTcarriers.is_modulecarriers.is_module
carriers__max_depthNUMERICcarriers.max_depthcarriers.max_depth
carriers__max_heightNUMERICcarriers.max_heightcarriers.max_height
carriers__max_weightNUMERICcarriers.max_weightcarriers.max_weight
carriers__max_widthNUMERICcarriers.max_widthcarriers.max_width
carriers__nameTEXTcarriers.namecarriers.name
carriers__need_rangeTEXTcarriers.need_rangecarriers.need_range
carriers__positionTEXTcarriers.positioncarriers.position
carriers__range_behaviorTEXTcarriers.range_behaviorcarriers.range_behavior
carriers__shipping_externalTEXTcarriers.shipping_externalcarriers.shipping_external
carriers__shipping_handlingTEXTcarriers.shipping_handlingcarriers.shipping_handling
carriers__shipping_methodTEXTcarriers.shipping_methodcarriers.shipping_method
carriers__urlTEXTcarriers.urlcarriers.url

PrestaShop cart_rules fields

The cart_rules report of the PrestaShop connector includes 34 fields.

IDTypeNameDescription
cart_rules__activeTEXTcart_rules.activecart_rules.active
cart_rules__carrier_restrictionTEXTcart_rules.carrier_restrictioncart_rules.carrier_restriction
cart_rules__cart_rule_restrictionTEXTcart_rules.cart_rule_restrictioncart_rules.cart_rule_restriction
cart_rules__codeTEXTcart_rules.codecart_rules.code
cart_rules__country_restrictionTEXTcart_rules.country_restrictioncart_rules.country_restriction
cart_rules__date_addTIMESTAMPcart_rules.date_addcart_rules.date_add
cart_rules__date_fromDATEcart_rules.date_fromcart_rules.date_from
cart_rules__date_toDATEcart_rules.date_tocart_rules.date_to
cart_rules__date_updTIMESTAMPcart_rules.date_updcart_rules.date_upd
cart_rules__descriptionTEXTcart_rules.descriptioncart_rules.description
cart_rules__free_shippingTEXTcart_rules.free_shippingcart_rules.free_shipping
cart_rules__gift_productTEXTcart_rules.gift_productcart_rules.gift_product
cart_rules__gift_product_attributeTEXTcart_rules.gift_product_attributecart_rules.gift_product_attribute
cart_rules__group_restrictionTEXTcart_rules.group_restrictioncart_rules.group_restriction
cart_rules__highlightTEXTcart_rules.highlightcart_rules.highlight
cart_rules__idTEXTcart_rules.idcart_rules.id
cart_rules__id_customerTEXTcart_rules.id_customercart_rules.id_customer
cart_rules__minimum_amountNUMERICcart_rules.minimum_amountcart_rules.minimum_amount
cart_rules__minimum_amount_currencyNUMERICcart_rules.minimum_amount_currencycart_rules.minimum_amount_currency
cart_rules__minimum_amount_shippingNUMERICcart_rules.minimum_amount_shippingcart_rules.minimum_amount_shipping
cart_rules__minimum_amount_taxNUMERICcart_rules.minimum_amount_taxcart_rules.minimum_amount_tax
cart_rules__nameTEXTcart_rules.namecart_rules.name
cart_rules__partial_useTEXTcart_rules.partial_usecart_rules.partial_use
cart_rules__priorityTEXTcart_rules.prioritycart_rules.priority
cart_rules__product_restrictionTEXTcart_rules.product_restrictioncart_rules.product_restriction
cart_rules__quantityNUMERICcart_rules.quantitycart_rules.quantity
cart_rules__quantity_per_userTEXTcart_rules.quantity_per_usercart_rules.quantity_per_user
cart_rules__reduction_amountNUMERICcart_rules.reduction_amountcart_rules.reduction_amount
cart_rules__reduction_currencyTEXTcart_rules.reduction_currencycart_rules.reduction_currency
cart_rules__reduction_exclude_specialTEXTcart_rules.reduction_exclude_specialcart_rules.reduction_exclude_special
cart_rules__reduction_percentTEXTcart_rules.reduction_percentcart_rules.reduction_percent
cart_rules__reduction_productTEXTcart_rules.reduction_productcart_rules.reduction_product
cart_rules__reduction_taxTEXTcart_rules.reduction_taxcart_rules.reduction_tax
cart_rules__shop_restrictionTEXTcart_rules.shop_restrictioncart_rules.shop_restriction

PrestaShop carts fields

The carts report of the PrestaShop connector includes 20 fields.

IDTypeNameDescription
carts__allow_seperated_packageTEXTcarts.allow_seperated_packagecarts.allow_seperated_package
carts__associationsOBJECTcarts.associationscarts.associations
carts__date_addTIMESTAMPcarts.date_addcarts.date_add
carts__date_updTIMESTAMPcarts.date_updcarts.date_upd
carts__delivery_optionTEXTcarts.delivery_optioncarts.delivery_option
carts__giftTEXTcarts.giftcarts.gift
carts__gift_messageTEXTcarts.gift_messagecarts.gift_message
carts__idTEXTcarts.idcarts.id
carts__id_address_deliveryTEXTcarts.id_address_deliverycarts.id_address_delivery
carts__id_address_invoiceTEXTcarts.id_address_invoicecarts.id_address_invoice
carts__id_carrierTEXTcarts.id_carriercarts.id_carrier
carts__id_currencyTEXTcarts.id_currencycarts.id_currency
carts__id_customerTEXTcarts.id_customercarts.id_customer
carts__id_guestTEXTcarts.id_guestcarts.id_guest
carts__id_langTEXTcarts.id_langcarts.id_lang
carts__id_shopTEXTcarts.id_shopcarts.id_shop
carts__id_shop_groupTEXTcarts.id_shop_groupcarts.id_shop_group
carts__mobile_themeTEXTcarts.mobile_themecarts.mobile_theme
carts__recyclableTEXTcarts.recyclablecarts.recyclable
carts__secure_keyTEXTcarts.secure_keycarts.secure_key

PrestaShop categories fields

The categories report of the PrestaShop connector includes 17 fields.

IDTypeNameDescription
categories__activeTEXTcategories.activecategories.active
categories__associationsOBJECTcategories.associationscategories.associations
categories__date_addTIMESTAMPcategories.date_addcategories.date_add
categories__date_updTIMESTAMPcategories.date_updcategories.date_upd
categories__descriptionTEXTcategories.descriptioncategories.description
categories__idTEXTcategories.idcategories.id
categories__id_parentTEXTcategories.id_parentcategories.id_parent
categories__id_shop_defaultTEXTcategories.id_shop_defaultcategories.id_shop_default
categories__is_root_categoryTEXTcategories.is_root_categorycategories.is_root_category
categories__level_depthTEXTcategories.level_depthcategories.level_depth
categories__link_rewriteTEXTcategories.link_rewritecategories.link_rewrite
categories__meta_descriptionTEXTcategories.meta_descriptioncategories.meta_description
categories__meta_keywordsTEXTcategories.meta_keywordscategories.meta_keywords
categories__meta_titleTEXTcategories.meta_titlecategories.meta_title
categories__nameTEXTcategories.namecategories.name
categories__nb_products_recursiveTEXTcategories.nb_products_recursivecategories.nb_products_recursive
categories__positionTEXTcategories.positioncategories.position

PrestaShop combinations fields

The combinations report of the PrestaShop connector includes 21 fields.

IDTypeNameDescription
combinations__associationsOBJECTcombinations.associationscombinations.associations
combinations__available_dateDATEcombinations.available_datecombinations.available_date
combinations__default_onTEXTcombinations.default_oncombinations.default_on
combinations__ean13TEXTcombinations.ean13combinations.ean13
combinations__ecotaxTEXTcombinations.ecotaxcombinations.ecotax
combinations__idTEXTcombinations.idcombinations.id
combinations__id_productTEXTcombinations.id_productcombinations.id_product
combinations__isbnTEXTcombinations.isbncombinations.isbn
combinations__locationTEXTcombinations.locationcombinations.location
combinations__low_stock_alertTEXTcombinations.low_stock_alertcombinations.low_stock_alert
combinations__low_stock_thresholdTEXTcombinations.low_stock_thresholdcombinations.low_stock_threshold
combinations__minimal_quantityNUMERICcombinations.minimal_quantitycombinations.minimal_quantity
combinations__mpnTEXTcombinations.mpncombinations.mpn
combinations__priceNUMERICcombinations.pricecombinations.price
combinations__quantityNUMERICcombinations.quantitycombinations.quantity
combinations__referenceTEXTcombinations.referencecombinations.reference
combinations__supplier_referenceTEXTcombinations.supplier_referencecombinations.supplier_reference
combinations__unit_price_impactTEXTcombinations.unit_price_impactcombinations.unit_price_impact
combinations__upcTEXTcombinations.upccombinations.upc
combinations__weightNUMERICcombinations.weightcombinations.weight
combinations__wholesale_priceNUMERICcombinations.wholesale_pricecombinations.wholesale_price

PrestaShop configurations fields

The configurations report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
configurations__date_addTIMESTAMPconfigurations.date_addconfigurations.date_add
configurations__date_updTIMESTAMPconfigurations.date_updconfigurations.date_upd
configurations__idTEXTconfigurations.idconfigurations.id
configurations__id_shopTEXTconfigurations.id_shopconfigurations.id_shop
configurations__id_shop_groupTEXTconfigurations.id_shop_groupconfigurations.id_shop_group
configurations__nameTEXTconfigurations.nameconfigurations.name
configurations__valueTEXTconfigurations.valueconfigurations.value

PrestaShop contacts fields

The contacts report of the PrestaShop connector includes 5 fields.

IDTypeNameDescription
contacts__customer_serviceTEXTcontacts.customer_servicecontacts.customer_service
contacts__descriptionTEXTcontacts.descriptioncontacts.description
contacts__emailTEXTcontacts.emailcontacts.email
contacts__idTEXTcontacts.idcontacts.id
contacts__nameTEXTcontacts.namecontacts.name

PrestaShop content_management_system fields

The content_management_system report of the PrestaShop connector includes 11 fields.

IDTypeNameDescription
content_management_system__activeTEXTcontent_management_system.activecontent_management_system.active
content_management_system__contentTEXTcontent_management_system.contentcontent_management_system.content
content_management_system__head_seo_titleTEXTcontent_management_system.head_seo_titlecontent_management_system.head_seo_title
content_management_system__idTEXTcontent_management_system.idcontent_management_system.id
content_management_system__id_cms_categoryTEXTcontent_management_system.id_cms_categorycontent_management_system.id_cms_category
content_management_system__indexationTEXTcontent_management_system.indexationcontent_management_system.indexation
content_management_system__link_rewriteTEXTcontent_management_system.link_rewritecontent_management_system.link_rewrite
content_management_system__meta_descriptionTEXTcontent_management_system.meta_descriptioncontent_management_system.meta_description
content_management_system__meta_keywordsTEXTcontent_management_system.meta_keywordscontent_management_system.meta_keywords
content_management_system__meta_titleTEXTcontent_management_system.meta_titlecontent_management_system.meta_title
content_management_system__positionTEXTcontent_management_system.positioncontent_management_system.position

PrestaShop countries fields

The countries report of the PrestaShop connector includes 12 fields.

IDTypeNameDescription
countries__activeTEXTcountries.activecountries.active
countries__call_prefixTEXTcountries.call_prefixcountries.call_prefix
countries__contains_statesTEXTcountries.contains_statescountries.contains_states
countries__display_tax_labelTEXTcountries.display_tax_labelcountries.display_tax_label
countries__idTEXTcountries.idcountries.id
countries__id_currencyTEXTcountries.id_currencycountries.id_currency
countries__id_zoneTEXTcountries.id_zonecountries.id_zone
countries__iso_codeTEXTcountries.iso_codecountries.iso_code
countries__nameTEXTcountries.namecountries.name
countries__need_identification_numberTEXTcountries.need_identification_numbercountries.need_identification_number
countries__need_zip_codeTEXTcountries.need_zip_codecountries.need_zip_code
countries__zip_code_formatTEXTcountries.zip_code_formatcountries.zip_code_format

PrestaShop currencies fields

The currencies report of the PrestaShop connector includes 13 fields.

IDTypeNameDescription
currencies__activeTEXTcurrencies.activecurrencies.active
currencies__conversion_rateNUMERICcurrencies.conversion_ratecurrencies.conversion_rate
currencies__deletedTEXTcurrencies.deletedcurrencies.deleted
currencies__idTEXTcurrencies.idcurrencies.id
currencies__iso_codeTEXTcurrencies.iso_codecurrencies.iso_code
currencies__modifiedTEXTcurrencies.modifiedcurrencies.modified
currencies__nameTEXTcurrencies.namecurrencies.name
currencies__namesTEXTcurrencies.namescurrencies.names
currencies__numeric_iso_codeTEXTcurrencies.numeric_iso_codecurrencies.numeric_iso_code
currencies__patternTEXTcurrencies.patterncurrencies.pattern
currencies__precisionTEXTcurrencies.precisioncurrencies.precision
currencies__symbolTEXTcurrencies.symbolcurrencies.symbol
currencies__unofficialTEXTcurrencies.unofficialcurrencies.unofficial

PrestaShop customer_messages fields

The customer_messages report of the PrestaShop connector includes 11 fields.

IDTypeNameDescription
customer_messages__date_addTIMESTAMPcustomer_messages.date_addcustomer_messages.date_add
customer_messages__date_updTIMESTAMPcustomer_messages.date_updcustomer_messages.date_upd
customer_messages__file_nameTEXTcustomer_messages.file_namecustomer_messages.file_name
customer_messages__idTEXTcustomer_messages.idcustomer_messages.id
customer_messages__id_customer_threadTEXTcustomer_messages.id_customer_threadcustomer_messages.id_customer_thread
customer_messages__id_employeeTEXTcustomer_messages.id_employeecustomer_messages.id_employee
customer_messages__ip_addressTEXTcustomer_messages.ip_addresscustomer_messages.ip_address
customer_messages__messageTEXTcustomer_messages.messagecustomer_messages.message
customer_messages__privateTEXTcustomer_messages.privatecustomer_messages.private
customer_messages__readTEXTcustomer_messages.readcustomer_messages.read
customer_messages__user_agentTEXTcustomer_messages.user_agentcustomer_messages.user_agent

PrestaShop customer_threads fields

The customer_threads report of the PrestaShop connector includes 13 fields.

IDTypeNameDescription
customer_threads__associationsOBJECTcustomer_threads.associationscustomer_threads.associations
customer_threads__date_addTIMESTAMPcustomer_threads.date_addcustomer_threads.date_add
customer_threads__date_updTIMESTAMPcustomer_threads.date_updcustomer_threads.date_upd
customer_threads__emailTEXTcustomer_threads.emailcustomer_threads.email
customer_threads__idTEXTcustomer_threads.idcustomer_threads.id
customer_threads__id_contactTEXTcustomer_threads.id_contactcustomer_threads.id_contact
customer_threads__id_customerTEXTcustomer_threads.id_customercustomer_threads.id_customer
customer_threads__id_langTEXTcustomer_threads.id_langcustomer_threads.id_lang
customer_threads__id_orderTEXTcustomer_threads.id_ordercustomer_threads.id_order
customer_threads__id_productTEXTcustomer_threads.id_productcustomer_threads.id_product
customer_threads__id_shopTEXTcustomer_threads.id_shopcustomer_threads.id_shop
customer_threads__statusTEXTcustomer_threads.statuscustomer_threads.status
customer_threads__tokenTEXTcustomer_threads.tokencustomer_threads.token

PrestaShop customers fields

The customers report of the PrestaShop connector includes 34 fields.

IDTypeNameDescription
customers__activeTEXTcustomers.activecustomers.active
customers__apeTEXTcustomers.apecustomers.ape
customers__associationsOBJECTcustomers.associationscustomers.associations
customers__birthdayTEXTcustomers.birthdaycustomers.birthday
customers__companyTEXTcustomers.companycustomers.company
customers__date_addTIMESTAMPcustomers.date_addcustomers.date_add
customers__date_updTIMESTAMPcustomers.date_updcustomers.date_upd
customers__deletedTEXTcustomers.deletedcustomers.deleted
customers__emailTEXTcustomers.emailcustomers.email
customers__firstnameTEXTcustomers.firstnamecustomers.firstname
customers__idTEXTcustomers.idcustomers.id
customers__id_default_groupTEXTcustomers.id_default_groupcustomers.id_default_group
customers__id_genderTEXTcustomers.id_gendercustomers.id_gender
customers__id_langTEXTcustomers.id_langcustomers.id_lang
customers__id_riskTEXTcustomers.id_riskcustomers.id_risk
customers__id_shopTEXTcustomers.id_shopcustomers.id_shop
customers__id_shop_groupTEXTcustomers.id_shop_groupcustomers.id_shop_group
customers__ip_registration_newsletterTEXTcustomers.ip_registration_newslettercustomers.ip_registration_newsletter
customers__is_guestTEXTcustomers.is_guestcustomers.is_guest
customers__last_passwd_genTEXTcustomers.last_passwd_gencustomers.last_passwd_gen
customers__lastnameTEXTcustomers.lastnamecustomers.lastname
customers__max_payment_daysTEXTcustomers.max_payment_dayscustomers.max_payment_days
customers__newsletterTEXTcustomers.newslettercustomers.newsletter
customers__newsletter_date_addDATEcustomers.newsletter_date_addcustomers.newsletter_date_add
customers__noteTEXTcustomers.notecustomers.note
customers__optinTEXTcustomers.optincustomers.optin
customers__outstanding_allow_amountTEXTcustomers.outstanding_allow_amountcustomers.outstanding_allow_amount
customers__passwdTEXTcustomers.passwdcustomers.passwd
customers__reset_password_tokenTEXTcustomers.reset_password_tokencustomers.reset_password_token
customers__reset_password_validityTEXTcustomers.reset_password_validitycustomers.reset_password_validity
customers__secure_keyTEXTcustomers.secure_keycustomers.secure_key
customers__show_public_pricesTEXTcustomers.show_public_pricescustomers.show_public_prices
customers__siretTEXTcustomers.siretcustomers.siret
customers__websiteTEXTcustomers.websitecustomers.website

PrestaShop deliveries fields

The deliveries report of the PrestaShop connector includes 8 fields.

IDTypeNameDescription
deliveries__idTEXTdeliveries.iddeliveries.id
deliveries__id_carrierTEXTdeliveries.id_carrierdeliveries.id_carrier
deliveries__id_range_priceTEXTdeliveries.id_range_pricedeliveries.id_range_price
deliveries__id_range_weightTEXTdeliveries.id_range_weightdeliveries.id_range_weight
deliveries__id_shopTEXTdeliveries.id_shopdeliveries.id_shop
deliveries__id_shop_groupTEXTdeliveries.id_shop_groupdeliveries.id_shop_group
deliveries__id_zoneTEXTdeliveries.id_zonedeliveries.id_zone
deliveries__priceNUMERICdeliveries.pricedeliveries.price

PrestaShop employees fields

The employees report of the PrestaShop connector includes 26 fields.

IDTypeNameDescription
employees__activeTEXTemployees.activeemployees.active
employees__bo_colorTEXTemployees.bo_coloremployees.bo_color
employees__bo_cssTEXTemployees.bo_cssemployees.bo_css
employees__bo_menuTEXTemployees.bo_menuemployees.bo_menu
employees__bo_themeTEXTemployees.bo_themeemployees.bo_theme
employees__bo_widthTEXTemployees.bo_widthemployees.bo_width
employees__default_tabTEXTemployees.default_tabemployees.default_tab
employees__emailTEXTemployees.emailemployees.email
employees__firstnameTEXTemployees.firstnameemployees.firstname
employees__idTEXTemployees.idemployees.id
employees__id_langTEXTemployees.id_langemployees.id_lang
employees__id_last_customerTEXTemployees.id_last_customeremployees.id_last_customer
employees__id_last_customer_messageTEXTemployees.id_last_customer_messageemployees.id_last_customer_message
employees__id_last_orderTEXTemployees.id_last_orderemployees.id_last_order
employees__id_profileTEXTemployees.id_profileemployees.id_profile
employees__last_passwd_genTEXTemployees.last_passwd_genemployees.last_passwd_gen
employees__lastnameTEXTemployees.lastnameemployees.lastname
employees__passwdTEXTemployees.passwdemployees.passwd
employees__preselect_date_rangeTEXTemployees.preselect_date_rangeemployees.preselect_date_range
employees__reset_password_tokenTEXTemployees.reset_password_tokenemployees.reset_password_token
employees__reset_password_validityTEXTemployees.reset_password_validityemployees.reset_password_validity
employees__stats_compare_fromTEXTemployees.stats_compare_fromemployees.stats_compare_from
employees__stats_compare_optionTEXTemployees.stats_compare_optionemployees.stats_compare_option
employees__stats_compare_toTEXTemployees.stats_compare_toemployees.stats_compare_to
employees__stats_date_fromDATEemployees.stats_date_fromemployees.stats_date_from
employees__stats_date_toDATEemployees.stats_date_toemployees.stats_date_to

PrestaShop groups fields

The groups report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
groups__date_addTIMESTAMPgroups.date_addgroups.date_add
groups__date_updTIMESTAMPgroups.date_updgroups.date_upd
groups__idTEXTgroups.idgroups.id
groups__nameTEXTgroups.namegroups.name
groups__price_display_methodTEXTgroups.price_display_methodgroups.price_display_method
groups__reductionTEXTgroups.reductiongroups.reduction
groups__show_pricesTEXTgroups.show_pricesgroups.show_prices

PrestaShop guests fields

The guests report of the PrestaShop connector includes 16 fields.

IDTypeNameDescription
guests__accept_languageTEXTguests.accept_languageguests.accept_language
guests__adobe_directorTEXTguests.adobe_directorguests.adobe_director
guests__adobe_flashTEXTguests.adobe_flashguests.adobe_flash
guests__apple_quicktimeTEXTguests.apple_quicktimeguests.apple_quicktime
guests__idTEXTguests.idguests.id
guests__id_customerTEXTguests.id_customerguests.id_customer
guests__id_operating_systemTEXTguests.id_operating_systemguests.id_operating_system
guests__id_web_browserTEXTguests.id_web_browserguests.id_web_browser
guests__javascriptTEXTguests.javascriptguests.javascript
guests__mobile_themeTEXTguests.mobile_themeguests.mobile_theme
guests__real_playerTEXTguests.real_playerguests.real_player
guests__screen_colorTEXTguests.screen_colorguests.screen_color
guests__screen_resolution_xTEXTguests.screen_resolution_xguests.screen_resolution_x
guests__screen_resolution_yTEXTguests.screen_resolution_yguests.screen_resolution_y
guests__sun_javaTEXTguests.sun_javaguests.sun_java
guests__windows_mediaTEXTguests.windows_mediaguests.windows_media

PrestaShop image_types fields

The image_types report of the PrestaShop connector includes 9 fields.

IDTypeNameDescription
image_types__categoriesTEXTimage_types.categoriesimage_types.categories
image_types__heightTEXTimage_types.heightimage_types.height
image_types__idTEXTimage_types.idimage_types.id
image_types__manufacturersTEXTimage_types.manufacturersimage_types.manufacturers
image_types__nameTEXTimage_types.nameimage_types.name
image_types__productsTEXTimage_types.productsimage_types.products
image_types__storesTEXTimage_types.storesimage_types.stores
image_types__suppliersTEXTimage_types.suppliersimage_types.suppliers
image_types__widthTEXTimage_types.widthimage_types.width

PrestaShop languages fields

The languages report of the PrestaShop connector includes 9 fields.

IDTypeNameDescription
languages__activeTEXTlanguages.activelanguages.active
languages__date_format_fullTEXTlanguages.date_format_fulllanguages.date_format_full
languages__date_format_liteTEXTlanguages.date_format_litelanguages.date_format_lite
languages__idTEXTlanguages.idlanguages.id
languages__is_rtlTEXTlanguages.is_rtllanguages.is_rtl
languages__iso_codeTEXTlanguages.iso_codelanguages.iso_code
languages__language_codeTEXTlanguages.language_codelanguages.language_code
languages__localeTEXTlanguages.localelanguages.locale
languages__nameTEXTlanguages.namelanguages.name

PrestaShop manufacturers fields

The manufacturers report of the PrestaShop connector includes 12 fields.

IDTypeNameDescription
manufacturers__activeTEXTmanufacturers.activemanufacturers.active
manufacturers__associationsOBJECTmanufacturers.associationsmanufacturers.associations
manufacturers__date_addTIMESTAMPmanufacturers.date_addmanufacturers.date_add
manufacturers__date_updTIMESTAMPmanufacturers.date_updmanufacturers.date_upd
manufacturers__descriptionTEXTmanufacturers.descriptionmanufacturers.description
manufacturers__idTEXTmanufacturers.idmanufacturers.id
manufacturers__link_rewriteTEXTmanufacturers.link_rewritemanufacturers.link_rewrite
manufacturers__meta_descriptionTEXTmanufacturers.meta_descriptionmanufacturers.meta_description
manufacturers__meta_keywordsTEXTmanufacturers.meta_keywordsmanufacturers.meta_keywords
manufacturers__meta_titleTEXTmanufacturers.meta_titlemanufacturers.meta_title
manufacturers__nameTEXTmanufacturers.namemanufacturers.name
manufacturers__short_descriptionTEXTmanufacturers.short_descriptionmanufacturers.short_description

PrestaShop messages fields

The messages report of the PrestaShop connector includes 8 fields.

IDTypeNameDescription
messages__date_addTIMESTAMPmessages.date_addmessages.date_add
messages__idTEXTmessages.idmessages.id
messages__id_cartTEXTmessages.id_cartmessages.id_cart
messages__id_customerTEXTmessages.id_customermessages.id_customer
messages__id_employeeTEXTmessages.id_employeemessages.id_employee
messages__id_orderTEXTmessages.id_ordermessages.id_order
messages__messageTEXTmessages.messagemessages.message
messages__privateTEXTmessages.privatemessages.private

PrestaShop order_carriers fields

The order_carriers report of the PrestaShop connector includes 9 fields.

IDTypeNameDescription
order_carriers__date_addTIMESTAMPorder_carriers.date_addorder_carriers.date_add
order_carriers__idTEXTorder_carriers.idorder_carriers.id
order_carriers__id_carrierTEXTorder_carriers.id_carrierorder_carriers.id_carrier
order_carriers__id_orderTEXTorder_carriers.id_orderorder_carriers.id_order
order_carriers__id_order_invoiceTEXTorder_carriers.id_order_invoiceorder_carriers.id_order_invoice
order_carriers__shipping_cost_tax_exclNUMERICorder_carriers.shipping_cost_tax_exclorder_carriers.shipping_cost_tax_excl
order_carriers__shipping_cost_tax_inclNUMERICorder_carriers.shipping_cost_tax_inclorder_carriers.shipping_cost_tax_incl
order_carriers__tracking_numberTEXTorder_carriers.tracking_numberorder_carriers.tracking_number
order_carriers__weightNUMERICorder_carriers.weightorder_carriers.weight

PrestaShop order_details fields

The order_details report of the PrestaShop connector includes 47 fields.

PrestaShop order_details fields (order_details__discount_quantity_applied to order_details__total_price_tax_excl)

IDTypeNameDescription
order_details__discount_quantity_appliedTEXTorder_details.discount_quantity_appliedorder_details.discount_quantity_applied
order_details__download_deadlineTEXTorder_details.download_deadlineorder_details.download_deadline
order_details__download_hashTEXTorder_details.download_hashorder_details.download_hash
order_details__download_nbTEXTorder_details.download_nborder_details.download_nb
order_details__ecotaxNUMERICorder_details.ecotaxorder_details.ecotax
order_details__ecotax_tax_rateNUMERICorder_details.ecotax_tax_rateorder_details.ecotax_tax_rate
order_details__group_reductionTEXTorder_details.group_reductionorder_details.group_reduction
order_details__idTEXTorder_details.idorder_details.id
order_details__id_customizationTEXTorder_details.id_customizationorder_details.id_customization
order_details__id_orderTEXTorder_details.id_orderorder_details.id_order
order_details__id_order_invoiceTEXTorder_details.id_order_invoiceorder_details.id_order_invoice
order_details__id_shopTEXTorder_details.id_shoporder_details.id_shop
order_details__id_tax_rules_groupTEXTorder_details.id_tax_rules_grouporder_details.id_tax_rules_group
order_details__id_warehouseTEXTorder_details.id_warehouseorder_details.id_warehouse
order_details__original_product_priceNUMERICorder_details.original_product_priceorder_details.original_product_price
order_details__original_wholesale_priceNUMERICorder_details.original_wholesale_priceorder_details.original_wholesale_price
order_details__product_attribute_idTEXTorder_details.product_attribute_idorder_details.product_attribute_id
order_details__product_ean13TEXTorder_details.product_ean13order_details.product_ean13
order_details__product_idTEXTorder_details.product_idorder_details.product_id
order_details__product_isbnTEXTorder_details.product_isbnorder_details.product_isbn
order_details__product_mpnTEXTorder_details.product_mpnorder_details.product_mpn
order_details__product_nameTEXTorder_details.product_nameorder_details.product_name
order_details__product_priceNUMERICorder_details.product_priceorder_details.product_price
order_details__product_quantityNUMERICorder_details.product_quantityorder_details.product_quantity
order_details__product_quantity_discountNUMERICorder_details.product_quantity_discountorder_details.product_quantity_discount
order_details__product_quantity_in_stockTEXTorder_details.product_quantity_in_stockorder_details.product_quantity_in_stock
order_details__product_quantity_refundedTEXTorder_details.product_quantity_refundedorder_details.product_quantity_refunded
order_details__product_quantity_reinjectedTEXTorder_details.product_quantity_reinjectedorder_details.product_quantity_reinjected
order_details__product_quantity_returnNUMERICorder_details.product_quantity_returnorder_details.product_quantity_return
order_details__product_referenceTEXTorder_details.product_referenceorder_details.product_reference
order_details__product_supplier_referenceTEXTorder_details.product_supplier_referenceorder_details.product_supplier_reference
order_details__product_upcTEXTorder_details.product_upcorder_details.product_upc
order_details__product_weightNUMERICorder_details.product_weightorder_details.product_weight
order_details__purchase_supplier_priceNUMERICorder_details.purchase_supplier_priceorder_details.purchase_supplier_price
order_details__reduction_amountTEXTorder_details.reduction_amountorder_details.reduction_amount
order_details__reduction_amount_tax_exclTEXTorder_details.reduction_amount_tax_exclorder_details.reduction_amount_tax_excl
order_details__reduction_amount_tax_inclTEXTorder_details.reduction_amount_tax_inclorder_details.reduction_amount_tax_incl
order_details__reduction_percentTEXTorder_details.reduction_percentorder_details.reduction_percent
order_details__tax_computation_methodTEXTorder_details.tax_computation_methodorder_details.tax_computation_method
order_details__total_price_tax_exclNUMERICorder_details.total_price_tax_exclorder_details.total_price_tax_excl

PrestaShop order_details fields (order_details__total_price_tax_incl to order_details__unit_price_tax_incl)

IDTypeNameDescription
order_details__total_price_tax_inclNUMERICorder_details.total_price_tax_inclorder_details.total_price_tax_incl
order_details__total_refunded_tax_exclNUMERICorder_details.total_refunded_tax_exclorder_details.total_refunded_tax_excl
order_details__total_refunded_tax_inclNUMERICorder_details.total_refunded_tax_inclorder_details.total_refunded_tax_incl
order_details__total_shipping_price_tax_exclNUMERICorder_details.total_shipping_price_tax_exclorder_details.total_shipping_price_tax_excl
order_details__total_shipping_price_tax_inclNUMERICorder_details.total_shipping_price_tax_inclorder_details.total_shipping_price_tax_incl
order_details__unit_price_tax_exclNUMERICorder_details.unit_price_tax_exclorder_details.unit_price_tax_excl
order_details__unit_price_tax_inclNUMERICorder_details.unit_price_tax_inclorder_details.unit_price_tax_incl

PrestaShop order_histories fields

The order_histories report of the PrestaShop connector includes 5 fields.

IDTypeNameDescription
order_histories__date_addTIMESTAMPorder_histories.date_addorder_histories.date_add
order_histories__idTEXTorder_histories.idorder_histories.id
order_histories__id_employeeTEXTorder_histories.id_employeeorder_histories.id_employee
order_histories__id_orderTEXTorder_histories.id_orderorder_histories.id_order
order_histories__id_order_stateTEXTorder_histories.id_order_stateorder_histories.id_order_state

PrestaShop order_invoices fields

The order_invoices report of the PrestaShop connector includes 19 fields.

IDTypeNameDescription
order_invoices__date_addTIMESTAMPorder_invoices.date_addorder_invoices.date_add
order_invoices__delivery_dateDATEorder_invoices.delivery_dateorder_invoices.delivery_date
order_invoices__delivery_numberTEXTorder_invoices.delivery_numberorder_invoices.delivery_number
order_invoices__idTEXTorder_invoices.idorder_invoices.id
order_invoices__id_orderTEXTorder_invoices.id_orderorder_invoices.id_order
order_invoices__noteTEXTorder_invoices.noteorder_invoices.note
order_invoices__numberTEXTorder_invoices.numberorder_invoices.number
order_invoices__shipping_tax_computation_methodTEXTorder_invoices.shipping_tax_computation_methodorder_invoices.shipping_tax_computation_method
order_invoices__shop_addressTEXTorder_invoices.shop_addressorder_invoices.shop_address
order_invoices__total_discount_tax_exclNUMERICorder_invoices.total_discount_tax_exclorder_invoices.total_discount_tax_excl
order_invoices__total_discount_tax_inclNUMERICorder_invoices.total_discount_tax_inclorder_invoices.total_discount_tax_incl
order_invoices__total_paid_tax_exclNUMERICorder_invoices.total_paid_tax_exclorder_invoices.total_paid_tax_excl
order_invoices__total_paid_tax_inclNUMERICorder_invoices.total_paid_tax_inclorder_invoices.total_paid_tax_incl
order_invoices__total_productsTEXTorder_invoices.total_productsorder_invoices.total_products
order_invoices__total_products_wtTEXTorder_invoices.total_products_wtorder_invoices.total_products_wt
order_invoices__total_shipping_tax_exclNUMERICorder_invoices.total_shipping_tax_exclorder_invoices.total_shipping_tax_excl
order_invoices__total_shipping_tax_inclNUMERICorder_invoices.total_shipping_tax_inclorder_invoices.total_shipping_tax_incl
order_invoices__total_wrapping_tax_exclNUMERICorder_invoices.total_wrapping_tax_exclorder_invoices.total_wrapping_tax_excl
order_invoices__total_wrapping_tax_inclNUMERICorder_invoices.total_wrapping_tax_inclorder_invoices.total_wrapping_tax_incl

PrestaShop order_payments fields

The order_payments report of the PrestaShop connector includes 12 fields.

IDTypeNameDescription
order_payments__amountNUMERICorder_payments.amountorder_payments.amount
order_payments__card_brandTEXTorder_payments.card_brandorder_payments.card_brand
order_payments__card_expirationTEXTorder_payments.card_expirationorder_payments.card_expiration
order_payments__card_holderTEXTorder_payments.card_holderorder_payments.card_holder
order_payments__card_numberTEXTorder_payments.card_numberorder_payments.card_number
order_payments__conversion_rateTEXTorder_payments.conversion_rateorder_payments.conversion_rate
order_payments__date_addTIMESTAMPorder_payments.date_addorder_payments.date_add
order_payments__idTEXTorder_payments.idorder_payments.id
order_payments__id_currencyTEXTorder_payments.id_currencyorder_payments.id_currency
order_payments__order_referenceTEXTorder_payments.order_referenceorder_payments.order_reference
order_payments__payment_methodTEXTorder_payments.payment_methodorder_payments.payment_method
order_payments__transaction_idTEXTorder_payments.transaction_idorder_payments.transaction_id

PrestaShop order_slip fields

The order_slip report of the PrestaShop connector includes 15 fields.

IDTypeNameDescription
order_slip__amountNUMERICorder_slip.amountorder_slip.amount
order_slip__conversion_rateTEXTorder_slip.conversion_rateorder_slip.conversion_rate
order_slip__date_addTIMESTAMPorder_slip.date_addorder_slip.date_add
order_slip__date_updTIMESTAMPorder_slip.date_updorder_slip.date_upd
order_slip__idTEXTorder_slip.idorder_slip.id
order_slip__id_customerTEXTorder_slip.id_customerorder_slip.id_customer
order_slip__id_orderTEXTorder_slip.id_orderorder_slip.id_order
order_slip__order_slip_typeTEXTorder_slip.order_slip_typeorder_slip.order_slip_type
order_slip__partialTEXTorder_slip.partialorder_slip.partial
order_slip__shipping_costNUMERICorder_slip.shipping_costorder_slip.shipping_cost
order_slip__shipping_cost_amountNUMERICorder_slip.shipping_cost_amountorder_slip.shipping_cost_amount
order_slip__total_products_tax_exclNUMERICorder_slip.total_products_tax_exclorder_slip.total_products_tax_excl
order_slip__total_products_tax_inclNUMERICorder_slip.total_products_tax_inclorder_slip.total_products_tax_incl
order_slip__total_shipping_tax_exclNUMERICorder_slip.total_shipping_tax_exclorder_slip.total_shipping_tax_excl
order_slip__total_shipping_tax_inclNUMERICorder_slip.total_shipping_tax_inclorder_slip.total_shipping_tax_incl

PrestaShop order_states fields

The order_states report of the PrestaShop connector includes 16 fields.

IDTypeNameDescription
order_states__colorTEXTorder_states.colororder_states.color
order_states__deletedTEXTorder_states.deletedorder_states.deleted
order_states__deliveryTEXTorder_states.deliveryorder_states.delivery
order_states__hiddenTEXTorder_states.hiddenorder_states.hidden
order_states__idTEXTorder_states.idorder_states.id
order_states__invoiceTEXTorder_states.invoiceorder_states.invoice
order_states__logableTEXTorder_states.logableorder_states.logable
order_states__module_nameTEXTorder_states.module_nameorder_states.module_name
order_states__nameTEXTorder_states.nameorder_states.name
order_states__paidTEXTorder_states.paidorder_states.paid
order_states__pdf_deliveryTEXTorder_states.pdf_deliveryorder_states.pdf_delivery
order_states__pdf_invoiceTEXTorder_states.pdf_invoiceorder_states.pdf_invoice
order_states__send_emailTEXTorder_states.send_emailorder_states.send_email
order_states__shippedTEXTorder_states.shippedorder_states.shipped
order_states__templateTEXTorder_states.templateorder_states.template
order_states__unremovableTEXTorder_states.unremovableorder_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)

IDTypeNameDescription
orders__associationsOBJECTorders.associationsorders.associations
orders__carrier_tax_rateTEXTorders.carrier_tax_rateorders.carrier_tax_rate
orders__conversion_rateTEXTorders.conversion_rateorders.conversion_rate
orders__current_stateTEXTorders.current_stateorders.current_state
orders__date_addTIMESTAMPorders.date_addorders.date_add
orders__date_updTIMESTAMPorders.date_updorders.date_upd
orders__delivery_dateDATEorders.delivery_dateorders.delivery_date
orders__delivery_numberTEXTorders.delivery_numberorders.delivery_number
orders__giftTEXTorders.giftorders.gift
orders__gift_messageTEXTorders.gift_messageorders.gift_message
orders__idTEXTorders.idorders.id
orders__id_address_deliveryTEXTorders.id_address_deliveryorders.id_address_delivery
orders__id_address_invoiceTEXTorders.id_address_invoiceorders.id_address_invoice
orders__id_carrierTEXTorders.id_carrierorders.id_carrier
orders__id_cartTEXTorders.id_cartorders.id_cart
orders__id_currencyTEXTorders.id_currencyorders.id_currency
orders__id_customerTEXTorders.id_customerorders.id_customer
orders__id_langTEXTorders.id_langorders.id_lang
orders__id_shopTEXTorders.id_shoporders.id_shop
orders__id_shop_groupTEXTorders.id_shop_grouporders.id_shop_group
orders__invoice_dateDATEorders.invoice_dateorders.invoice_date
orders__invoice_numberTEXTorders.invoice_numberorders.invoice_number
orders__mobile_themeTEXTorders.mobile_themeorders.mobile_theme
orders__moduleTEXTorders.moduleorders.module
orders__paymentTEXTorders.paymentorders.payment
orders__recyclableTEXTorders.recyclableorders.recyclable
orders__referenceTEXTorders.referenceorders.reference
orders__round_modeTEXTorders.round_modeorders.round_mode
orders__round_typeTEXTorders.round_typeorders.round_type
orders__secure_keyTEXTorders.secure_keyorders.secure_key
orders__shipping_numberTEXTorders.shipping_numberorders.shipping_number
orders__total_discountsNUMERICorders.total_discountsorders.total_discounts
orders__total_discounts_tax_exclNUMERICorders.total_discounts_tax_exclorders.total_discounts_tax_excl
orders__total_discounts_tax_inclNUMERICorders.total_discounts_tax_inclorders.total_discounts_tax_incl
orders__total_paidNUMERICorders.total_paidorders.total_paid
orders__total_paid_realNUMERICorders.total_paid_realorders.total_paid_real
orders__total_paid_tax_exclNUMERICorders.total_paid_tax_exclorders.total_paid_tax_excl
orders__total_paid_tax_inclNUMERICorders.total_paid_tax_inclorders.total_paid_tax_incl
orders__total_productsNUMERICorders.total_productsorders.total_products
orders__total_products_wtNUMERICorders.total_products_wtorders.total_products_wt

PrestaShop orders fields (orders__total_shipping to orders__valid)

IDTypeNameDescription
orders__total_shippingNUMERICorders.total_shippingorders.total_shipping
orders__total_shipping_tax_exclNUMERICorders.total_shipping_tax_exclorders.total_shipping_tax_excl
orders__total_shipping_tax_inclNUMERICorders.total_shipping_tax_inclorders.total_shipping_tax_incl
orders__total_wrappingNUMERICorders.total_wrappingorders.total_wrapping
orders__total_wrapping_tax_exclNUMERICorders.total_wrapping_tax_exclorders.total_wrapping_tax_excl
orders__total_wrapping_tax_inclNUMERICorders.total_wrapping_tax_inclorders.total_wrapping_tax_incl
orders__validTEXTorders.validorders.valid

PrestaShop price_ranges fields

The price_ranges report of the PrestaShop connector includes 4 fields.

IDTypeNameDescription
price_ranges__delimiter1TEXTprice_ranges.delimiter1price_ranges.delimiter1
price_ranges__delimiter2TEXTprice_ranges.delimiter2price_ranges.delimiter2
price_ranges__idTEXTprice_ranges.idprice_ranges.id
price_ranges__id_carrierTEXTprice_ranges.id_carrierprice_ranges.id_carrier

PrestaShop product_customization_fields fields

The product_customization_fields report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
product_customization_fields__idTEXTproduct_customization_fields.idproduct_customization_fields.id
product_customization_fields__id_productTEXTproduct_customization_fields.id_productproduct_customization_fields.id_product
product_customization_fields__is_deletedTEXTproduct_customization_fields.is_deletedproduct_customization_fields.is_deleted
product_customization_fields__is_moduleTEXTproduct_customization_fields.is_moduleproduct_customization_fields.is_module
product_customization_fields__nameTEXTproduct_customization_fields.nameproduct_customization_fields.name
product_customization_fields__requiredTEXTproduct_customization_fields.requiredproduct_customization_fields.required
product_customization_fields__typeTEXTproduct_customization_fields.typeproduct_customization_fields.type

PrestaShop product_feature_values fields

The product_feature_values report of the PrestaShop connector includes 4 fields.

IDTypeNameDescription
product_feature_values__customTEXTproduct_feature_values.customproduct_feature_values.custom
product_feature_values__idTEXTproduct_feature_values.idproduct_feature_values.id
product_feature_values__id_featureTEXTproduct_feature_values.id_featureproduct_feature_values.id_feature
product_feature_values__valueTEXTproduct_feature_values.valueproduct_feature_values.value

PrestaShop product_features fields

The product_features report of the PrestaShop connector includes 3 fields.

IDTypeNameDescription
product_features__idTEXTproduct_features.idproduct_features.id
product_features__nameTEXTproduct_features.nameproduct_features.name
product_features__positionTEXTproduct_features.positionproduct_features.position

PrestaShop product_option_values fields

The product_option_values report of the PrestaShop connector includes 5 fields.

IDTypeNameDescription
product_option_values__colorTEXTproduct_option_values.colorproduct_option_values.color
product_option_values__idTEXTproduct_option_values.idproduct_option_values.id
product_option_values__id_attribute_groupTEXTproduct_option_values.id_attribute_groupproduct_option_values.id_attribute_group
product_option_values__nameTEXTproduct_option_values.nameproduct_option_values.name
product_option_values__positionTEXTproduct_option_values.positionproduct_option_values.position

PrestaShop product_options fields

The product_options report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
product_options__associationsOBJECTproduct_options.associationsproduct_options.associations
product_options__group_typeTEXTproduct_options.group_typeproduct_options.group_type
product_options__idTEXTproduct_options.idproduct_options.id
product_options__is_color_groupTEXTproduct_options.is_color_groupproduct_options.is_color_group
product_options__nameTEXTproduct_options.nameproduct_options.name
product_options__positionTEXTproduct_options.positionproduct_options.position
product_options__public_nameTEXTproduct_options.public_nameproduct_options.public_name

PrestaShop product_suppliers fields

The product_suppliers report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
product_suppliers__idTEXTproduct_suppliers.idproduct_suppliers.id
product_suppliers__id_currencyTEXTproduct_suppliers.id_currencyproduct_suppliers.id_currency
product_suppliers__id_productTEXTproduct_suppliers.id_productproduct_suppliers.id_product
product_suppliers__id_product_attributeTEXTproduct_suppliers.id_product_attributeproduct_suppliers.id_product_attribute
product_suppliers__id_supplierTEXTproduct_suppliers.id_supplierproduct_suppliers.id_supplier
product_suppliers__product_supplier_price_teTEXTproduct_suppliers.product_supplier_price_teproduct_suppliers.product_supplier_price_te
product_suppliers__product_supplier_referenceTEXTproduct_suppliers.product_supplier_referenceproduct_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)

IDTypeNameDescription
products__activeTEXTproducts.activeproducts.active
products__additional_delivery_timesTEXTproducts.additional_delivery_timesproducts.additional_delivery_times
products__additional_shipping_costNUMERICproducts.additional_shipping_costproducts.additional_shipping_cost
products__advanced_stock_managementTEXTproducts.advanced_stock_managementproducts.advanced_stock_management
products__associationsOBJECTproducts.associationsproducts.associations
products__available_dateDATEproducts.available_dateproducts.available_date
products__available_for_orderTEXTproducts.available_for_orderproducts.available_for_order
products__available_laterTEXTproducts.available_laterproducts.available_later
products__available_nowTEXTproducts.available_nowproducts.available_now
products__cache_default_attributeTEXTproducts.cache_default_attributeproducts.cache_default_attribute
products__cache_has_attachmentsTEXTproducts.cache_has_attachmentsproducts.cache_has_attachments
products__cache_is_packTEXTproducts.cache_is_packproducts.cache_is_pack
products__conditionTEXTproducts.conditionproducts.condition
products__customizableTEXTproducts.customizableproducts.customizable
products__date_addTIMESTAMPproducts.date_addproducts.date_add
products__date_updTIMESTAMPproducts.date_updproducts.date_upd
products__delivery_in_stockTEXTproducts.delivery_in_stockproducts.delivery_in_stock
products__delivery_out_stockTEXTproducts.delivery_out_stockproducts.delivery_out_stock
products__depthNUMERICproducts.depthproducts.depth
products__descriptionTEXTproducts.descriptionproducts.description
products__description_shortTEXTproducts.description_shortproducts.description_short
products__ean13TEXTproducts.ean13products.ean13
products__ecotaxTEXTproducts.ecotaxproducts.ecotax
products__heightNUMERICproducts.heightproducts.height
products__idTEXTproducts.idproducts.id
products__id_category_defaultTEXTproducts.id_category_defaultproducts.id_category_default
products__id_default_combinationTEXTproducts.id_default_combinationproducts.id_default_combination
products__id_default_imageTEXTproducts.id_default_imageproducts.id_default_image
products__id_manufacturerTEXTproducts.id_manufacturerproducts.id_manufacturer
products__id_shop_defaultTEXTproducts.id_shop_defaultproducts.id_shop_default
products__id_supplierTEXTproducts.id_supplierproducts.id_supplier
products__id_tax_rules_groupTEXTproducts.id_tax_rules_groupproducts.id_tax_rules_group
products__id_type_redirectedTEXTproducts.id_type_redirectedproducts.id_type_redirected
products__indexedTEXTproducts.indexedproducts.indexed
products__is_virtualTEXTproducts.is_virtualproducts.is_virtual
products__isbnTEXTproducts.isbnproducts.isbn
products__link_rewriteTEXTproducts.link_rewriteproducts.link_rewrite
products__locationTEXTproducts.locationproducts.location
products__low_stock_alertTEXTproducts.low_stock_alertproducts.low_stock_alert
products__low_stock_thresholdTEXTproducts.low_stock_thresholdproducts.low_stock_threshold

PrestaShop products fields (products__manufacturer_name to products__width)

IDTypeNameDescription
products__manufacturer_nameTEXTproducts.manufacturer_nameproducts.manufacturer_name
products__meta_descriptionTEXTproducts.meta_descriptionproducts.meta_description
products__meta_keywordsTEXTproducts.meta_keywordsproducts.meta_keywords
products__meta_titleTEXTproducts.meta_titleproducts.meta_title
products__minimal_quantityTEXTproducts.minimal_quantityproducts.minimal_quantity
products__mpnTEXTproducts.mpnproducts.mpn
products__nameTEXTproducts.nameproducts.name
products__newTEXTproducts.newproducts.new
products__on_saleBOOLEANproducts.on_saleproducts.on_sale
products__online_onlyTEXTproducts.online_onlyproducts.online_only
products__pack_stock_typeTEXTproducts.pack_stock_typeproducts.pack_stock_type
products__position_in_categoryTEXTproducts.position_in_categoryproducts.position_in_category
products__priceNUMERICproducts.priceproducts.price
products__quantityNUMERICproducts.quantityproducts.quantity
products__quantity_discountNUMERICproducts.quantity_discountproducts.quantity_discount
products__redirect_typeTEXTproducts.redirect_typeproducts.redirect_type
products__referenceTEXTproducts.referenceproducts.reference
products__show_conditionTEXTproducts.show_conditionproducts.show_condition
products__show_priceTEXTproducts.show_priceproducts.show_price
products__stateTEXTproducts.stateproducts.state
products__supplier_referenceTEXTproducts.supplier_referenceproducts.supplier_reference
products__text_fieldsTEXTproducts.text_fieldsproducts.text_fields
products__typeTEXTproducts.typeproducts.type
products__unit_price_ratioNUMERICproducts.unit_price_ratioproducts.unit_price_ratio
products__unityTEXTproducts.unityproducts.unity
products__upcTEXTproducts.upcproducts.upc
products__uploadable_filesTEXTproducts.uploadable_filesproducts.uploadable_files
products__visibilityTEXTproducts.visibilityproducts.visibility
products__weightNUMERICproducts.weightproducts.weight
products__wholesale_priceNUMERICproducts.wholesale_priceproducts.wholesale_price
products__widthNUMERICproducts.widthproducts.width

PrestaShop shop_groups fields

The shop_groups report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
shop_groups__activeTEXTshop_groups.activeshop_groups.active
shop_groups__deletedTEXTshop_groups.deletedshop_groups.deleted
shop_groups__idTEXTshop_groups.idshop_groups.id
shop_groups__nameTEXTshop_groups.nameshop_groups.name
shop_groups__share_customerTEXTshop_groups.share_customershop_groups.share_customer
shop_groups__share_orderTEXTshop_groups.share_ordershop_groups.share_order
shop_groups__share_stockTEXTshop_groups.share_stockshop_groups.share_stock

PrestaShop shop_urls fields

The shop_urls report of the PrestaShop connector includes 8 fields.

IDTypeNameDescription
shop_urls__activeTEXTshop_urls.activeshop_urls.active
shop_urls__domainTEXTshop_urls.domainshop_urls.domain
shop_urls__domain_sslTEXTshop_urls.domain_sslshop_urls.domain_ssl
shop_urls__idTEXTshop_urls.idshop_urls.id
shop_urls__id_shopTEXTshop_urls.id_shopshop_urls.id_shop
shop_urls__mainTEXTshop_urls.mainshop_urls.main
shop_urls__physical_uriTEXTshop_urls.physical_urishop_urls.physical_uri
shop_urls__virtual_uriTEXTshop_urls.virtual_urishop_urls.virtual_uri

PrestaShop shops fields

The shops report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
shops__activeTEXTshops.activeshops.active
shops__deletedTEXTshops.deletedshops.deleted
shops__idTEXTshops.idshops.id
shops__id_categoryTEXTshops.id_categoryshops.id_category
shops__id_shop_groupTEXTshops.id_shop_groupshops.id_shop_group
shops__nameTEXTshops.nameshops.name
shops__theme_nameTEXTshops.theme_nameshops.theme_name

PrestaShop specific_price_rules fields

The specific_price_rules report of the PrestaShop connector includes 13 fields.

IDTypeNameDescription
specific_price_rules__fromTEXTspecific_price_rules.fromspecific_price_rules.from
specific_price_rules__from_quantityTEXTspecific_price_rules.from_quantityspecific_price_rules.from_quantity
specific_price_rules__idTEXTspecific_price_rules.idspecific_price_rules.id
specific_price_rules__id_countryCOUNTRYspecific_price_rules.id_countryspecific_price_rules.id_country
specific_price_rules__id_currencyTEXTspecific_price_rules.id_currencyspecific_price_rules.id_currency
specific_price_rules__id_groupTEXTspecific_price_rules.id_groupspecific_price_rules.id_group
specific_price_rules__id_shopTEXTspecific_price_rules.id_shopspecific_price_rules.id_shop
specific_price_rules__nameTEXTspecific_price_rules.namespecific_price_rules.name
specific_price_rules__priceNUMERICspecific_price_rules.pricespecific_price_rules.price
specific_price_rules__reductionTEXTspecific_price_rules.reductionspecific_price_rules.reduction
specific_price_rules__reduction_taxTEXTspecific_price_rules.reduction_taxspecific_price_rules.reduction_tax
specific_price_rules__reduction_typeTEXTspecific_price_rules.reduction_typespecific_price_rules.reduction_type
specific_price_rules__toNUMERICspecific_price_rules.tospecific_price_rules.to

PrestaShop specific_prices fields

The specific_prices report of the PrestaShop connector includes 18 fields.

IDTypeNameDescription
specific_prices__fromNUMERICspecific_prices.fromspecific_prices.from
specific_prices__from_quantityNUMERICspecific_prices.from_quantityspecific_prices.from_quantity
specific_prices__idTEXTspecific_prices.idspecific_prices.id
specific_prices__id_cartTEXTspecific_prices.id_cartspecific_prices.id_cart
specific_prices__id_countryCOUNTRYspecific_prices.id_countryspecific_prices.id_country
specific_prices__id_currencyTEXTspecific_prices.id_currencyspecific_prices.id_currency
specific_prices__id_customerTEXTspecific_prices.id_customerspecific_prices.id_customer
specific_prices__id_groupTEXTspecific_prices.id_groupspecific_prices.id_group
specific_prices__id_productTEXTspecific_prices.id_productspecific_prices.id_product
specific_prices__id_product_attributeTEXTspecific_prices.id_product_attributespecific_prices.id_product_attribute
specific_prices__id_shopTEXTspecific_prices.id_shopspecific_prices.id_shop
specific_prices__id_shop_groupTEXTspecific_prices.id_shop_groupspecific_prices.id_shop_group
specific_prices__id_specific_price_ruleTEXTspecific_prices.id_specific_price_rulespecific_prices.id_specific_price_rule
specific_prices__priceNUMERICspecific_prices.pricespecific_prices.price
specific_prices__reductionTEXTspecific_prices.reductionspecific_prices.reduction
specific_prices__reduction_taxTEXTspecific_prices.reduction_taxspecific_prices.reduction_tax
specific_prices__reduction_typeTEXTspecific_prices.reduction_typespecific_prices.reduction_type
specific_prices__toTEXTspecific_prices.tospecific_prices.to

PrestaShop states fields

The states report of the PrestaShop connector includes 6 fields.

IDTypeNameDescription
states__activeTEXTstates.activestates.active
states__idTEXTstates.idstates.id
states__id_countryCOUNTRYstates.id_countrystates.id_country
states__id_zoneTEXTstates.id_zonestates.id_zone
states__iso_codeTEXTstates.iso_codestates.iso_code
states__nameTEXTstates.namestates.name

PrestaShop stock_availables fields

The stock_availables report of the PrestaShop connector includes 9 fields.

IDTypeNameDescription
stock_availables__depends_on_stockTEXTstock_availables.depends_on_stockstock_availables.depends_on_stock
stock_availables__idTEXTstock_availables.idstock_availables.id
stock_availables__id_productTEXTstock_availables.id_productstock_availables.id_product
stock_availables__id_product_attributeTEXTstock_availables.id_product_attributestock_availables.id_product_attribute
stock_availables__id_shopTEXTstock_availables.id_shopstock_availables.id_shop
stock_availables__id_shop_groupTEXTstock_availables.id_shop_groupstock_availables.id_shop_group
stock_availables__locationTEXTstock_availables.locationstock_availables.location
stock_availables__out_of_stockTEXTstock_availables.out_of_stockstock_availables.out_of_stock
stock_availables__quantityNUMERICstock_availables.quantitystock_availables.quantity

PrestaShop stock_movement_reasons fields

The stock_movement_reasons report of the PrestaShop connector includes 6 fields.

IDTypeNameDescription
stock_movement_reasons__date_addTIMESTAMPstock_movement_reasons.date_addstock_movement_reasons.date_add
stock_movement_reasons__date_updTIMESTAMPstock_movement_reasons.date_updstock_movement_reasons.date_upd
stock_movement_reasons__deletedTEXTstock_movement_reasons.deletedstock_movement_reasons.deleted
stock_movement_reasons__idTEXTstock_movement_reasons.idstock_movement_reasons.id
stock_movement_reasons__nameTEXTstock_movement_reasons.namestock_movement_reasons.name
stock_movement_reasons__signTEXTstock_movement_reasons.signstock_movement_reasons.sign

PrestaShop stock_movements fields

The stock_movements report of the PrestaShop connector includes 22 fields.

IDTypeNameDescription
stock_movements__current_waTEXTstock_movements.current_wastock_movements.current_wa
stock_movements__date_addTIMESTAMPstock_movements.date_addstock_movements.date_add
stock_movements__ean13TEXTstock_movements.ean13stock_movements.ean13
stock_movements__idTEXTstock_movements.idstock_movements.id
stock_movements__id_currencyTEXTstock_movements.id_currencystock_movements.id_currency
stock_movements__id_employeeTEXTstock_movements.id_employeestock_movements.id_employee
stock_movements__id_orderTEXTstock_movements.id_orderstock_movements.id_order
stock_movements__id_productTEXTstock_movements.id_productstock_movements.id_product
stock_movements__id_product_attributeTEXTstock_movements.id_product_attributestock_movements.id_product_attribute
stock_movements__id_stockTEXTstock_movements.id_stockstock_movements.id_stock
stock_movements__id_stock_mvt_reasonTEXTstock_movements.id_stock_mvt_reasonstock_movements.id_stock_mvt_reason
stock_movements__id_supply_orderTEXTstock_movements.id_supply_orderstock_movements.id_supply_order
stock_movements__id_warehouseTEXTstock_movements.id_warehousestock_movements.id_warehouse
stock_movements__last_waTEXTstock_movements.last_wastock_movements.last_wa
stock_movements__management_typeTEXTstock_movements.management_typestock_movements.management_type
stock_movements__mpnTEXTstock_movements.mpnstock_movements.mpn
stock_movements__physical_quantityNUMERICstock_movements.physical_quantitystock_movements.physical_quantity
stock_movements__price_teTEXTstock_movements.price_testock_movements.price_te
stock_movements__product_nameBOOLEANstock_movements.product_namestock_movements.product_name
stock_movements__referenceTEXTstock_movements.referencestock_movements.reference
stock_movements__signTEXTstock_movements.signstock_movements.sign
stock_movements__upcTEXTstock_movements.upcstock_movements.upc

PrestaShop stores fields

The stores report of the PrestaShop connector includes 18 fields.

IDTypeNameDescription
stores__activeTEXTstores.activestores.active
stores__address1TEXTstores.address1stores.address1
stores__address2TEXTstores.address2stores.address2
stores__cityCITYstores.citystores.city
stores__date_addTIMESTAMPstores.date_addstores.date_add
stores__date_updTIMESTAMPstores.date_updstores.date_upd
stores__emailTEXTstores.emailstores.email
stores__faxTEXTstores.faxstores.fax
stores__hoursTEXTstores.hoursstores.hours
stores__idTEXTstores.idstores.id
stores__id_countryCOUNTRYstores.id_countrystores.id_country
stores__id_stateTEXTstores.id_statestores.id_state
stores__latitudeTEXTstores.latitudestores.latitude
stores__longitudeTEXTstores.longitudestores.longitude
stores__nameTEXTstores.namestores.name
stores__noteTEXTstores.notestores.note
stores__phoneTEXTstores.phonestores.phone
stores__postcodeTEXTstores.postcodestores.postcode

PrestaShop suppliers fields

The suppliers report of the PrestaShop connector includes 10 fields.

IDTypeNameDescription
suppliers__activeTEXTsuppliers.activesuppliers.active
suppliers__date_addTIMESTAMPsuppliers.date_addsuppliers.date_add
suppliers__date_updTIMESTAMPsuppliers.date_updsuppliers.date_upd
suppliers__descriptionTEXTsuppliers.descriptionsuppliers.description
suppliers__idTEXTsuppliers.idsuppliers.id
suppliers__link_rewriteTEXTsuppliers.link_rewritesuppliers.link_rewrite
suppliers__meta_descriptionTEXTsuppliers.meta_descriptionsuppliers.meta_description
suppliers__meta_keywordsTEXTsuppliers.meta_keywordssuppliers.meta_keywords
suppliers__meta_titleTEXTsuppliers.meta_titlesuppliers.meta_title
suppliers__nameTEXTsuppliers.namesuppliers.name

PrestaShop tags fields

The tags report of the PrestaShop connector includes 3 fields.

IDTypeNameDescription
tags__idTEXTtags.idtags.id
tags__id_langTEXTtags.id_langtags.id_lang
tags__nameTEXTtags.nametags.name

PrestaShop tax_rule_groups fields

The tax_rule_groups report of the PrestaShop connector includes 6 fields.

IDTypeNameDescription
tax_rule_groups__activeTEXTtax_rule_groups.activetax_rule_groups.active
tax_rule_groups__date_addTIMESTAMPtax_rule_groups.date_addtax_rule_groups.date_add
tax_rule_groups__date_updTIMESTAMPtax_rule_groups.date_updtax_rule_groups.date_upd
tax_rule_groups__deletedTEXTtax_rule_groups.deletedtax_rule_groups.deleted
tax_rule_groups__idTEXTtax_rule_groups.idtax_rule_groups.id
tax_rule_groups__nameTEXTtax_rule_groups.nametax_rule_groups.name

PrestaShop tax_rules fields

The tax_rules report of the PrestaShop connector includes 9 fields.

IDTypeNameDescription
tax_rules__behaviorTEXTtax_rules.behaviortax_rules.behavior
tax_rules__descriptionTEXTtax_rules.descriptiontax_rules.description
tax_rules__idTEXTtax_rules.idtax_rules.id
tax_rules__id_countryCOUNTRYtax_rules.id_countrytax_rules.id_country
tax_rules__id_stateTEXTtax_rules.id_statetax_rules.id_state
tax_rules__id_taxTEXTtax_rules.id_taxtax_rules.id_tax
tax_rules__id_tax_rules_groupTEXTtax_rules.id_tax_rules_grouptax_rules.id_tax_rules_group
tax_rules__zipcode_fromTEXTtax_rules.zipcode_fromtax_rules.zipcode_from
tax_rules__zipcode_toTEXTtax_rules.zipcode_totax_rules.zipcode_to

PrestaShop taxes fields

The taxes report of the PrestaShop connector includes 5 fields.

IDTypeNameDescription
taxes__activeTEXTtaxes.activetaxes.active
taxes__deletedTEXTtaxes.deletedtaxes.deleted
taxes__idTEXTtaxes.idtaxes.id
taxes__nameTEXTtaxes.nametaxes.name
taxes__rateTEXTtaxes.ratetaxes.rate

PrestaShop translated_configurations fields

The translated_configurations report of the PrestaShop connector includes 7 fields.

IDTypeNameDescription
translated_configurations__date_addTIMESTAMPtranslated_configurations.date_addtranslated_configurations.date_add
translated_configurations__date_updTIMESTAMPtranslated_configurations.date_updtranslated_configurations.date_upd
translated_configurations__idTEXTtranslated_configurations.idtranslated_configurations.id
translated_configurations__id_shopTEXTtranslated_configurations.id_shoptranslated_configurations.id_shop
translated_configurations__id_shop_groupTEXTtranslated_configurations.id_shop_grouptranslated_configurations.id_shop_group
translated_configurations__nameTEXTtranslated_configurations.nametranslated_configurations.name
translated_configurations__valueTEXTtranslated_configurations.valuetranslated_configurations.value

PrestaShop weight_ranges fields

The weight_ranges report of the PrestaShop connector includes 4 fields.

IDTypeNameDescription
weight_ranges__delimiter1TEXTweight_ranges.delimiter1weight_ranges.delimiter1
weight_ranges__delimiter2TEXTweight_ranges.delimiter2weight_ranges.delimiter2
weight_ranges__idTEXTweight_ranges.idweight_ranges.id
weight_ranges__id_carrierTEXTweight_ranges.id_carrierweight_ranges.id_carrier

PrestaShop zones fields

The zones report of the PrestaShop connector includes 3 fields.

IDTypeNameDescription
zones__activeTEXTzones.activezones.active
zones__idTEXTzones.idzones.id
zones__nameTEXTzones.namezones.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.

IDTypeNameDescriptionReport
account_idTEXTAccount IDAccount ID.
account_nameTEXTAccount NameAccount name.
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate.
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20