Integration of PrestaShop with BigQuery
Learn how to connect PrestaShop to Google BigQuery using WitCloud to collect orders, customers, products, stock and other shop data for analysis.
Updated
Introduction
This module connects your PrestaShop store to Google Cloud BigQuery. WitCloud reads your orders, order lines, customers, addresses, products, combinations, stock levels, categories, manufacturers, currencies, cart rules and other shop data through the PrestaShop web service (API) and stores them in your project's BigQuery dataset. You can then analyze sales and stock together with your advertising data and use the tables in the All in One solution.
Configuration guide
Follow the steps below to connect PrestaShop with BigQuery. WitCloud needs the address of your shop and a PrestaShop web service key that is allowed to read your data.
Create the web service key before you start: you will paste it into WitCloud in the Authorization step. Read-only access is enough, because WitCloud only reads data from your shop.
Create the web service key in PrestaShop
This step takes place in your PrestaShop back office, which is not part of WitCloud. The menu names below come from PrestaShop and may differ between its versions; see the PrestaShop documentation if you cannot find them.
- Log in to your PrestaShop back office as an administrator.
- Go to Advanced Parameters > Webservice and make sure the web service is enabled.
- Click Add new webservice key and generate a key.
- Give the key read access (View, the GET method) to the resources you want to collect, for example orders, customers, products and stock.
- Save the key and copy it. Keep it private: anyone who has it can read the data it gives access to.
Module setup
Go to Integrations and click Add integration.

Select PrestaShop from the list of available integrations.

Enter the Collect name, e.g. "PrestaShop PL". A clear name helps you recognise the data source later.

Enter the Shop url: the address of your shop, including https://, e.g. https://your-shop.com. The Authorize button stays inactive until you enter a valid address.

Authorization
If you have already authorized this PrestaShop shop in WitCloud, you can pick the existing token from the Prestashop authorization drop-down and skip the next two steps.
Click Authorize.

In the Authorize pop-up paste the web service key into the Access token field and click Create. WitCloud checks the key against the shop address you entered. If the shop cannot be reached, the address or the key is wrong, or the key has no permission to read data, the reason is shown under the form.

The saved token is selected automatically. It is listed by the shop address and a masked part of the key. You can also choose a token from the Prestashop authorization drop-down.

Advanced settings
Click Show advanced settings to see three more fields.
In Data freshness (products, stocks) enter how often, in hours, tables that hold the whole catalogue (such as products and stocks) are refreshed. The value must be between 4 and 12 hours; the default is 4.

Turn on Static IP if your shop only accepts requests from allowed IP addresses, for example behind a firewall or Cloudflare. All data requests are then sent from one fixed IP address, 34.118.32.227, which you can add to the allowed list of your shop.

In Tables to collect you can remove the tables you do not need. All 18 tables described in the data schema below are selected by default, and at least one must stay selected. Collecting fewer tables makes the data retrieval faster.

The customers and addresses tables contain personal data of your shoppers, such as names, email addresses, postal addresses and phone numbers. Remove them from Tables to collect if you do not need them.
Click Next.

Historical data and scheduling
In Historical Data enter the number of days to fetch on the first run, up to 365.

A data synchronization schedule is created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

