PrestaShop Connector Reference
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.
| 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 | addresses.date_add | addresses.date_add | |
| addresses__date_upd | 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 | 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 | 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 | carts.date_add | carts.date_add | |
| carts__date_upd | 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 | categories.date_add | categories.date_add | |
| categories__date_upd | 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 | configurations.date_add | configurations.date_add | |
| configurations__date_upd | 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 | customer_messages.date_add | customer_messages.date_add | |
| customer_messages__date_upd | 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 | customer_threads.date_add | customer_threads.date_add | |
| customer_threads__date_upd | 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 | customers.date_add | customers.date_add | |
| customers__date_upd | 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 | groups.date_add | groups.date_add | |
| groups__date_upd | 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 | manufacturers.date_add | manufacturers.date_add | |
| manufacturers__date_upd | 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 | 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 | 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 47 fields.
PrestaShop order_details fields (order_details__discount_quantity_applied to order_details__total_price_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__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 |
| 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 |
PrestaShop order_details fields (order_details__total_price_tax_incl to order_details__unit_price_tax_incl)
| ID | Type | Name | Description |
|---|---|---|---|
| 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 | 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 | 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 | 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 | order_slip.date_add | order_slip.date_add | |
| order_slip__date_upd | 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 |
| 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 | orders.date_add | orders.date_add | |
| orders__date_upd | 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 | products.date_add | products.date_add | |
| products__date_upd | 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 | stock_movement_reasons.date_add | stock_movement_reasons.date_add | |
| stock_movement_reasons__date_upd | 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 | 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 | stores.date_add | stores.date_add | |
| stores__date_upd | 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 | suppliers.date_add | suppliers.date_add | |
| suppliers__date_upd | 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 | tax_rule_groups.date_add | tax_rule_groups.date_add | |
| tax_rule_groups__date_upd | 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 | translated_configurations.date_add | translated_configurations.date_add | |
| translated_configurations__date_upd | 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 | 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 | 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 |
