Windsor brings all your PrestaShop data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQLPower BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
PrestaShop Field Reference
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
addresses__address1 | TEXT | addresses.address1 | addresses.address1 | addresses |
addresses__address2 | TEXT | addresses.address2 | addresses.address2 | addresses |
addresses__alias | TEXT | addresses.alias | addresses.alias | addresses |
addresses__city | CITY | addresses.city | addresses.city | addresses |
addresses__company | TEXT | addresses.company | addresses.company | addresses |
addresses__date_add | DATE | addresses.date_add | addresses.date_add | addresses |
addresses__date_upd | DATE | addresses.date_upd | addresses.date_upd | addresses |
addresses__deleted | TEXT | addresses.deleted | addresses.deleted | addresses |
addresses__dni | TEXT | addresses.dni | addresses.dni | addresses |
addresses__firstname | TEXT | addresses.firstname | addresses.firstname | addresses |
addresses__id | NUMERIC | addresses.id | addresses.id | addresses |
addresses__id_country | COUNTRY | addresses.id_country | addresses.id_country | addresses |
addresses__id_customer | TEXT | addresses.id_customer | addresses.id_customer | addresses |
addresses__id_manufacturer | TEXT | addresses.id_manufacturer | addresses.id_manufacturer | addresses |
addresses__id_state | TEXT | addresses.id_state | addresses.id_state | addresses |
addresses__id_supplier | TEXT | addresses.id_supplier | addresses.id_supplier | addresses |
addresses__id_warehouse | TEXT | addresses.id_warehouse | addresses.id_warehouse | addresses |
addresses__lastname | TEXT | addresses.lastname | addresses.lastname | addresses |
addresses__other | TEXT | addresses.other | addresses.other | addresses |
addresses__phone | TEXT | addresses.phone | addresses.phone | addresses |
addresses__phone_mobile | TEXT | addresses.phone_mobile | addresses.phone_mobile | addresses |
addresses__postcode | TEXT | addresses.postcode | addresses.postcode | addresses |
addresses__vat_number | TEXT | addresses.vat_number | addresses.vat_number | addresses |
carriers__active | TEXT | carriers.active | carriers.active | carriers |
carriers__delay | TEXT | carriers.delay | carriers.delay | carriers |
carriers__deleted | TEXT | carriers.deleted | carriers.deleted | carriers |
carriers__external_module_name | TEXT | carriers.external_module_name | carriers.external_module_name | carriers |
carriers__grade | TEXT | carriers.grade | carriers.grade | carriers |
carriers__id | NUMERIC | carriers.id | carriers.id | carriers |
carriers__id_reference | TEXT | carriers.id_reference | carriers.id_reference | carriers |
carriers__id_tax_rules_group | TEXT | carriers.id_tax_rules_group | carriers.id_tax_rules_group | carriers |
carriers__is_free | TEXT | carriers.is_free | carriers.is_free | carriers |
carriers__is_module | TEXT | carriers.is_module | carriers.is_module | carriers |
carriers__max_depth | NUMERIC | carriers.max_depth | carriers.max_depth | carriers |
carriers__max_height | NUMERIC | carriers.max_height | carriers.max_height | carriers |
carriers__max_weight | NUMERIC | carriers.max_weight | carriers.max_weight | carriers |
carriers__max_width | NUMERIC | carriers.max_width | carriers.max_width | carriers |
carriers__name | TEXT | carriers.name | carriers.name | carriers |
carriers__need_range | TEXT | carriers.need_range | carriers.need_range | carriers |
carriers__position | TEXT | carriers.position | carriers.position | carriers |
carriers__range_behavior | TEXT | carriers.range_behavior | carriers.range_behavior | carriers |
carriers__shipping_external | TEXT | carriers.shipping_external | carriers.shipping_external | carriers |
carriers__shipping_handling | TEXT | carriers.shipping_handling | carriers.shipping_handling | carriers |
carriers__shipping_method | NUMERIC | carriers.shipping_method | carriers.shipping_method | carriers |
carriers__url | TEXT | carriers.url | carriers.url | carriers |
cart_rules__active | TEXT | cart_rules.active | cart_rules.active | cart_rules |
cart_rules__carrier_restriction | TEXT | cart_rules.carrier_restriction | cart_rules.carrier_restriction | cart_rules |
cart_rules__cart_rule_restriction | TEXT | cart_rules.cart_rule_restriction | cart_rules.cart_rule_restriction | cart_rules |
cart_rules__code | TEXT | cart_rules.code | cart_rules.code | cart_rules |
cart_rules__country_restriction | TEXT | cart_rules.country_restriction | cart_rules.country_restriction | cart_rules |
cart_rules__date_add | DATE | cart_rules.date_add | cart_rules.date_add | cart_rules |
cart_rules__date_from | DATE | cart_rules.date_from | cart_rules.date_from | cart_rules |
cart_rules__date_to | DATE | cart_rules.date_to | cart_rules.date_to | cart_rules |
cart_rules__date_upd | DATE | cart_rules.date_upd | cart_rules.date_upd | cart_rules |
cart_rules__description | TEXT | cart_rules.description | cart_rules.description | cart_rules |
cart_rules__free_shipping | TEXT | cart_rules.free_shipping | cart_rules.free_shipping | cart_rules |
cart_rules__gift_product | TEXT | cart_rules.gift_product | cart_rules.gift_product | cart_rules |
cart_rules__gift_product_attribute | TEXT | cart_rules.gift_product_attribute | cart_rules.gift_product_attribute | cart_rules |
cart_rules__group_restriction | TEXT | cart_rules.group_restriction | cart_rules.group_restriction | cart_rules |
cart_rules__highlight | TEXT | cart_rules.highlight | cart_rules.highlight | cart_rules |
cart_rules__id | NUMERIC | cart_rules.id | cart_rules.id | cart_rules |
cart_rules__id_customer | TEXT | cart_rules.id_customer | cart_rules.id_customer | cart_rules |
cart_rules__minimum_amount | NUMERIC | cart_rules.minimum_amount | cart_rules.minimum_amount | cart_rules |
cart_rules__minimum_amount_currency | NUMERIC | cart_rules.minimum_amount_currency | cart_rules.minimum_amount_currency | cart_rules |
cart_rules__minimum_amount_shipping | NUMERIC | cart_rules.minimum_amount_shipping | cart_rules.minimum_amount_shipping | cart_rules |
cart_rules__minimum_amount_tax | NUMERIC | cart_rules.minimum_amount_tax | cart_rules.minimum_amount_tax | cart_rules |
cart_rules__name | TEXT | cart_rules.name | cart_rules.name | cart_rules |
cart_rules__partial_use | TEXT | cart_rules.partial_use | cart_rules.partial_use | cart_rules |
cart_rules__priority | TEXT | cart_rules.priority | cart_rules.priority | cart_rules |
cart_rules__product_restriction | TEXT | cart_rules.product_restriction | cart_rules.product_restriction | cart_rules |
cart_rules__quantity | NUMERIC | cart_rules.quantity | cart_rules.quantity | cart_rules |
cart_rules__quantity_per_user | TEXT | cart_rules.quantity_per_user | cart_rules.quantity_per_user | cart_rules |
cart_rules__reduction_amount | NUMERIC | cart_rules.reduction_amount | cart_rules.reduction_amount | cart_rules |
cart_rules__reduction_currency | TEXT | cart_rules.reduction_currency | cart_rules.reduction_currency | cart_rules |
cart_rules__reduction_exclude_special | TEXT | cart_rules.reduction_exclude_special | cart_rules.reduction_exclude_special | cart_rules |
cart_rules__reduction_percent | TEXT | cart_rules.reduction_percent | cart_rules.reduction_percent | cart_rules |
cart_rules__reduction_product | TEXT | cart_rules.reduction_product | cart_rules.reduction_product | cart_rules |
cart_rules__reduction_tax | TEXT | cart_rules.reduction_tax | cart_rules.reduction_tax | cart_rules |
cart_rules__shop_restriction | TEXT | cart_rules.shop_restriction | cart_rules.shop_restriction | cart_rules |
carts__allow_seperated_package | TEXT | carts.allow_seperated_package | carts.allow_seperated_package | carts |
carts__associations | OBJECT | carts.associations | carts.associations | carts |
carts__date_add | DATE | carts.date_add | carts.date_add | carts |
carts__date_upd | DATE | carts.date_upd | carts.date_upd | carts |
carts__delivery_option | TEXT | carts.delivery_option | carts.delivery_option | carts |
carts__gift | TEXT | carts.gift | carts.gift | carts |
carts__gift_message | TEXT | carts.gift_message | carts.gift_message | carts |
carts__id | NUMERIC | carts.id | carts.id | carts |
carts__id_address_delivery | TEXT | carts.id_address_delivery | carts.id_address_delivery | carts |
carts__id_address_invoice | TEXT | carts.id_address_invoice | carts.id_address_invoice | carts |
carts__id_carrier | TEXT | carts.id_carrier | carts.id_carrier | carts |
carts__id_currency | TEXT | carts.id_currency | carts.id_currency | carts |
carts__id_customer | TEXT | carts.id_customer | carts.id_customer | carts |
carts__id_guest | TEXT | carts.id_guest | carts.id_guest | carts |
carts__id_lang | TEXT | carts.id_lang | carts.id_lang | carts |
carts__id_shop | TEXT | carts.id_shop | carts.id_shop | carts |
carts__id_shop_group | TEXT | carts.id_shop_group | carts.id_shop_group | carts |
carts__mobile_theme | TEXT | carts.mobile_theme | carts.mobile_theme | carts |
carts__recyclable | TEXT | carts.recyclable | carts.recyclable | carts |
carts__secure_key | TEXT | carts.secure_key | carts.secure_key | carts |
categories__active | TEXT | categories.active | categories.active | categories |
categories__associations | OBJECT | categories.associations | categories.associations | categories |
categories__date_add | DATE | categories.date_add | categories.date_add | categories |
categories__date_upd | DATE | categories.date_upd | categories.date_upd | categories |
categories__description | TEXT | categories.description | categories.description | categories |
categories__id | NUMERIC | categories.id | categories.id | categories |
categories__id_parent | TEXT | categories.id_parent | categories.id_parent | categories |
categories__id_shop_default | TEXT | categories.id_shop_default | categories.id_shop_default | categories |
categories__is_root_category | TEXT | categories.is_root_category | categories.is_root_category | categories |
categories__level_depth | TEXT | categories.level_depth | categories.level_depth | categories |
categories__link_rewrite | TEXT | categories.link_rewrite | categories.link_rewrite | categories |
categories__meta_description | TEXT | categories.meta_description | categories.meta_description | categories |
categories__meta_keywords | TEXT | categories.meta_keywords | categories.meta_keywords | categories |
categories__meta_title | TEXT | categories.meta_title | categories.meta_title | categories |
categories__name | TEXT | categories.name | categories.name | categories |
categories__nb_products_recursive | TEXT | categories.nb_products_recursive | categories.nb_products_recursive | categories |
categories__position | TEXT | categories.position | categories.position | categories |
combinations__associations | OBJECT | combinations.associations | combinations.associations | combinations |
combinations__available_date | DATE | combinations.available_date | combinations.available_date | combinations |
combinations__default_on | TEXT | combinations.default_on | combinations.default_on | combinations |
combinations__ean13 | TEXT | combinations.ean13 | combinations.ean13 | combinations |
combinations__ecotax | TEXT | combinations.ecotax | combinations.ecotax | combinations |
combinations__id | NUMERIC | combinations.id | combinations.id | combinations |
combinations__id_product | TEXT | combinations.id_product | combinations.id_product | combinations |
combinations__isbn | TEXT | combinations.isbn | combinations.isbn | combinations |
combinations__location | TEXT | combinations.location | combinations.location | combinations |
combinations__low_stock_alert | TEXT | combinations.low_stock_alert | combinations.low_stock_alert | combinations |
combinations__low_stock_threshold | TEXT | combinations.low_stock_threshold | combinations.low_stock_threshold | combinations |
combinations__minimal_quantity | NUMERIC | combinations.minimal_quantity | combinations.minimal_quantity | combinations |
combinations__mpn | TEXT | combinations.mpn | combinations.mpn | combinations |
combinations__price | NUMERIC | combinations.price | combinations.price | combinations |
combinations__quantity | NUMERIC | combinations.quantity | combinations.quantity | combinations |
combinations__reference | TEXT | combinations.reference | combinations.reference | combinations |
combinations__supplier_reference | TEXT | combinations.supplier_reference | combinations.supplier_reference | combinations |
combinations__unit_price_impact | TEXT | combinations.unit_price_impact | combinations.unit_price_impact | combinations |
combinations__upc | TEXT | combinations.upc | combinations.upc | combinations |
combinations__weight | NUMERIC | combinations.weight | combinations.weight | combinations |
combinations__wholesale_price | NUMERIC | combinations.wholesale_price | combinations.wholesale_price | combinations |
configurations__date_add | DATE | configurations.date_add | configurations.date_add | configurations |
configurations__date_upd | DATE | configurations.date_upd | configurations.date_upd | configurations |
configurations__id | NUMERIC | configurations.id | configurations.id | configurations |
configurations__id_shop | TEXT | configurations.id_shop | configurations.id_shop | configurations |
configurations__id_shop_group | TEXT | configurations.id_shop_group | configurations.id_shop_group | configurations |
configurations__name | TEXT | configurations.name | configurations.name | configurations |
configurations__value | TEXT | configurations.value | configurations.value | configurations |
contacts__customer_service | TEXT | contacts.customer_service | contacts.customer_service | contacts |
contacts__description | TEXT | contacts.description | contacts.description | contacts |
contacts__email | TEXT | contacts.email | contacts.email | contacts |
contacts__id | NUMERIC | contacts.id | contacts.id | contacts |
contacts__name | TEXT | contacts.name | contacts.name | contacts |
content_management_system__active | TEXT | content_management_system.active | content_management_system.active | content_management_system |
content_management_system__content | TEXT | content_management_system.content | content_management_system.content | content_management_system |
content_management_system__head_seo_title | TEXT | content_management_system.head_seo_title | content_management_system.head_seo_title | content_management_system |
content_management_system__id | NUMERIC | content_management_system.id | content_management_system.id | content_management_system |
content_management_system__id_cms_category | TEXT | content_management_system.id_cms_category | content_management_system.id_cms_category | content_management_system |
content_management_system__indexation | TEXT | content_management_system.indexation | content_management_system.indexation | content_management_system |
content_management_system__link_rewrite | TEXT | content_management_system.link_rewrite | content_management_system.link_rewrite | content_management_system |
content_management_system__meta_description | TEXT | content_management_system.meta_description | content_management_system.meta_description | content_management_system |
content_management_system__meta_keywords | TEXT | content_management_system.meta_keywords | content_management_system.meta_keywords | content_management_system |
content_management_system__meta_title | TEXT | content_management_system.meta_title | content_management_system.meta_title | content_management_system |
content_management_system__position | TEXT | content_management_system.position | content_management_system.position | content_management_system |
countries__active | TEXT | countries.active | countries.active | countries |
countries__call_prefix | TEXT | countries.call_prefix | countries.call_prefix | countries |
countries__contains_states | TEXT | countries.contains_states | countries.contains_states | countries |
countries__display_tax_label | TEXT | countries.display_tax_label | countries.display_tax_label | countries |
countries__id | NUMERIC | countries.id | countries.id | countries |
countries__id_currency | TEXT | countries.id_currency | countries.id_currency | countries |
countries__id_zone | TEXT | countries.id_zone | countries.id_zone | countries |
countries__iso_code | TEXT | countries.iso_code | countries.iso_code | countries |
countries__name | TEXT | countries.name | countries.name | countries |
countries__need_identification_number | TEXT | countries.need_identification_number | countries.need_identification_number | countries |
countries__need_zip_code | TEXT | countries.need_zip_code | countries.need_zip_code | countries |
countries__zip_code_format | TEXT | countries.zip_code_format | countries.zip_code_format | countries |
currencies__active | TEXT | currencies.active | currencies.active | currencies |
currencies__conversion_rate | NUMERIC | currencies.conversion_rate | currencies.conversion_rate | currencies |
currencies__deleted | TEXT | currencies.deleted | currencies.deleted | currencies |
currencies__id | NUMERIC | currencies.id | currencies.id | currencies |
currencies__iso_code | TEXT | currencies.iso_code | currencies.iso_code | currencies |
currencies__modified | TEXT | currencies.modified | currencies.modified | currencies |
currencies__name | TEXT | currencies.name | currencies.name | currencies |
currencies__names | TEXT | currencies.names | currencies.names | currencies |
currencies__numeric_iso_code | TEXT | currencies.numeric_iso_code | currencies.numeric_iso_code | currencies |
currencies__pattern | TEXT | currencies.pattern | currencies.pattern | currencies |
currencies__precision | TEXT | currencies.precision | currencies.precision | currencies |
currencies__symbol | TEXT | currencies.symbol | currencies.symbol | currencies |
currencies__unofficial | TEXT | currencies.unofficial | currencies.unofficial | currencies |
customer_messages__date_add | DATE | customer_messages.date_add | customer_messages.date_add | customer_messages |
customer_messages__date_upd | DATE | customer_messages.date_upd | customer_messages.date_upd | customer_messages |
customer_messages__file_name | TEXT | customer_messages.file_name | customer_messages.file_name | customer_messages |
customer_messages__id | NUMERIC | customer_messages.id | customer_messages.id | customer_messages |
customer_messages__id_customer_thread | TEXT | customer_messages.id_customer_thread | customer_messages.id_customer_thread | customer_messages |
customer_messages__id_employee | TEXT | customer_messages.id_employee | customer_messages.id_employee | customer_messages |
customer_messages__ip_address | TEXT | customer_messages.ip_address | customer_messages.ip_address | customer_messages |
customer_messages__message | TEXT | customer_messages.message | customer_messages.message | customer_messages |
customer_messages__private | TEXT | customer_messages.private | customer_messages.private | customer_messages |
customer_messages__read | TEXT | customer_messages.read | customer_messages.read | customer_messages |
customer_messages__user_agent | TEXT | customer_messages.user_agent | customer_messages.user_agent | customer_messages |
customer_threads__associations | OBJECT | customer_threads.associations | customer_threads.associations | customer_threads |
customer_threads__date_add | DATE | customer_threads.date_add | customer_threads.date_add | customer_threads |
customer_threads__date_upd | DATE | customer_threads.date_upd | customer_threads.date_upd | customer_threads |
customer_threads__email | TEXT | customer_threads.email | customer_threads.email | customer_threads |
customer_threads__id | NUMERIC | customer_threads.id | customer_threads.id | customer_threads |
customer_threads__id_contact | TEXT | customer_threads.id_contact | customer_threads.id_contact | customer_threads |
customer_threads__id_customer | TEXT | customer_threads.id_customer | customer_threads.id_customer | customer_threads |
customer_threads__id_lang | TEXT | customer_threads.id_lang | customer_threads.id_lang | customer_threads |
customer_threads__id_order | TEXT | customer_threads.id_order | customer_threads.id_order | customer_threads |
customer_threads__id_product | TEXT | customer_threads.id_product | customer_threads.id_product | customer_threads |
customer_threads__id_shop | TEXT | customer_threads.id_shop | customer_threads.id_shop | customer_threads |
customer_threads__status | TEXT | customer_threads.status | customer_threads.status | customer_threads |
customer_threads__token | TEXT | customer_threads.token | customer_threads.token | customer_threads |
customers__active | TEXT | customers.active | customers.active | customers |
customers__ape | TEXT | customers.ape | customers.ape | customers |
customers__associations | OBJECT | customers.associations | customers.associations | customers |
customers__birthday | TEXT | customers.birthday | customers.birthday | customers |
customers__company | TEXT | customers.company | customers.company | customers |
customers__date_add | DATE | customers.date_add | customers.date_add | customers |
customers__date_upd | DATE | customers.date_upd | customers.date_upd | customers |
customers__deleted | TEXT | customers.deleted | customers.deleted | customers |
customers__email | TEXT | customers.email | customers.email | customers |
customers__firstname | TEXT | customers.firstname | customers.firstname | customers |
customers__id | TEXT | customers.id | customers.id | customers |
customers__id_default_group | TEXT | customers.id_default_group | customers.id_default_group | customers |
customers__id_gender | TEXT | customers.id_gender | customers.id_gender | customers |
customers__id_lang | TEXT | customers.id_lang | customers.id_lang | customers |
customers__id_risk | TEXT | customers.id_risk | customers.id_risk | customers |
customers__id_shop | TEXT | customers.id_shop | customers.id_shop | customers |
customers__id_shop_group | TEXT | customers.id_shop_group | customers.id_shop_group | customers |
customers__ip_registration_newsletter | TEXT | customers.ip_registration_newsletter | customers.ip_registration_newsletter | customers |
customers__is_guest | TEXT | customers.is_guest | customers.is_guest | customers |
customers__last_passwd_gen | TEXT | customers.last_passwd_gen | customers.last_passwd_gen | customers |
customers__lastname | TEXT | customers.lastname | customers.lastname | customers |
customers__max_payment_days | TEXT | customers.max_payment_days | customers.max_payment_days | customers |
customers__newsletter | TEXT | customers.newsletter | customers.newsletter | customers |
customers__newsletter_date_add | DATE | customers.newsletter_date_add | customers.newsletter_date_add | customers |
customers__note | TEXT | customers.note | customers.note | customers |
customers__optin | TEXT | customers.optin | customers.optin | customers |
customers__outstanding_allow_amount | TEXT | customers.outstanding_allow_amount | customers.outstanding_allow_amount | customers |
customers__passwd | TEXT | customers.passwd | customers.passwd | customers |
customers__reset_password_token | TEXT | customers.reset_password_token | customers.reset_password_token | customers |
customers__reset_password_validity | TEXT | customers.reset_password_validity | customers.reset_password_validity | customers |
customers__secure_key | TEXT | customers.secure_key | customers.secure_key | customers |
customers__show_public_prices | TEXT | customers.show_public_prices | customers.show_public_prices | customers |
customers__siret | TEXT | customers.siret | customers.siret | customers |
customers__website | TEXT | customers.website | customers.website | customers |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
deliveries__id | NUMERIC | deliveries.id | deliveries.id | deliveries |
deliveries__id_carrier | TEXT | deliveries.id_carrier | deliveries.id_carrier | deliveries |
deliveries__id_range_price | TEXT | deliveries.id_range_price | deliveries.id_range_price | deliveries |
deliveries__id_range_weight | TEXT | deliveries.id_range_weight | deliveries.id_range_weight | deliveries |
deliveries__id_shop | TEXT | deliveries.id_shop | deliveries.id_shop | deliveries |
deliveries__id_shop_group | TEXT | deliveries.id_shop_group | deliveries.id_shop_group | deliveries |
deliveries__id_zone | TEXT | deliveries.id_zone | deliveries.id_zone | deliveries |
deliveries__price | NUMERIC | deliveries.price | deliveries.price | deliveries |
employees__active | TEXT | employees.active | employees.active | employees |
employees__bo_color | TEXT | employees.bo_color | employees.bo_color | employees |
employees__bo_css | TEXT | employees.bo_css | employees.bo_css | employees |
employees__bo_menu | TEXT | employees.bo_menu | employees.bo_menu | employees |
employees__bo_theme | TEXT | employees.bo_theme | employees.bo_theme | employees |
employees__bo_width | TEXT | employees.bo_width | employees.bo_width | employees |
employees__default_tab | TEXT | employees.default_tab | employees.default_tab | employees |
employees__email | TEXT | employees.email | employees.email | employees |
employees__firstname | TEXT | employees.firstname | employees.firstname | employees |
employees__id | NUMERIC | employees.id | employees.id | employees |
employees__id_lang | TEXT | employees.id_lang | employees.id_lang | employees |
employees__id_last_customer | TEXT | employees.id_last_customer | employees.id_last_customer | employees |
employees__id_last_customer_message | TEXT | employees.id_last_customer_message | employees.id_last_customer_message | employees |
employees__id_last_order | TEXT | employees.id_last_order | employees.id_last_order | employees |
employees__id_profile | TEXT | employees.id_profile | employees.id_profile | employees |
employees__last_passwd_gen | TEXT | employees.last_passwd_gen | employees.last_passwd_gen | employees |
employees__lastname | TEXT | employees.lastname | employees.lastname | employees |
employees__passwd | TEXT | employees.passwd | employees.passwd | employees |
employees__preselect_date_range | TEXT | employees.preselect_date_range | employees.preselect_date_range | employees |
employees__reset_password_token | TEXT | employees.reset_password_token | employees.reset_password_token | employees |
employees__reset_password_validity | TEXT | employees.reset_password_validity | employees.reset_password_validity | employees |
employees__stats_compare_from | TEXT | employees.stats_compare_from | employees.stats_compare_from | employees |
employees__stats_compare_option | TEXT | employees.stats_compare_option | employees.stats_compare_option | employees |
employees__stats_compare_to | TEXT | employees.stats_compare_to | employees.stats_compare_to | employees |
employees__stats_date_from | DATE | employees.stats_date_from | employees.stats_date_from | employees |
employees__stats_date_to | DATE | employees.stats_date_to | employees.stats_date_to | employees |
groups__date_add | DATE | groups.date_add | groups.date_add | groups |
groups__date_upd | DATE | groups.date_upd | groups.date_upd | groups |
groups__id | NUMERIC | groups.id | groups.id | groups |
groups__name | TEXT | groups.name | groups.name | groups |
groups__price_display_method | TEXT | groups.price_display_method | groups.price_display_method | groups |
groups__reduction | TEXT | groups.reduction | groups.reduction | groups |
groups__show_prices | TEXT | groups.show_prices | groups.show_prices | groups |
guests__accept_language | TEXT | guests.accept_language | guests.accept_language | guests |
guests__adobe_director | TEXT | guests.adobe_director | guests.adobe_director | guests |
guests__adobe_flash | TEXT | guests.adobe_flash | guests.adobe_flash | guests |
guests__apple_quicktime | TEXT | guests.apple_quicktime | guests.apple_quicktime | guests |
guests__id | NUMERIC | guests.id | guests.id | guests |
guests__id_customer | TEXT | guests.id_customer | guests.id_customer | guests |
guests__id_operating_system | TEXT | guests.id_operating_system | guests.id_operating_system | guests |
guests__id_web_browser | TEXT | guests.id_web_browser | guests.id_web_browser | guests |
guests__javascript | TEXT | guests.javascript | guests.javascript | guests |
guests__mobile_theme | TEXT | guests.mobile_theme | guests.mobile_theme | guests |
guests__real_player | TEXT | guests.real_player | guests.real_player | guests |
guests__screen_color | TEXT | guests.screen_color | guests.screen_color | guests |
guests__screen_resolution_x | TEXT | guests.screen_resolution_x | guests.screen_resolution_x | guests |
guests__screen_resolution_y | TEXT | guests.screen_resolution_y | guests.screen_resolution_y | guests |
guests__sun_java | TEXT | guests.sun_java | guests.sun_java | guests |
guests__windows_media | TEXT | guests.windows_media | guests.windows_media | guests |
image_types__categories | TEXT | image_types.categories | image_types.categories | image_types |
image_types__height | TEXT | image_types.height | image_types.height | image_types |
image_types__id | NUMERIC | image_types.id | image_types.id | image_types |
image_types__manufacturers | TEXT | image_types.manufacturers | image_types.manufacturers | image_types |
image_types__name | TEXT | image_types.name | image_types.name | image_types |
image_types__products | TEXT | image_types.products | image_types.products | image_types |
image_types__stores | TEXT | image_types.stores | image_types.stores | image_types |
image_types__suppliers | TEXT | image_types.suppliers | image_types.suppliers | image_types |
image_types__width | TEXT | image_types.width | image_types.width | image_types |
languages__active | TEXT | languages.active | languages.active | languages |
languages__date_format_full | TEXT | languages.date_format_full | languages.date_format_full | languages |
languages__date_format_lite | TEXT | languages.date_format_lite | languages.date_format_lite | languages |
languages__id | NUMERIC | languages.id | languages.id | languages |
languages__is_rtl | TEXT | languages.is_rtl | languages.is_rtl | languages |
languages__iso_code | TEXT | languages.iso_code | languages.iso_code | languages |
languages__language_code | TEXT | languages.language_code | languages.language_code | languages |
languages__locale | TEXT | languages.locale | languages.locale | languages |
languages__name | TEXT | languages.name | languages.name | languages |
manufacturers__active | TEXT | manufacturers.active | manufacturers.active | manufacturers |
manufacturers__associations | OBJECT | manufacturers.associations | manufacturers.associations | manufacturers |
manufacturers__date_add | DATE | manufacturers.date_add | manufacturers.date_add | manufacturers |
manufacturers__date_upd | DATE | manufacturers.date_upd | manufacturers.date_upd | manufacturers |
manufacturers__description | TEXT | manufacturers.description | manufacturers.description | manufacturers |
manufacturers__id | NUMERIC | manufacturers.id | manufacturers.id | manufacturers |
manufacturers__link_rewrite | TEXT | manufacturers.link_rewrite | manufacturers.link_rewrite | manufacturers |
manufacturers__meta_description | TEXT | manufacturers.meta_description | manufacturers.meta_description | manufacturers |
manufacturers__meta_keywords | TEXT | manufacturers.meta_keywords | manufacturers.meta_keywords | manufacturers |
manufacturers__meta_title | TEXT | manufacturers.meta_title | manufacturers.meta_title | manufacturers |
manufacturers__name | TEXT | manufacturers.name | manufacturers.name | manufacturers |
manufacturers__short_description | TEXT | manufacturers.short_description | manufacturers.short_description | manufacturers |
messages__date_add | DATE | messages.date_add | messages.date_add | messages |
messages__id | NUMERIC | messages.id | messages.id | messages |
messages__id_cart | TEXT | messages.id_cart | messages.id_cart | messages |
messages__id_customer | TEXT | messages.id_customer | messages.id_customer | messages |
messages__id_employee | TEXT | messages.id_employee | messages.id_employee | messages |
messages__id_order | TEXT | messages.id_order | messages.id_order | messages |
messages__message | TEXT | messages.message | messages.message | messages |
messages__private | TEXT | messages.private | messages.private | messages |
order_carriers__date_add | DATE | order_carriers.date_add | order_carriers.date_add | order_carriers |
order_carriers__id | NUMERIC | order_carriers.id | order_carriers.id | order_carriers |
order_carriers__id_carrier | TEXT | order_carriers.id_carrier | order_carriers.id_carrier | order_carriers |
order_carriers__id_order | TEXT | order_carriers.id_order | order_carriers.id_order | order_carriers |
order_carriers__id_order_invoice | TEXT | order_carriers.id_order_invoice | order_carriers.id_order_invoice | order_carriers |
order_carriers__shipping_cost_tax_excl | NUMERIC | order_carriers.shipping_cost_tax_excl | order_carriers.shipping_cost_tax_excl | order_carriers |
order_carriers__shipping_cost_tax_incl | NUMERIC | order_carriers.shipping_cost_tax_incl | order_carriers.shipping_cost_tax_incl | order_carriers |
order_carriers__tracking_number | TEXT | order_carriers.tracking_number | order_carriers.tracking_number | order_carriers |
order_carriers__weight | NUMERIC | order_carriers.weight | order_carriers.weight | order_carriers |
order_details__discount_quantity_applied | TEXT | order_details.discount_quantity_applied | order_details.discount_quantity_applied | order_details |
order_details__download_deadline | TEXT | order_details.download_deadline | order_details.download_deadline | order_details |
order_details__download_hash | TEXT | order_details.download_hash | order_details.download_hash | order_details |
order_details__download_nb | TEXT | order_details.download_nb | order_details.download_nb | order_details |
order_details__ecotax | NUMERIC | order_details.ecotax | order_details.ecotax | order_details |
order_details__ecotax_tax_rate | NUMERIC | order_details.ecotax_tax_rate | order_details.ecotax_tax_rate | order_details |
order_details__group_reduction | TEXT | order_details.group_reduction | order_details.group_reduction | order_details |
order_details__id | NUMERIC | order_details.id | order_details.id | order_details |
order_details__id_customization | TEXT | order_details.id_customization | order_details.id_customization | order_details |
order_details__id_order | TEXT | order_details.id_order | order_details.id_order | order_details |
order_details__id_order_invoice | TEXT | order_details.id_order_invoice | order_details.id_order_invoice | order_details |
order_details__id_shop | TEXT | order_details.id_shop | order_details.id_shop | order_details |
order_details__id_tax_rules_group | TEXT | order_details.id_tax_rules_group | order_details.id_tax_rules_group | order_details |
order_details__id_warehouse | TEXT | order_details.id_warehouse | order_details.id_warehouse | order_details |
order_details__original_product_price | NUMERIC | order_details.original_product_price | order_details.original_product_price | order_details |
order_details__original_wholesale_price | NUMERIC | order_details.original_wholesale_price | order_details.original_wholesale_price | order_details |
order_details__product_attribute_id | TEXT | order_details.product_attribute_id | order_details.product_attribute_id | order_details |
order_details__product_ean13 | TEXT | order_details.product_ean13 | order_details.product_ean13 | order_details |
order_details__product_id | TEXT | order_details.product_id | order_details.product_id | order_details |
order_details__product_isbn | TEXT | order_details.product_isbn | order_details.product_isbn | order_details |
order_details__product_mpn | TEXT | order_details.product_mpn | order_details.product_mpn | order_details |
order_details__product_name | TEXT | order_details.product_name | order_details.product_name | order_details |
order_details__product_price | NUMERIC | order_details.product_price | order_details.product_price | order_details |
order_details__product_quantity | NUMERIC | order_details.product_quantity | order_details.product_quantity | order_details |
order_details__product_quantity_discount | NUMERIC | order_details.product_quantity_discount | order_details.product_quantity_discount | order_details |
order_details__product_quantity_in_stock | TEXT | order_details.product_quantity_in_stock | order_details.product_quantity_in_stock | order_details |
order_details__product_quantity_refunded | TEXT | order_details.product_quantity_refunded | order_details.product_quantity_refunded | order_details |
order_details__product_quantity_reinjected | TEXT | order_details.product_quantity_reinjected | order_details.product_quantity_reinjected | order_details |
order_details__product_quantity_return | NUMERIC | order_details.product_quantity_return | order_details.product_quantity_return | order_details |
order_details__product_reference | TEXT | order_details.product_reference | order_details.product_reference | order_details |
order_details__product_supplier_reference | TEXT | order_details.product_supplier_reference | order_details.product_supplier_reference | order_details |
order_details__product_upc | TEXT | order_details.product_upc | order_details.product_upc | order_details |
order_details__product_weight | NUMERIC | order_details.product_weight | order_details.product_weight | order_details |
order_details__purchase_supplier_price | NUMERIC | order_details.purchase_supplier_price | order_details.purchase_supplier_price | order_details |
order_details__reduction_amount | TEXT | order_details.reduction_amount | order_details.reduction_amount | order_details |
order_details__reduction_amount_tax_excl | TEXT | order_details.reduction_amount_tax_excl | order_details.reduction_amount_tax_excl | order_details |
order_details__reduction_amount_tax_incl | TEXT | order_details.reduction_amount_tax_incl | order_details.reduction_amount_tax_incl | order_details |
order_details__reduction_percent | TEXT | order_details.reduction_percent | order_details.reduction_percent | order_details |
order_details__tax_computation_method | TEXT | order_details.tax_computation_method | order_details.tax_computation_method | order_details |
order_details__total_price_tax_excl | NUMERIC | order_details.total_price_tax_excl | order_details.total_price_tax_excl | order_details |
order_details__total_price_tax_incl | NUMERIC | order_details.total_price_tax_incl | order_details.total_price_tax_incl | order_details |
order_details__total_refunded_tax_excl | NUMERIC | order_details.total_refunded_tax_excl | order_details.total_refunded_tax_excl | order_details |
order_details__total_refunded_tax_incl | NUMERIC | order_details.total_refunded_tax_incl | order_details.total_refunded_tax_incl | order_details |
order_details__total_shipping_price_tax_excl | NUMERIC | order_details.total_shipping_price_tax_excl | order_details.total_shipping_price_tax_excl | order_details |
order_details__total_shipping_price_tax_incl | NUMERIC | order_details.total_shipping_price_tax_incl | order_details.total_shipping_price_tax_incl | order_details |
order_details__unit_price_tax_excl | NUMERIC | order_details.unit_price_tax_excl | order_details.unit_price_tax_excl | order_details |
order_details__unit_price_tax_incl | NUMERIC | order_details.unit_price_tax_incl | order_details.unit_price_tax_incl | order_details |
order_histories__date_add | DATE | order_histories.date_add | order_histories.date_add | order_histories |
order_histories__id | NUMERIC | order_histories.id | order_histories.id | order_histories |
order_histories__id_employee | TEXT | order_histories.id_employee | order_histories.id_employee | order_histories |
order_histories__id_order | TEXT | order_histories.id_order | order_histories.id_order | order_histories |
order_histories__id_order_state | TEXT | order_histories.id_order_state | order_histories.id_order_state | order_histories |
order_invoices__date_add | DATE | order_invoices.date_add | order_invoices.date_add | order_invoices |
order_invoices__delivery_date | DATE | order_invoices.delivery_date | order_invoices.delivery_date | order_invoices |
order_invoices__delivery_number | TEXT | order_invoices.delivery_number | order_invoices.delivery_number | order_invoices |
order_invoices__id | NUMERIC | order_invoices.id | order_invoices.id | order_invoices |
order_invoices__id_order | TEXT | order_invoices.id_order | order_invoices.id_order | order_invoices |
order_invoices__note | TEXT | order_invoices.note | order_invoices.note | order_invoices |
order_invoices__number | TEXT | order_invoices.number | order_invoices.number | order_invoices |
order_invoices__shipping_tax_computation_method | TEXT | order_invoices.shipping_tax_computation_method | order_invoices.shipping_tax_computation_method | order_invoices |
order_invoices__shop_address | TEXT | order_invoices.shop_address | order_invoices.shop_address | order_invoices |
order_invoices__total_discount_tax_excl | NUMERIC | order_invoices.total_discount_tax_excl | order_invoices.total_discount_tax_excl | order_invoices |
order_invoices__total_discount_tax_incl | NUMERIC | order_invoices.total_discount_tax_incl | order_invoices.total_discount_tax_incl | order_invoices |
order_invoices__total_paid_tax_excl | NUMERIC | order_invoices.total_paid_tax_excl | order_invoices.total_paid_tax_excl | order_invoices |
order_invoices__total_paid_tax_incl | NUMERIC | order_invoices.total_paid_tax_incl | order_invoices.total_paid_tax_incl | order_invoices |
order_invoices__total_products | TEXT | order_invoices.total_products | order_invoices.total_products | order_invoices |
order_invoices__total_products_wt | TEXT | order_invoices.total_products_wt | order_invoices.total_products_wt | order_invoices |
order_invoices__total_shipping_tax_excl | NUMERIC | order_invoices.total_shipping_tax_excl | order_invoices.total_shipping_tax_excl | order_invoices |
order_invoices__total_shipping_tax_incl | NUMERIC | order_invoices.total_shipping_tax_incl | order_invoices.total_shipping_tax_incl | order_invoices |
order_invoices__total_wrapping_tax_excl | NUMERIC | order_invoices.total_wrapping_tax_excl | order_invoices.total_wrapping_tax_excl | order_invoices |
order_invoices__total_wrapping_tax_incl | NUMERIC | order_invoices.total_wrapping_tax_incl | order_invoices.total_wrapping_tax_incl | order_invoices |
order_payments__amount | NUMERIC | order_payments.amount | order_payments.amount | order_payments |
order_payments__card_brand | TEXT | order_payments.card_brand | order_payments.card_brand | order_payments |
order_payments__card_expiration | TEXT | order_payments.card_expiration | order_payments.card_expiration | order_payments |
order_payments__card_holder | TEXT | order_payments.card_holder | order_payments.card_holder | order_payments |
order_payments__card_number | TEXT | order_payments.card_number | order_payments.card_number | order_payments |
order_payments__conversion_rate | TEXT | order_payments.conversion_rate | order_payments.conversion_rate | order_payments |
order_payments__date_add | DATE | order_payments.date_add | order_payments.date_add | order_payments |
order_payments__id | NUMERIC | order_payments.id | order_payments.id | order_payments |
order_payments__id_currency | TEXT | order_payments.id_currency | order_payments.id_currency | order_payments |
order_payments__order_reference | TEXT | order_payments.order_reference | order_payments.order_reference | order_payments |
order_payments__payment_method | TEXT | order_payments.payment_method | order_payments.payment_method | order_payments |
order_payments__transaction_id | TEXT | order_payments.transaction_id | order_payments.transaction_id | order_payments |
order_slip__amount | NUMERIC | order_slip.amount | order_slip.amount | order_slip |
order_slip__conversion_rate | TEXT | order_slip.conversion_rate | order_slip.conversion_rate | order_slip |
order_slip__date_add | DATE | order_slip.date_add | order_slip.date_add | order_slip |
order_slip__date_upd | DATE | order_slip.date_upd | order_slip.date_upd | order_slip |
order_slip__id | NUMERIC | order_slip.id | order_slip.id | order_slip |
order_slip__id_customer | TEXT | order_slip.id_customer | order_slip.id_customer | order_slip |
order_slip__id_order | TEXT | order_slip.id_order | order_slip.id_order | order_slip |
order_slip__order_slip_type | TEXT | order_slip.order_slip_type | order_slip.order_slip_type | order_slip |
order_slip__partial | TEXT | order_slip.partial | order_slip.partial | order_slip |
order_slip__shipping_cost | NUMERIC | order_slip.shipping_cost | order_slip.shipping_cost | order_slip |
order_slip__shipping_cost_amount | NUMERIC | order_slip.shipping_cost_amount | order_slip.shipping_cost_amount | order_slip |
order_slip__total_products_tax_excl | NUMERIC | order_slip.total_products_tax_excl | order_slip.total_products_tax_excl | order_slip |
order_slip__total_products_tax_incl | NUMERIC | order_slip.total_products_tax_incl | order_slip.total_products_tax_incl | order_slip |
order_slip__total_shipping_tax_excl | NUMERIC | order_slip.total_shipping_tax_excl | order_slip.total_shipping_tax_excl | order_slip |
order_slip__total_shipping_tax_incl | NUMERIC | order_slip.total_shipping_tax_incl | order_slip.total_shipping_tax_incl | order_slip |
order_states__color | TEXT | order_states.color | order_states.color | order_states |
order_states__deleted | TEXT | order_states.deleted | order_states.deleted | order_states |
order_states__delivery | TEXT | order_states.delivery | order_states.delivery | order_states |
TEXT | order_states.hidden | order_states.hidden | order_states | |
order_states__id | NUMERIC | order_states.id | order_states.id | order_states |
order_states__invoice | TEXT | order_states.invoice | order_states.invoice | order_states |
order_states__logable | TEXT | order_states.logable | order_states.logable | order_states |
order_states__module_name | TEXT | order_states.module_name | order_states.module_name | order_states |
order_states__name | TEXT | order_states.name | order_states.name | order_states |
order_states__paid | TEXT | order_states.paid | order_states.paid | order_states |
order_states__pdf_delivery | TEXT | order_states.pdf_delivery | order_states.pdf_delivery | order_states |
order_states__pdf_invoice | TEXT | order_states.pdf_invoice | order_states.pdf_invoice | order_states |
order_states__send_email | TEXT | order_states.send_email | order_states.send_email | order_states |
order_states__shipped | TEXT | order_states.shipped | order_states.shipped | order_states |
order_states__template | TEXT | order_states.template | order_states.template | order_states |
order_states__unremovable | TEXT | order_states.unremovable | order_states.unremovable | order_states |
orders__associations | OBJECT | orders.associations | orders.associations | orders |
orders__carrier_tax_rate | TEXT | orders.carrier_tax_rate | orders.carrier_tax_rate | orders |
orders__conversion_rate | TEXT | orders.conversion_rate | orders.conversion_rate | orders |
orders__current_state | TEXT | orders.current_state | orders.current_state | orders |
orders__date_add | DATE | orders.date_add | orders.date_add | orders |
orders__date_upd | DATE | orders.date_upd | orders.date_upd | orders |
orders__delivery_date | DATE | orders.delivery_date | orders.delivery_date | orders |
orders__delivery_number | TEXT | orders.delivery_number | orders.delivery_number | orders |
orders__gift | TEXT | orders.gift | orders.gift | orders |
orders__gift_message | TEXT | orders.gift_message | orders.gift_message | orders |
orders__id | NUMERIC | orders.id | orders.id | orders |
orders__id_address_delivery | TEXT | orders.id_address_delivery | orders.id_address_delivery | orders |
orders__id_address_invoice | TEXT | orders.id_address_invoice | orders.id_address_invoice | orders |
orders__id_carrier | TEXT | orders.id_carrier | orders.id_carrier | orders |
orders__id_cart | TEXT | orders.id_cart | orders.id_cart | orders |
orders__id_currency | TEXT | orders.id_currency | orders.id_currency | orders |
orders__id_customer | TEXT | orders.id_customer | orders.id_customer | orders |
orders__id_lang | TEXT | orders.id_lang | orders.id_lang | orders |
orders__id_shop | TEXT | orders.id_shop | orders.id_shop | orders |
orders__id_shop_group | TEXT | orders.id_shop_group | orders.id_shop_group | orders |
orders__invoice_date | DATE | orders.invoice_date | orders.invoice_date | orders |
orders__invoice_number | TEXT | orders.invoice_number | orders.invoice_number | orders |
orders__mobile_theme | TEXT | orders.mobile_theme | orders.mobile_theme | orders |
orders__module | TEXT | orders.module | orders.module | orders |
orders__payment | TEXT | orders.payment | orders.payment | orders |
orders__recyclable | TEXT | orders.recyclable | orders.recyclable | orders |
orders__reference | TEXT | orders.reference | orders.reference | orders |
orders__round_mode | TEXT | orders.round_mode | orders.round_mode | orders |
orders__round_type | TEXT | orders.round_type | orders.round_type | orders |
orders__secure_key | TEXT | orders.secure_key | orders.secure_key | orders |
orders__shipping_number | TEXT | orders.shipping_number | orders.shipping_number | orders |
orders__total_discounts | NUMERIC | orders.total_discounts | orders.total_discounts | orders |
orders__total_discounts_tax_excl | NUMERIC | orders.total_discounts_tax_excl | orders.total_discounts_tax_excl | orders |
orders__total_discounts_tax_incl | NUMERIC | orders.total_discounts_tax_incl | orders.total_discounts_tax_incl | orders |
orders__total_paid | NUMERIC | orders.total_paid | orders.total_paid | orders |
orders__total_paid_real | NUMERIC | orders.total_paid_real | orders.total_paid_real | orders |
orders__total_paid_tax_excl | NUMERIC | orders.total_paid_tax_excl | orders.total_paid_tax_excl | orders |
orders__total_paid_tax_incl | NUMERIC | orders.total_paid_tax_incl | orders.total_paid_tax_incl | orders |
orders__total_products | NUMERIC | orders.total_products | orders.total_products | orders |
orders__total_products_wt | NUMERIC | orders.total_products_wt | orders.total_products_wt | orders |
orders__total_shipping | NUMERIC | orders.total_shipping | orders.total_shipping | orders |
orders__total_shipping_tax_excl | NUMERIC | orders.total_shipping_tax_excl | orders.total_shipping_tax_excl | orders |
orders__total_shipping_tax_incl | NUMERIC | orders.total_shipping_tax_incl | orders.total_shipping_tax_incl | orders |
orders__total_wrapping | NUMERIC | orders.total_wrapping | orders.total_wrapping | orders |
orders__total_wrapping_tax_excl | NUMERIC | orders.total_wrapping_tax_excl | orders.total_wrapping_tax_excl | orders |
orders__total_wrapping_tax_incl | NUMERIC | orders.total_wrapping_tax_incl | orders.total_wrapping_tax_incl | orders |
orders__valid | TEXT | orders.valid | orders.valid | orders |
price_ranges__delimiter1 | TEXT | price_ranges.delimiter1 | price_ranges.delimiter1 | price_ranges |
price_ranges__delimiter2 | TEXT | price_ranges.delimiter2 | price_ranges.delimiter2 | price_ranges |
price_ranges__id | NUMERIC | price_ranges.id | price_ranges.id | price_ranges |
price_ranges__id_carrier | TEXT | price_ranges.id_carrier | price_ranges.id_carrier | price_ranges |
product_customization_fields__id | NUMERIC | product_customization_fields.id | product_customization_fields.id | product_customization_fields |
product_customization_fields__id_product | TEXT | product_customization_fields.id_product | product_customization_fields.id_product | product_customization_fields |
product_customization_fields__is_deleted | TEXT | product_customization_fields.is_deleted | product_customization_fields.is_deleted | product_customization_fields |
product_customization_fields__is_module | TEXT | product_customization_fields.is_module | product_customization_fields.is_module | product_customization_fields |
product_customization_fields__name | TEXT | product_customization_fields.name | product_customization_fields.name | product_customization_fields |
product_customization_fields__required | TEXT | product_customization_fields.required | product_customization_fields.required | product_customization_fields |
product_customization_fields__type | TEXT | product_customization_fields.type | product_customization_fields.type | product_customization_fields |
product_feature_values__custom | TEXT | product_feature_values.custom | product_feature_values.custom | product_feature_values |
product_feature_values__id | NUMERIC | product_feature_values.id | product_feature_values.id | product_feature_values |
product_feature_values__id_feature | TEXT | product_feature_values.id_feature | product_feature_values.id_feature | product_feature_values |
product_feature_values__value | TEXT | product_feature_values.value | product_feature_values.value | product_feature_values |
product_features__id | NUMERIC | product_features.id | product_features.id | product_features |
product_features__name | TEXT | product_features.name | product_features.name | product_features |
product_features__position | TEXT | product_features.position | product_features.position | product_features |
product_option_values__color | TEXT | product_option_values.color | product_option_values.color | product_option_values |
product_option_values__id | NUMERIC | product_option_values.id | product_option_values.id | product_option_values |
product_option_values__id_attribute_group | TEXT | product_option_values.id_attribute_group | product_option_values.id_attribute_group | product_option_values |
product_option_values__name | TEXT | product_option_values.name | product_option_values.name | product_option_values |
product_option_values__position | TEXT | product_option_values.position | product_option_values.position | product_option_values |
product_options__associations | OBJECT | product_options.associations | product_options.associations | product_options |
product_options__group_type | TEXT | product_options.group_type | product_options.group_type | product_options |
product_options__id | NUMERIC | product_options.id | product_options.id | product_options |
product_options__is_color_group | TEXT | product_options.is_color_group | product_options.is_color_group | product_options |
product_options__name | TEXT | product_options.name | product_options.name | product_options |
product_options__position | TEXT | product_options.position | product_options.position | product_options |
product_options__public_name | TEXT | product_options.public_name | product_options.public_name | product_options |
product_suppliers__id | NUMERIC | product_suppliers.id | product_suppliers.id | product_suppliers |
product_suppliers__id_currency | TEXT | product_suppliers.id_currency | product_suppliers.id_currency | product_suppliers |
product_suppliers__id_product | TEXT | product_suppliers.id_product | product_suppliers.id_product | product_suppliers |
product_suppliers__id_product_attribute | TEXT | product_suppliers.id_product_attribute | product_suppliers.id_product_attribute | product_suppliers |
product_suppliers__id_supplier | TEXT | product_suppliers.id_supplier | product_suppliers.id_supplier | product_suppliers |
product_suppliers__product_supplier_price_te | TEXT | product_suppliers.product_supplier_price_te | product_suppliers.product_supplier_price_te | product_suppliers |
product_suppliers__product_supplier_reference | TEXT | product_suppliers.product_supplier_reference | product_suppliers.product_supplier_reference | product_suppliers |
products__active | TEXT | products.active | products.active | products |
products__additional_delivery_times | TEXT | products.additional_delivery_times | products.additional_delivery_times | products |
products__additional_shipping_cost | NUMERIC | products.additional_shipping_cost | products.additional_shipping_cost | products |
products__advanced_stock_management | TEXT | products.advanced_stock_management | products.advanced_stock_management | products |
products__associations | OBJECT | products.associations | products.associations | products |
products__available_date | DATE | products.available_date | products.available_date | products |
products__available_for_order | TEXT | products.available_for_order | products.available_for_order | products |
products__available_later | TEXT | products.available_later | products.available_later | products |
products__available_now | TEXT | products.available_now | products.available_now | products |
products__cache_default_attribute | TEXT | products.cache_default_attribute | products.cache_default_attribute | products |
products__cache_has_attachments | TEXT | products.cache_has_attachments | products.cache_has_attachments | products |
products__cache_is_pack | TEXT | products.cache_is_pack | products.cache_is_pack | products |
products__condition | TEXT | products.condition | products.condition | products |
products__customizable | TEXT | products.customizable | products.customizable | products |
products__date_add | DATE | products.date_add | products.date_add | products |
products__date_upd | DATE | products.date_upd | products.date_upd | products |
products__delivery_in_stock | TEXT | products.delivery_in_stock | products.delivery_in_stock | products |
products__delivery_out_stock | TEXT | products.delivery_out_stock | products.delivery_out_stock | products |
products__depth | NUMERIC | products.depth | products.depth | products |
products__description | TEXT | products.description | products.description | products |
products__description_short | TEXT | products.description_short | products.description_short | products |
products__ean13 | TEXT | products.ean13 | products.ean13 | products |
products__ecotax | TEXT | products.ecotax | products.ecotax | products |
products__height | NUMERIC | products.height | products.height | products |
products__id | NUMERIC | products.id | products.id | products |
products__id_category_default | TEXT | products.id_category_default | products.id_category_default | products |
products__id_default_combination | NUMERIC | products.id_default_combination | products.id_default_combination | products |
products__id_default_image | TEXT | products.id_default_image | products.id_default_image | products |
products__id_manufacturer | TEXT | products.id_manufacturer | products.id_manufacturer | products |
products__id_shop_default | TEXT | products.id_shop_default | products.id_shop_default | products |
products__id_supplier | TEXT | products.id_supplier | products.id_supplier | products |
products__id_tax_rules_group | TEXT | products.id_tax_rules_group | products.id_tax_rules_group | products |
products__id_type_redirected | TEXT | products.id_type_redirected | products.id_type_redirected | products |
products__indexed | TEXT | products.indexed | products.indexed | products |
products__is_virtual | TEXT | products.is_virtual | products.is_virtual | products |
products__isbn | TEXT | products.isbn | products.isbn | products |
products__link_rewrite | TEXT | products.link_rewrite | products.link_rewrite | products |
products__location | TEXT | products.location | products.location | products |
products__low_stock_alert | TEXT | products.low_stock_alert | products.low_stock_alert | products |
products__low_stock_threshold | TEXT | products.low_stock_threshold | products.low_stock_threshold | products |
products__manufacturer_name | TEXT | products.manufacturer_name | products.manufacturer_name | products |
products__meta_description | TEXT | products.meta_description | products.meta_description | products |
products__meta_keywords | TEXT | products.meta_keywords | products.meta_keywords | products |
products__meta_title | TEXT | products.meta_title | products.meta_title | products |
products__minimal_quantity | TEXT | products.minimal_quantity | products.minimal_quantity | products |
products__mpn | TEXT | products.mpn | products.mpn | products |
products__name | TEXT | products.name | products.name | products |
products__new | TEXT | products.new | products.new | products |
products__on_sale | BOOLEAN | products.on_sale | products.on_sale | products |
products__online_only | TEXT | products.online_only | products.online_only | products |
products__pack_stock_type | TEXT | products.pack_stock_type | products.pack_stock_type | products |
products__position_in_category | TEXT | products.position_in_category | products.position_in_category | products |
products__price | NUMERIC | products.price | products.price | products |
products__quantity | NUMERIC | products.quantity | products.quantity | products |
products__quantity_discount | NUMERIC | products.quantity_discount | products.quantity_discount | products |
products__redirect_type | TEXT | products.redirect_type | products.redirect_type | products |
products__reference | TEXT | products.reference | products.reference | products |
products__show_condition | TEXT | products.show_condition | products.show_condition | products |
products__show_price | TEXT | products.show_price | products.show_price | products |
products__state | TEXT | products.state | products.state | products |
products__supplier_reference | TEXT | products.supplier_reference | products.supplier_reference | products |
products__text_fields | TEXT | products.text_fields | products.text_fields | products |
products__type | TEXT | products.type | products.type | products |
products__unit_price_ratio | NUMERIC | products.unit_price_ratio | products.unit_price_ratio | products |
products__unity | TEXT | products.unity | products.unity | products |
products__upc | TEXT | products.upc | products.upc | products |
products__uploadable_files | TEXT | products.uploadable_files | products.uploadable_files | products |
products__visibility | TEXT | products.visibility | products.visibility | products |
products__weight | NUMERIC | products.weight | products.weight | products |
products__wholesale_price | NUMERIC | products.wholesale_price | products.wholesale_price | products |
products__width | NUMERIC | products.width | products.width | products |
shop_groups__active | TEXT | shop_groups.active | shop_groups.active | shop_groups |
shop_groups__deleted | TEXT | shop_groups.deleted | shop_groups.deleted | shop_groups |
shop_groups__id | NUMERIC | shop_groups.id | shop_groups.id | shop_groups |
shop_groups__name | TEXT | shop_groups.name | shop_groups.name | shop_groups |
shop_groups__share_customer | TEXT | shop_groups.share_customer | shop_groups.share_customer | shop_groups |
shop_groups__share_order | TEXT | shop_groups.share_order | shop_groups.share_order | shop_groups |
shop_groups__share_stock | TEXT | shop_groups.share_stock | shop_groups.share_stock | shop_groups |
shop_urls__active | TEXT | shop_urls.active | shop_urls.active | shop_urls |
shop_urls__domain | TEXT | shop_urls.domain | shop_urls.domain | shop_urls |
shop_urls__domain_ssl | TEXT | shop_urls.domain_ssl | shop_urls.domain_ssl | shop_urls |
shop_urls__id | NUMERIC | shop_urls.id | shop_urls.id | shop_urls |
shop_urls__id_shop | TEXT | shop_urls.id_shop | shop_urls.id_shop | shop_urls |
shop_urls__main | TEXT | shop_urls.main | shop_urls.main | shop_urls |
shop_urls__physical_uri | TEXT | shop_urls.physical_uri | shop_urls.physical_uri | shop_urls |
shop_urls__virtual_uri | TEXT | shop_urls.virtual_uri | shop_urls.virtual_uri | shop_urls |
shops__active | TEXT | shops.active | shops.active | shops |
shops__deleted | TEXT | shops.deleted | shops.deleted | shops |
shops__id | NUMERIC | shops.id | shops.id | shops |
shops__id_category | TEXT | shops.id_category | shops.id_category | shops |
shops__id_shop_group | TEXT | shops.id_shop_group | shops.id_shop_group | shops |
shops__name | TEXT | shops.name | shops.name | shops |
shops__theme_name | TEXT | shops.theme_name | shops.theme_name | shops |
source | TEXT | Source | The name of the Windsor connector returning the row | |
specific_price_rules__from | TEXT | specific_price_rules.from | specific_price_rules.from | specific_price_rules |
specific_price_rules__from_quantity | TEXT | specific_price_rules.from_quantity | specific_price_rules.from_quantity | specific_price_rules |
specific_price_rules__id | NUMERIC | specific_price_rules.id | specific_price_rules.id | specific_price_rules |
specific_price_rules__id_country | COUNTRY | specific_price_rules.id_country | specific_price_rules.id_country | specific_price_rules |
specific_price_rules__id_currency | TEXT | specific_price_rules.id_currency | specific_price_rules.id_currency | specific_price_rules |
specific_price_rules__id_group | TEXT | specific_price_rules.id_group | specific_price_rules.id_group | specific_price_rules |
specific_price_rules__id_shop | TEXT | specific_price_rules.id_shop | specific_price_rules.id_shop | specific_price_rules |
specific_price_rules__name | TEXT | specific_price_rules.name | specific_price_rules.name | specific_price_rules |
specific_price_rules__price | NUMERIC | specific_price_rules.price | specific_price_rules.price | specific_price_rules |
specific_price_rules__reduction | TEXT | specific_price_rules.reduction | specific_price_rules.reduction | specific_price_rules |
specific_price_rules__reduction_tax | TEXT | specific_price_rules.reduction_tax | specific_price_rules.reduction_tax | specific_price_rules |
specific_price_rules__reduction_type | TEXT | specific_price_rules.reduction_type | specific_price_rules.reduction_type | specific_price_rules |
specific_price_rules__to | NUMERIC | specific_price_rules.to | specific_price_rules.to | specific_price_rules |
specific_prices__from | NUMERIC | specific_prices.from | specific_prices.from | specific_prices |
specific_prices__from_quantity | NUMERIC | specific_prices.from_quantity | specific_prices.from_quantity | specific_prices |
specific_prices__id | NUMERIC | specific_prices.id | specific_prices.id | specific_prices |
specific_prices__id_cart | TEXT | specific_prices.id_cart | specific_prices.id_cart | specific_prices |
specific_prices__id_country | COUNTRY | specific_prices.id_country | specific_prices.id_country | specific_prices |
specific_prices__id_currency | TEXT | specific_prices.id_currency | specific_prices.id_currency | specific_prices |
specific_prices__id_customer | TEXT | specific_prices.id_customer | specific_prices.id_customer | specific_prices |
specific_prices__id_group | TEXT | specific_prices.id_group | specific_prices.id_group | specific_prices |
specific_prices__id_product | TEXT | specific_prices.id_product | specific_prices.id_product | specific_prices |
specific_prices__id_product_attribute | TEXT | specific_prices.id_product_attribute | specific_prices.id_product_attribute | specific_prices |
specific_prices__id_shop | TEXT | specific_prices.id_shop | specific_prices.id_shop | specific_prices |
specific_prices__id_shop_group | TEXT | specific_prices.id_shop_group | specific_prices.id_shop_group | specific_prices |
specific_prices__id_specific_price_rule | TEXT | specific_prices.id_specific_price_rule | specific_prices.id_specific_price_rule | specific_prices |
specific_prices__price | NUMERIC | specific_prices.price | specific_prices.price | specific_prices |
specific_prices__reduction | TEXT | specific_prices.reduction | specific_prices.reduction | specific_prices |
specific_prices__reduction_tax | TEXT | specific_prices.reduction_tax | specific_prices.reduction_tax | specific_prices |
specific_prices__reduction_type | TEXT | specific_prices.reduction_type | specific_prices.reduction_type | specific_prices |
specific_prices__to | TEXT | specific_prices.to | specific_prices.to | specific_prices |
states__active | TEXT | states.active | states.active | states |
states__id | NUMERIC | states.id | states.id | states |
states__id_country | COUNTRY | states.id_country | states.id_country | states |
states__id_zone | TEXT | states.id_zone | states.id_zone | states |
states__iso_code | TEXT | states.iso_code | states.iso_code | states |
states__name | TEXT | states.name | states.name | states |
stock_availables__depends_on_stock | TEXT | stock_availables.depends_on_stock | stock_availables.depends_on_stock | stock_availables |
stock_availables__id | NUMERIC | stock_availables.id | stock_availables.id | stock_availables |
stock_availables__id_product | TEXT | stock_availables.id_product | stock_availables.id_product | stock_availables |
stock_availables__id_product_attribute | TEXT | stock_availables.id_product_attribute | stock_availables.id_product_attribute | stock_availables |
stock_availables__id_shop | TEXT | stock_availables.id_shop | stock_availables.id_shop | stock_availables |
stock_availables__id_shop_group | TEXT | stock_availables.id_shop_group | stock_availables.id_shop_group | stock_availables |
stock_availables__location | TEXT | stock_availables.location | stock_availables.location | stock_availables |
stock_availables__out_of_stock | TEXT | stock_availables.out_of_stock | stock_availables.out_of_stock | stock_availables |
stock_availables__quantity | NUMERIC | stock_availables.quantity | stock_availables.quantity | stock_availables |
stock_movement_reasons__date_add | DATE | stock_movement_reasons.date_add | stock_movement_reasons.date_add | stock_movement_reasons |
stock_movement_reasons__date_upd | DATE | stock_movement_reasons.date_upd | stock_movement_reasons.date_upd | stock_movement_reasons |
stock_movement_reasons__deleted | TEXT | stock_movement_reasons.deleted | stock_movement_reasons.deleted | stock_movement_reasons |
stock_movement_reasons__id | NUMERIC | stock_movement_reasons.id | stock_movement_reasons.id | stock_movement_reasons |
stock_movement_reasons__name | TEXT | stock_movement_reasons.name | stock_movement_reasons.name | stock_movement_reasons |
stock_movement_reasons__sign | TEXT | stock_movement_reasons.sign | stock_movement_reasons.sign | stock_movement_reasons |
stock_movements__current_wa | TEXT | stock_movements.current_wa | stock_movements.current_wa | stock_movements |
stock_movements__date_add | DATE | stock_movements.date_add | stock_movements.date_add | stock_movements |
stock_movements__ean13 | TEXT | stock_movements.ean13 | stock_movements.ean13 | stock_movements |
stock_movements__id | NUMERIC | stock_movements.id | stock_movements.id | stock_movements |
stock_movements__id_currency | TEXT | stock_movements.id_currency | stock_movements.id_currency | stock_movements |
stock_movements__id_employee | TEXT | stock_movements.id_employee | stock_movements.id_employee | stock_movements |
stock_movements__id_order | TEXT | stock_movements.id_order | stock_movements.id_order | stock_movements |
stock_movements__id_product | TEXT | stock_movements.id_product | stock_movements.id_product | stock_movements |
stock_movements__id_product_attribute | TEXT | stock_movements.id_product_attribute | stock_movements.id_product_attribute | stock_movements |
stock_movements__id_stock | TEXT | stock_movements.id_stock | stock_movements.id_stock | stock_movements |
stock_movements__id_stock_mvt_reason | TEXT | stock_movements.id_stock_mvt_reason | stock_movements.id_stock_mvt_reason | stock_movements |
stock_movements__id_supply_order | TEXT | stock_movements.id_supply_order | stock_movements.id_supply_order | stock_movements |
stock_movements__id_warehouse | TEXT | stock_movements.id_warehouse | stock_movements.id_warehouse | stock_movements |
stock_movements__last_wa | TEXT | stock_movements.last_wa | stock_movements.last_wa | stock_movements |
stock_movements__management_type | TEXT | stock_movements.management_type | stock_movements.management_type | stock_movements |
stock_movements__mpn | TEXT | stock_movements.mpn | stock_movements.mpn | stock_movements |
stock_movements__physical_quantity | NUMERIC | stock_movements.physical_quantity | stock_movements.physical_quantity | stock_movements |
stock_movements__price_te | TEXT | stock_movements.price_te | stock_movements.price_te | stock_movements |
stock_movements__product_name | BOOLEAN | stock_movements.product_name | stock_movements.product_name | stock_movements |
stock_movements__reference | TEXT | stock_movements.reference | stock_movements.reference | stock_movements |
stock_movements__sign | TEXT | stock_movements.sign | stock_movements.sign | stock_movements |
stock_movements__upc | TEXT | stock_movements.upc | stock_movements.upc | stock_movements |
stores__active | TEXT | stores.active | stores.active | stores |
stores__address1 | TEXT | stores.address1 | stores.address1 | stores |
stores__address2 | TEXT | stores.address2 | stores.address2 | stores |
stores__city | CITY | stores.city | stores.city | stores |
stores__date_add | DATE | stores.date_add | stores.date_add | stores |
stores__date_upd | DATE | stores.date_upd | stores.date_upd | stores |
stores__email | TEXT | stores.email | stores.email | stores |
stores__fax | TEXT | stores.fax | stores.fax | stores |
stores__hours | TEXT | stores.hours | stores.hours | stores |
stores__id | NUMERIC | stores.id | stores.id | stores |
stores__id_country | COUNTRY | stores.id_country | stores.id_country | stores |
stores__id_state | TEXT | stores.id_state | stores.id_state | stores |
stores__latitude | TEXT | stores.latitude | stores.latitude | stores |
stores__longitude | TEXT | stores.longitude | stores.longitude | stores |
stores__name | TEXT | stores.name | stores.name | stores |
stores__note | TEXT | stores.note | stores.note | stores |
stores__phone | TEXT | stores.phone | stores.phone | stores |
stores__postcode | TEXT | stores.postcode | stores.postcode | stores |
suppliers__active | TEXT | suppliers.active | suppliers.active | suppliers |
suppliers__date_add | DATE | suppliers.date_add | suppliers.date_add | suppliers |
suppliers__date_upd | DATE | suppliers.date_upd | suppliers.date_upd | suppliers |
suppliers__description | TEXT | suppliers.description | suppliers.description | suppliers |
suppliers__id | NUMERIC | suppliers.id | suppliers.id | suppliers |
suppliers__link_rewrite | TEXT | suppliers.link_rewrite | suppliers.link_rewrite | suppliers |
suppliers__meta_description | TEXT | suppliers.meta_description | suppliers.meta_description | suppliers |
suppliers__meta_keywords | TEXT | suppliers.meta_keywords | suppliers.meta_keywords | suppliers |
suppliers__meta_title | TEXT | suppliers.meta_title | suppliers.meta_title | suppliers |
suppliers__name | TEXT | suppliers.name | suppliers.name | suppliers |
tags__id | TEXT | tags.id | tags.id | tags |
tags__id_lang | TEXT | tags.id_lang | tags.id_lang | tags |
tags__name | TEXT | tags.name | tags.name | tags |
tax_rule_groups__active | TEXT | tax_rule_groups.active | tax_rule_groups.active | tax_rule_groups |
tax_rule_groups__date_add | DATE | tax_rule_groups.date_add | tax_rule_groups.date_add | tax_rule_groups |
tax_rule_groups__date_upd | DATE | tax_rule_groups.date_upd | tax_rule_groups.date_upd | tax_rule_groups |
tax_rule_groups__deleted | TEXT | tax_rule_groups.deleted | tax_rule_groups.deleted | tax_rule_groups |
tax_rule_groups__id | NUMERIC | tax_rule_groups.id | tax_rule_groups.id | tax_rule_groups |
tax_rule_groups__name | TEXT | tax_rule_groups.name | tax_rule_groups.name | tax_rule_groups |
tax_rules__behavior | TEXT | tax_rules.behavior | tax_rules.behavior | tax_rules |
tax_rules__description | TEXT | tax_rules.description | tax_rules.description | tax_rules |
tax_rules__id | NUMERIC | tax_rules.id | tax_rules.id | tax_rules |
tax_rules__id_country | COUNTRY | tax_rules.id_country | tax_rules.id_country | tax_rules |
tax_rules__id_state | TEXT | tax_rules.id_state | tax_rules.id_state | tax_rules |
tax_rules__id_tax | TEXT | tax_rules.id_tax | tax_rules.id_tax | tax_rules |
tax_rules__id_tax_rules_group | TEXT | tax_rules.id_tax_rules_group | tax_rules.id_tax_rules_group | tax_rules |
tax_rules__zipcode_from | TEXT | tax_rules.zipcode_from | tax_rules.zipcode_from | tax_rules |
tax_rules__zipcode_to | TEXT | tax_rules.zipcode_to | tax_rules.zipcode_to | tax_rules |
taxes__active | TEXT | taxes.active | taxes.active | taxes |
taxes__deleted | TEXT | taxes.deleted | taxes.deleted | taxes |
taxes__id | NUMERIC | taxes.id | taxes.id | taxes |
taxes__name | TEXT | taxes.name | taxes.name | taxes |
taxes__rate | TEXT | taxes.rate | taxes.rate | taxes |
today | DATE | Today | Today's date | |
translated_configurations__date_add | DATE | translated_configurations.date_add | translated_configurations.date_add | translated_configurations |
translated_configurations__date_upd | DATE | translated_configurations.date_upd | translated_configurations.date_upd | translated_configurations |
translated_configurations__id | NUMERIC | translated_configurations.id | translated_configurations.id | translated_configurations |
translated_configurations__id_shop | TEXT | translated_configurations.id_shop | translated_configurations.id_shop | translated_configurations |
translated_configurations__id_shop_group | TEXT | translated_configurations.id_shop_group | translated_configurations.id_shop_group | translated_configurations |
translated_configurations__name | TEXT | translated_configurations.name | translated_configurations.name | translated_configurations |
translated_configurations__value | TEXT | translated_configurations.value | translated_configurations.value | translated_configurations |
weight_ranges__delimiter1 | TEXT | weight_ranges.delimiter1 | weight_ranges.delimiter1 | weight_ranges |
weight_ranges__delimiter2 | TEXT | weight_ranges.delimiter2 | weight_ranges.delimiter2 | weight_ranges |
weight_ranges__id | NUMERIC | weight_ranges.id | weight_ranges.id | weight_ranges |
weight_ranges__id_carrier | TEXT | weight_ranges.id_carrier | weight_ranges.id_carrier | weight_ranges |
zones__active | TEXT | zones.active | zones.active | zones |
zones__id | NUMERIC | zones.id | zones.id | zones |
zones__name | TEXT | zones.name | zones.name | zones |