Done! Your PrestaShop data will now be synchronized with BigQuery. Orders, order lines, order cart rules, customers and the delivery addresses of orders are collected day by day, by the date they were created. The other tables (products, combinations, stock, categories, manufacturers, countries, currencies, order states, product options, shop URLs and cart rules) are collected in full on each run.
Data schema
The tables below show the data collected from PrestaShop. Their names in BigQuery follow the pattern prestashop_<table>_<collect ID>, for example prestashop_orders_<collect ID>.
Data schema for prestashop_addresses
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_customer | NULLABLE | STRING |
| id_manufacturer | NULLABLE | STRING |
| id_supplier | NULLABLE | STRING |
| id_warehouse | NULLABLE | STRING |
| id_country | NULLABLE | STRING |
| id_state | NULLABLE | STRING |
| alias | NULLABLE | STRING |
| company | NULLABLE | STRING |
| lastname | NULLABLE | STRING |
| firstname | NULLABLE | STRING |
| vat_number | NULLABLE | STRING |
| address1 | NULLABLE | STRING |
| address2 | NULLABLE | STRING |
| postcode | NULLABLE | STRING |
| city | NULLABLE | STRING |
| other | NULLABLE | STRING |
| phone | NULLABLE | STRING |
| phone_mobile | NULLABLE | STRING |
| dni | NULLABLE | STRING |
| deleted | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
Data schema for prestashop_cart_rules
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| name | NULLABLE | JSON |
| description | NULLABLE | STRING |
| code | NULLABLE | STRING |
| quantity | NULLABLE | STRING |
| quantity_per_user | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| date_from | NULLABLE | DATETIME |
| date_to | NULLABLE | DATETIME |
| priority | NULLABLE | STRING |
| partial_use | NULLABLE | BOOLEAN |
| minimum_amount | NULLABLE | FLOAT |
| minimum_amount_tax | NULLABLE | BOOLEAN |
| minimum_amount_currency | NULLABLE | STRING |
| minimum_amount_shipping | NULLABLE | BOOLEAN |
| country_restriction | NULLABLE | BOOLEAN |
| carrier_restriction | NULLABLE | BOOLEAN |
| group_restriction | NULLABLE | BOOLEAN |
| cart_rule_restriction | NULLABLE | BOOLEAN |
| product_restriction | NULLABLE | BOOLEAN |
| shop_restriction | NULLABLE | BOOLEAN |
| free_shipping | NULLABLE | BOOLEAN |
| reduction_percent | NULLABLE | FLOAT |
| reduction_amount | NULLABLE | FLOAT |
| reduction_tax | NULLABLE | BOOLEAN |
| reduction_currency | NULLABLE | STRING |
| reduction_product | NULLABLE | STRING |
| reduction_exclude_special | NULLABLE | BOOLEAN |
| gift_product | NULLABLE | STRING |
| gift_product_attribute | NULLABLE | STRING |
| highlight | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
Data schema for prestashop_categories
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_parent | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| id_shop_default | NULLABLE | STRING |
| is_root_category | NULLABLE | BOOLEAN |
| position | NULLABLE | STRING |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| name | NULLABLE | JSON |
| link_rewrite | NULLABLE | JSON |
| description | NULLABLE | JSON |
| meta_title | NULLABLE | JSON |
| meta_description | NULLABLE | JSON |
| meta_keywords | NULLABLE | JSON |
| associations | NULLABLE | RECORD |
| associations.categories | REPEATED | RECORD |
| associations.categories.id | NULLABLE | STRING |
| associations.products | REPEATED | RECORD |
| associations.products.id | NULLABLE | STRING |
Data schema for prestashop_combinations
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_product | NULLABLE | STRING |
| location | NULLABLE | STRING |
| ean13 | NULLABLE | STRING |
| isbn | NULLABLE | STRING |
| upc | NULLABLE | STRING |
| mpn | NULLABLE | STRING |
| quantity | NULLABLE | INTEGER |
| reference | NULLABLE | STRING |
| supplier_reference | NULLABLE | STRING |
| wholesale_price | NULLABLE | FLOAT |
| price | NULLABLE | FLOAT |
| ecotax | NULLABLE | FLOAT |
| weight | NULLABLE | FLOAT |
| unit_price_impact | NULLABLE | FLOAT |
| minimal_quantity | NULLABLE | INTEGER |
| low_stock_threshold | NULLABLE | INTEGER |
| low_stock_alert | NULLABLE | BOOLEAN |
| default_on | NULLABLE | BOOLEAN |
| available_date | NULLABLE | STRING |
| associations | NULLABLE | RECORD |
| associations.product_option_values | REPEATED | RECORD |
| associations.product_option_values.id | NULLABLE | STRING |
| associations.images | REPEATED | RECORD |
| associations.images.id | NULLABLE | STRING |
Data schema for prestashop_countries
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_zone | NULLABLE | STRING |
| id_currency | NULLABLE | STRING |
| call_prefix | NULLABLE | STRING |
| iso_code | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| contains_states | NULLABLE | BOOLEAN |
| need_identification_number | NULLABLE | BOOLEAN |
| need_zip_code | NULLABLE | BOOLEAN |
| zip_code_format | NULLABLE | STRING |
| display_tax_label | NULLABLE | BOOLEAN |
| name | NULLABLE | JSON |
Data schema for prestashop_currencies
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| names | NULLABLE | JSON |
| name | NULLABLE | STRING |
| symbol | NULLABLE | JSON |
| iso_code | NULLABLE | STRING |
| numeric_iso_code | NULLABLE | STRING |
| precision | NULLABLE | FLOAT |
| conversion_rate | NULLABLE | FLOAT |
| deleted | NULLABLE | BOOLEAN |
| active | NULLABLE | BOOLEAN |
| unofficial | NULLABLE | STRING |
| modified | NULLABLE | BOOLEAN |
| pattern | NULLABLE | JSON |
Data schema for prestashop_customers
| Field Name | Mode | Type |
|---|---|---|
| id | REQUIRED | STRING |
| id_default_group | NULLABLE | STRING |
| id_lang | NULLABLE | STRING |
| newsletter_date_add | NULLABLE | STRING |
| ip_registration_newsletter | NULLABLE | STRING |
| secure_key | NULLABLE | STRING |
| deleted | NULLABLE | BOOLEAN |
| lastname | NULLABLE | STRING |
| firstname | NULLABLE | STRING |
| NULLABLE | STRING | |
| id_gender | NULLABLE | STRING |
| birthday | NULLABLE | STRING |
| newsletter | NULLABLE | BOOLEAN |
| optin | NULLABLE | BOOLEAN |
| website | NULLABLE | STRING |
| company | NULLABLE | STRING |
| siret | NULLABLE | STRING |
| ape | NULLABLE | STRING |
| outstanding_allow_amount | NULLABLE | FLOAT |
| show_public_prices | NULLABLE | BOOLEAN |
| id_risk | NULLABLE | STRING |
| max_payment_days | NULLABLE | INTEGER |
| active | NULLABLE | BOOLEAN |
| note | NULLABLE | STRING |
| is_guest | NULLABLE | BOOLEAN |
| id_shop | NULLABLE | STRING |
| id_shop_group | NULLABLE | STRING |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| associations | NULLABLE | RECORD |
| associations.groups | REPEATED | RECORD |
| associations.groups.id | NULLABLE | STRING |
Data schema for prestashop_manufacturers
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | INTEGER |
| active | NULLABLE | BOOLEAN |
| link_rewrite | NULLABLE | STRING |
| name | NULLABLE | STRING |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| description | NULLABLE | JSON |
| short_description | NULLABLE | JSON |
| meta_title | NULLABLE | JSON |
| meta_description | NULLABLE | JSON |
| meta_keywords | NULLABLE | JSON |
Data schema for prestashop_order_cart_rules
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_order | NULLABLE | STRING |
| id_cart_rule | NULLABLE | STRING |
| id_order_invoice | NULLABLE | STRING |
| name | NULLABLE | STRING |
| value | NULLABLE | FLOAT |
| value_tax_excl | NULLABLE | FLOAT |
| free_shipping | NULLABLE | BOOLEAN |
Data schema for prestashop_order_details
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_order | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| product_attribute_id | NULLABLE | STRING |
| product_quantity_reinjected | NULLABLE | STRING |
| group_reduction | NULLABLE | FLOAT |
| discount_quantity_applied | NULLABLE | STRING |
| download_hash | NULLABLE | STRING |
| download_deadline | NULLABLE | STRING |
| id_order_invoice | NULLABLE | STRING |
| id_warehouse | NULLABLE | STRING |
| id_shop | NULLABLE | STRING |
| id_customization | NULLABLE | STRING |
| product_name | NULLABLE | STRING |
| product_quantity | NULLABLE | STRING |
| product_quantity_in_stock | NULLABLE | STRING |
| product_quantity_return | NULLABLE | STRING |
| product_quantity_refunded | NULLABLE | STRING |
| product_price | NULLABLE | FLOAT |
| reduction_percent | NULLABLE | FLOAT |
| reduction_amount | NULLABLE | FLOAT |
| reduction_amount_tax_incl | NULLABLE | FLOAT |
| reduction_amount_tax_excl | NULLABLE | FLOAT |
| product_quantity_discount | NULLABLE | FLOAT |
| product_ean13 | NULLABLE | STRING |
| product_isbn | NULLABLE | STRING |
| product_upc | NULLABLE | STRING |
| product_mpn | NULLABLE | STRING |
| product_reference | NULLABLE | STRING |
| product_supplier_reference | NULLABLE | STRING |
| product_weight | NULLABLE | FLOAT |
| tax_computation_method | NULLABLE | STRING |
| id_tax_rules_group | NULLABLE | STRING |
| ecotax | NULLABLE | FLOAT |
| ecotax_tax_rate | NULLABLE | FLOAT |
| download_nb | NULLABLE | STRING |
| unit_price_tax_incl | NULLABLE | FLOAT |
| unit_price_tax_excl | NULLABLE | FLOAT |
| total_price_tax_incl | NULLABLE | FLOAT |
| total_price_tax_excl | NULLABLE | FLOAT |
| total_shipping_price_tax_excl | NULLABLE | FLOAT |
| total_shipping_price_tax_incl | NULLABLE | FLOAT |
| purchase_supplier_price | NULLABLE | FLOAT |
| original_product_price | NULLABLE | FLOAT |
| original_wholesale_price | NULLABLE | FLOAT |
| total_refunded_tax_excl | NULLABLE | FLOAT |
| total_refunded_tax_incl | NULLABLE | FLOAT |
| associations | NULLABLE | RECORD |
| associations.taxes | REPEATED | RECORD |
| associations.taxes.id | NULLABLE | STRING |
Data schema for prestashop_order_states
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| unremovable | NULLABLE | STRING |
| delivery | NULLABLE | STRING |
| hidden | NULLABLE | BOOLEAN |
| send_email | NULLABLE | BOOLEAN |
| module_name | NULLABLE | STRING |
| invoice | NULLABLE | BOOLEAN |
| color | NULLABLE | STRING |
| logable | NULLABLE | BOOLEAN |
| shipped | NULLABLE | BOOLEAN |
| paid | NULLABLE | BOOLEAN |
| pdf_delivery | NULLABLE | BOOLEAN |
| pdf_invoice | NULLABLE | BOOLEAN |
| deleted | NULLABLE | BOOLEAN |
| name | NULLABLE | JSON |
| template | NULLABLE | JSON |
Data schema for prestashop_orders
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_address_delivery | NULLABLE | STRING |
| id_address_invoice | NULLABLE | STRING |
| id_cart | NULLABLE | STRING |
| id_currency | NULLABLE | STRING |
| id_lang | NULLABLE | STRING |
| id_customer | NULLABLE | STRING |
| id_carrier | NULLABLE | STRING |
| current_state | NULLABLE | STRING |
| module | NULLABLE | STRING |
| invoice_number | NULLABLE | STRING |
| invoice_date | NULLABLE | STRING |
| delivery_number | NULLABLE | STRING |
| delivery_date | NULLABLE | STRING |
| valid | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| shipping_number | NULLABLE | STRING |
| note | NULLABLE | STRING |
| id_shop_group | NULLABLE | STRING |
| id_shop | NULLABLE | STRING |
| secure_key | NULLABLE | STRING |
| payment | NULLABLE | STRING |
| recyclable | NULLABLE | BOOLEAN |
| gift | NULLABLE | BOOLEAN |
| gift_message | NULLABLE | STRING |
| mobile_theme | NULLABLE | BOOLEAN |
| total_discounts | NULLABLE | FLOAT |
| total_discounts_tax_incl | NULLABLE | FLOAT |
| total_discounts_tax_excl | NULLABLE | FLOAT |
| total_paid | NULLABLE | FLOAT |
| total_paid_tax_incl | NULLABLE | FLOAT |
| total_paid_tax_excl | NULLABLE | FLOAT |
| total_paid_real | NULLABLE | FLOAT |
| total_products | NULLABLE | FLOAT |
| total_products_wt | NULLABLE | FLOAT |
| total_shipping | NULLABLE | FLOAT |
| total_shipping_tax_incl | NULLABLE | FLOAT |
| total_shipping_tax_excl | NULLABLE | FLOAT |
| carrier_tax_rate | NULLABLE | FLOAT |
| total_wrapping | NULLABLE | FLOAT |
| total_wrapping_tax_incl | NULLABLE | FLOAT |
| total_wrapping_tax_excl | NULLABLE | FLOAT |
| round_mode | NULLABLE | STRING |
| round_type | NULLABLE | STRING |
| conversion_rate | NULLABLE | FLOAT |
| reference | NULLABLE | STRING |
| associations | NULLABLE | RECORD |
| associations.order_rows | REPEATED | RECORD |
| associations.order_rows.id | NULLABLE | STRING |
| associations.order_rows.product_id | NULLABLE | STRING |
| associations.order_rows.product_attribute_id | NULLABLE | STRING |
| associations.order_rows.product_quantity | NULLABLE | STRING |
| associations.order_rows.product_name | NULLABLE | STRING |
| associations.order_rows.product_reference | NULLABLE | STRING |
| associations.order_rows.product_ean13 | NULLABLE | STRING |
| associations.order_rows.product_isbn | NULLABLE | STRING |
| associations.order_rows.product_upc | NULLABLE | STRING |
| associations.order_rows.product_price | NULLABLE | STRING |
| associations.order_rows.id_customization | NULLABLE | STRING |
| associations.order_rows.unit_price_tax_incl | NULLABLE | STRING |
| associations.order_rows.unit_price_tax_excl | NULLABLE | STRING |
Data schema for prestashop_product_option_values
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_attribute_group | NULLABLE | STRING |
| color | NULLABLE | STRING |
| position | NULLABLE | STRING |
| name | NULLABLE | JSON |
Data schema for prestashop_product_options
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| is_color_group | NULLABLE | BOOLEAN |
| group_type | NULLABLE | STRING |
| position | NULLABLE | STRING |
| name | NULLABLE | JSON |
| public_name | NULLABLE | JSON |
| associations | NULLABLE | RECORD |
| associations.product_option_values | REPEATED | RECORD |
| associations.product_option_values.id | NULLABLE | STRING |
Data schema for prestashop_products
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_manufacturer | NULLABLE | STRING |
| id_supplier | NULLABLE | STRING |
| id_category_default | NULLABLE | STRING |
| new | NULLABLE | STRING |
| cache_default_attribute | NULLABLE | STRING |
| id_default_image | NULLABLE | STRING |
| id_default_combination | NULLABLE | STRING |
| id_tax_rules_group | NULLABLE | STRING |
| position_in_category | NULLABLE | STRING |
| type | NULLABLE | STRING |
| id_shop_default | NULLABLE | STRING |
| reference | NULLABLE | STRING |
| supplier_reference | NULLABLE | STRING |
| location | NULLABLE | STRING |
| width | NULLABLE | FLOAT |
| height | NULLABLE | FLOAT |
| depth | NULLABLE | FLOAT |
| weight | NULLABLE | FLOAT |
| quantity_discount | NULLABLE | BOOLEAN |
| ean13 | NULLABLE | STRING |
| isbn | NULLABLE | STRING |
| upc | NULLABLE | STRING |
| mpn | NULLABLE | STRING |
| cache_is_pack | NULLABLE | BOOLEAN |
| cache_has_attachments | NULLABLE | BOOLEAN |
| is_virtual | NULLABLE | BOOLEAN |
| state | NULLABLE | STRING |
| additional_delivery_times | NULLABLE | STRING |
| delivery_in_stock | NULLABLE | JSON |
| delivery_out_stock | NULLABLE | JSON |
| product_type | NULLABLE | STRING |
| on_sale | NULLABLE | BOOLEAN |
| online_only | NULLABLE | BOOLEAN |
| ecotax | NULLABLE | FLOAT |
| minimal_quantity | NULLABLE | INTEGER |
| low_stock_threshold | NULLABLE | STRING |
| low_stock_alert | NULLABLE | BOOLEAN |
| price | NULLABLE | FLOAT |
| wholesale_price | NULLABLE | FLOAT |
| unity | NULLABLE | STRING |
| unit_price_ratio | NULLABLE | STRING |
| additional_shipping_cost | NULLABLE | FLOAT |
| customizable | NULLABLE | STRING |
| text_fields | NULLABLE | STRING |
| uploadable_files | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| redirect_type | NULLABLE | STRING |
| id_type_redirected | NULLABLE | STRING |
| available_for_order | NULLABLE | STRING |
| available_date | NULLABLE | STRING |
| show_condition | NULLABLE | BOOLEAN |
| condition | NULLABLE | STRING |
| show_price | NULLABLE | BOOLEAN |
| indexed | NULLABLE | BOOLEAN |
| visibility | NULLABLE | STRING |
| advanced_stock_management | NULLABLE | BOOLEAN |
| date_add | NULLABLE | DATETIME |
| date_upd | NULLABLE | DATETIME |
| pack_stock_type | NULLABLE | STRING |
| meta_description | NULLABLE | JSON |
| meta_keywords | NULLABLE | JSON |
| meta_title | NULLABLE | JSON |
| link_rewrite | NULLABLE | JSON |
| name | NULLABLE | JSON |
| description | NULLABLE | JSON |
| description_short | NULLABLE | JSON |
| available_now | NULLABLE | JSON |
| available_later | NULLABLE | JSON |
| associations | NULLABLE | RECORD |
| associations.categories | REPEATED | RECORD |
| associations.categories.id | NULLABLE | STRING |
| associations.images | REPEATED | RECORD |
| associations.images.id | NULLABLE | STRING |
| associations.combinations | REPEATED | RECORD |
| associations.combinations.id | NULLABLE | STRING |
| associations.product_option_values | REPEATED | RECORD |
| associations.product_option_values.id | NULLABLE | STRING |
| associations.product_features | REPEATED | RECORD |
| associations.product_features.id | NULLABLE | STRING |
| associations.product_features.id_feature_value | NULLABLE | STRING |
| associations.tags | REPEATED | RECORD |
| associations.tags.id | NULLABLE | STRING |
| associations.stock_availables | REPEATED | RECORD |
| associations.stock_availables.id | NULLABLE | STRING |
| associations.stock_availables.id_product_attribute | NULLABLE | STRING |
| associations.attachments | REPEATED | RECORD |
| associations.attachments.id | NULLABLE | STRING |
| associations.accessories | REPEATED | RECORD |
| associations.accessories.id | NULLABLE | STRING |
| associations.product_bundle | REPEATED | RECORD |
| associations.product_bundle.id | NULLABLE | STRING |
| associations.product_bundle.id_product_attribute | NULLABLE | STRING |
| associations.product_bundle.quantity | NULLABLE | INTEGER |
Data schema for prestashop_shop_urls
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_shop | NULLABLE | STRING |
| active | NULLABLE | BOOLEAN |
| main | NULLABLE | BOOLEAN |
| domain | NULLABLE | STRING |
| domain_ssl | NULLABLE | STRING |
| physical_uri | NULLABLE | STRING |
| virtual_uri | NULLABLE | STRING |
Data schema for prestashop_stock_availables
| Field Name | Mode | Type |
|---|---|---|
| id | REQUIRED | STRING |
| id_product | REQUIRED | STRING |
| id_product_attribute | NULLABLE | STRING |
| id_shop | REQUIRED | STRING |
| id_shop_group | REQUIRED | STRING |
| quantity | NULLABLE | INTEGER |
| depends_on_stock | NULLABLE | BOOLEAN |
| out_of_stock | NULLABLE | INTEGER |
| location | NULLABLE | STRING |
Data schema for prestashop_stocks
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| id_warehouse | NULLABLE | STRING |
| id_product | NULLABLE | STRING |
| id_product_attribute | NULLABLE | STRING |
| reference | NULLABLE | STRING |
| ean13 | NULLABLE | STRING |
| isbn | NULLABLE | STRING |
| upc | NULLABLE | STRING |
| mpn | NULLABLE | STRING |
| physical_quantity | NULLABLE | INTEGER |
| usable_quantity | NULLABLE | INTEGER |
| price_te | NULLABLE | FLOAT |
