Skip to content
Book a demoStart free
Connectors

PrestaShop connector

Set up the PrestaShop connector in Kaivo: authentication, configuration, the 56 BigQuery tables it syncs, and answers to common questions.

PrestaShop connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your PrestaShop data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your e-commerce data instead of moving it.

Sync your PrestaShop store data into BigQuery with Kaivo to analyse orders, products, and customers without exporting reports by hand.

CategoryE-commerce
AuthenticationAPI key
SetupSelf-service

Getting started with the PrestaShop connector

Section titled “Getting started with the PrestaShop connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your PrestaShop account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Access Key.

Field Description
Access Key
Your PrestaShop access key. See the docs for info on how to obtain this.

|

When you set up the connector, you provide:

Field Description
Shop URL
Shop URL without trailing slash.

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 56 tables from PrestaShop into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

addresses (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address1 STRING First line of the address.
address2 STRING Second line of the address (if applicable).
alias STRING An alias for the address for easy identification.
city STRING City of the address.
company STRING Company name associated with the address.
date_add TIMESTAMP Date when the address was added.
date_upd TIMESTAMP Date when the address was last updated.
deleted STRING Flag indicating if the address is deleted or not.
dni STRING DNI (Documento Nacional de Identidad) number associated with the address.
… and 15 more columns
carriers (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the carrier is active or not
delay STRING Estimated delivery time delay for this carrier
deleted STRING Indicates if the carrier is deleted or not
external_module_name STRING Name of the external module used by the carrier
grade STRING Grade of the carrier based on its performance
id INT64 Unique identifier for the carrier
id_reference STRING Reference identifier for the carrier
id_tax_rules_group STRING ID of the tax rules group applied to this carrier
is_free STRING Indicates if the carrier is free for shipping or not
… and 14 more columns
cart_rules (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING A brief description of the cart rule and its conditions.
active STRING Indicates whether the cart rule is currently active.
carrier_restriction STRING IDs of carriers the cart rule is restricted to.
cart_rule_restriction STRING IDs of other cart rules that are restricted in conjunction with this rule.
code STRING The unique code that customers can apply at checkout to trigger the discount.
country_restriction STRING ISO country codes for countries the cart rule is applicable to.
date_add TIMESTAMP The date and time when the cart rule was created.
date_from TIMESTAMP The start date and time when the cart rule becomes active.
date_to TIMESTAMP The end date and time when the cart rule expires.
… and 26 more columns
carts (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
allow_seperated_package STRING Indicates if the cart allows separated packaging for items
date_add TIMESTAMP Date and time when the cart was created
date_upd TIMESTAMP Date and time when the cart was last updated
delivery_option STRING Selected delivery options for the cart
gift STRING Indicates if the cart includes a gift
gift_message STRING Message associated with the gift included in the cart
id INT64 Unique identifier for the cart
id_address_delivery STRING ID of the delivery address for the cart
id_address_invoice STRING ID of the invoice address for the cart
… and 11 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • carts__associations__cart_rows (8 columns)
categories (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING A brief description of the category.
active STRING Indicates whether the category is active or not.
date_add TIMESTAMP The date and time when the category was added.
date_upd TIMESTAMP The date and time when the category was last updated.
id INT64 The unique identifier for the category.
id_parent STRING The identifier of the parent category.
id_shop_default STRING The default shop identifier for the category.
is_root_category STRING Indicates whether the category is a root category.
level_depth STRING The level depth of the category in the category tree.
… and 8 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • categories__associations__categories (4 columns)
combinations (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
available_date DATE Date when this combination is available
default_on STRING Indicates if this combination is set as default
ean13 STRING EAN-13 barcode for this combination
ecotax STRING Ecotax value for this combination
id INT64 ID of this combination
id_product STRING ID of the product this combination belongs to
isbn STRING ISBN code for this combination
location STRING Location of this combination in the warehouse
low_stock_alert STRING Threshold quantity for low stock alert
… and 12 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • combinations__associations__images (4 columns)
  • combinations__associations__product_option_values (4 columns)
configurations (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date when the configuration data was created.
date_upd TIMESTAMP The date when the configuration data was last updated.
id INT64 The unique identifier for the configuration data.
id_shop STRING The identifier of the shop associated with the configuration data.
id_shop_group STRING The identifier of the shop group associated with the configuration data.
name STRING The name or key of the configuration parameter.
value STRING The value of the configuration parameter.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING A brief description of the contact or contact group.
customer_service STRING The contact information for customer service representative.
email STRING The email address of the contact.
id INT64 The unique identifier for the contact.
name STRING The name of the contact or contact group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
content_management_system (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the content management system data is active or not.
content STRING The actual content of the CMS data.
head_seo_title STRING The SEO title used for head tags.
id INT64 The unique identifier for the CMS data.
id_cms_category STRING The identifier for the category to which the CMS data belongs.
indexation STRING Indicates if the CMS data is set for indexation or not.
link_rewrite STRING The URL-friendly version of the CMS data’s title.
meta_description STRING The meta description used for SEO purposes.
meta_keywords STRING The meta keywords used in SEO.
… and 3 more columns
countries (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the country is currently active or not.
call_prefix STRING The call prefix or telephone code used to make calls to this country.
contains_states STRING Specifies if the country contains states or regions within its territory.
display_tax_label STRING Denotes whether the tax label is displayed for this country.
id INT64 Unique identifier for the country.
id_currency STRING Identifier for the currency used in this country.
id_zone STRING Identifier for the geographical zone or region to which the country belongs.
iso_code STRING The ISO code representing the country.
name STRING The name of the country.
… and 4 more columns
currencies (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the currency is currently active or not.
conversion_rate STRING The conversion rate of the currency compared to the default currency.
deleted STRING Flag to indicate if the currency has been deleted.
id INT64 Unique identifier for the currency.
iso_code STRING The ISO code representing the currency.
modified STRING Timestamp of the last modification of the currency.
name STRING Name of the currency.
names STRING Object containing the names of the currency in different languages.
numeric_iso_code STRING The numeric ISO code representing the currency.
… and 5 more columns
customer_messages (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the message was added
date_upd TIMESTAMP The date and time when the message was last updated
file_name STRING The name of the file attached to the message
id INT64 The unique identifier for the customer message
id_customer_thread STRING The identifier of the customer thread this message belongs to
id_employee STRING The identifier of the employee who sent the message
ip_address STRING The IP address from which the message was sent
message STRING The content of the message
private STRING Indicates if the message is private (e.g., only visible to specific users)
… and 3 more columns
customer_threads (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP Date and time when the customer thread was created
date_upd TIMESTAMP Date and time when the customer thread was last updated
email STRING Email address associated with the customer thread
id INT64 Unique identifier for each customer thread
id_contact STRING Identifier of the contact associated with the customer thread
id_customer STRING Identifier of the customer associated with the customer thread
id_lang STRING Identifier of the language used in the customer thread
id_order STRING Identifier of the order related to the customer thread
id_product STRING Identifier of the product related to the customer thread
… and 4 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • customer_threads__associations__customer_messages (4 columns)
customers (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the customer account is active or not
ape STRING APE code for the customer
birthday STRING Customer’s date of birth
company STRING Customer’s company name
date_add TIMESTAMP Date and time when the customer account was created
date_upd TIMESTAMP Date and time of the last update to the customer account
deleted STRING Indicates if the customer account has been deleted
email STRING Customer’s email address
firstname STRING Customer’s first name
… and 25 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • customers__associations__groups (4 columns)
deliveries (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the delivery
id_carrier STRING Identifier of the carrier associated with the delivery
id_range_price STRING Identifier for the price range that applies to the delivery
id_range_weight STRING Identifier for the weight range that applies to the delivery
id_shop STRING Identifier of the shop to which the delivery belongs
id_shop_group STRING Identifier of the shop group to which the delivery belongs
id_zone STRING Identifier for the geographical zone to which the delivery applies
price STRING The price associated with the delivery
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
employees (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the employee is active
bo_color STRING Color setting for back office interface
bo_css STRING Custom CSS for back office styling
bo_menu STRING Menu configuration for back office
bo_theme STRING Theme setting for back office
bo_width STRING Width configuration for back office layout
default_tab STRING Default tab displayed in back office upon login
email STRING Email address of the employee
firstname STRING First name of the employee
… and 18 more columns
groups (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the group was created.
date_upd TIMESTAMP The date and time when the group was last updated.
id INT64 The unique identifier for the group.
name STRING The name of the group.
price_display_method STRING The method used to display prices for the group.
reduction STRING The reduction value applied to the group.
show_prices STRING Flag indicating if prices should be shown for the group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
guests (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accept_language STRING The language preferences of the guest user
adobe_director STRING Whether the guest user has Adobe Director installed
adobe_flash STRING Whether the guest user has Adobe Flash installed
apple_quicktime STRING Whether the guest user has Apple QuickTime installed
id INT64 Unique identifier for the guest data entry
id_customer STRING Unique identifier of the customer associated with the guest data
id_operating_system STRING Identifier for the operating system of the guest user
id_web_browser STRING Identifier for the web browser of the guest user
javascript STRING Whether the guest user has JavaScript enabled
… and 8 more columns
image_types (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
categories STRING List of categories associated with the image type.
height STRING Height dimension of the image type.
id INT64 Unique identifier for the image type.
manufacturers STRING List of manufacturers associated with the image type.
name STRING Name of the image type.
products STRING List of products associated with the image type.
stores STRING List of stores associated with the image type.
suppliers STRING List of suppliers associated with the image type.
width STRING Width dimension of the image type.
… and 1 more columns
languages (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the language is currently active or not (true/false).
date_format_full STRING The full format for displaying dates in this language.
date_format_lite STRING The lite format for displaying dates in this language.
id INT64 The unique identifier for the language.
is_rtl STRING Indicates if the language is written from right to left (true/false).
iso_code STRING The ISO code for the language.
language_code STRING The language code to identify the language.
locale STRING The locale setting for the language.
name STRING The name of the language.
… and 1 more columns
manufacturers (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING The detailed description of the manufacturer.
active STRING Specifies if the manufacturer is active or not.
date_add TIMESTAMP The date and time when the manufacturer was added.
date_upd TIMESTAMP The date and time when the manufacturer was last updated.
id INT64 Unique identifier for the manufacturer.
link_rewrite STRING The SEO-friendly URL slug for the manufacturer.
meta_description STRING The meta description for the manufacturer.
meta_keywords STRING The meta keywords for the manufacturer.
meta_title STRING The meta title for the manufacturer.
… and 3 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • manufacturers__associations__addresses (4 columns)
messages (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the message was added.
id INT64 The unique identifier of the message.
id_cart STRING The ID of the cart associated with the message.
id_customer STRING The ID of the customer who sent the message.
id_employee STRING The ID of the employee who received the message.
id_order STRING The ID of the order related to the message.
message STRING The content of the message.
private STRING Indicates if the message is private or not.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
order_carriers (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the carrier information was added
id INT64 The unique identifier for the order carrier
id_carrier STRING The identifier for the carrier associated with the order
id_order STRING The identifier for the order associated with the carrier
id_order_invoice STRING The identifier for the order invoice
shipping_cost_tax_excl STRING The shipping cost excluding tax
shipping_cost_tax_incl STRING The shipping cost including tax
tracking_number STRING The tracking number for the shipment
weight STRING The weight of the shipment
… and 1 more columns
order_details (49 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
discount_quantity_applied STRING The quantity of discount applied to this product
download_deadline STRING The deadline for downloading the product
download_hash STRING The hash value for downloading the product
download_nb STRING The number of downloads allowed for the product
ecotax STRING The ecological tax amount for the product
ecotax_tax_rate STRING The tax rate applied to the ecological tax
group_reduction STRING The group reduction amount for the product
id INT64 The unique identifier for the order detail
id_customization STRING The customization ID associated with the product
… and 39 more columns
order_histories (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the order history entry was added.
id INT64 The unique identifier for the order history entry.
id_employee STRING The identifier of the employee who made the order history entry.
id_order STRING The unique identifier of the associated order.
id_order_state STRING The identifier of the order state for this order history entry.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
order_invoices (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the invoice was created.
delivery_date STRING The expected delivery date for the order associated with this invoice.
delivery_number STRING The delivery number related to this invoice.
id INT64 The unique identifier for this invoice.
id_order STRING The id of the order associated with this invoice.
note STRING Additional notes or comments related to the invoice.
number STRING The unique invoice number.
shipping_tax_computation_method STRING The method used to compute shipping tax for this invoice.
shop_address STRING The address of the shop from which the order was placed.
… and 11 more columns
order_payments (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount STRING The total amount of the payment
card_brand STRING The brand of the credit card used for the payment
card_expiration STRING The expiration date of the credit card used for the payment
card_holder STRING The name of the cardholder
card_number STRING The masked credit card number
conversion_rate STRING The currency conversion rate used for the payment
date_add TIMESTAMP The date and time when the payment was added
id INT64 The unique identifier of the payment
id_currency STRING The currency ID used for the payment
… and 4 more columns
order_slip (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount STRING The total amount for the order slip
conversion_rate STRING The conversion rate used for currency conversion
date_add TIMESTAMP The date and time when the order slip was created
date_upd TIMESTAMP The date and time when the order slip was last updated
id INT64 The unique identifier for the order slip
id_customer STRING The ID of the customer associated with this order slip
id_order STRING The ID of the order related to this order slip
order_slip_type STRING The type of order slip (e.g., refund, credit note)
partial STRING Indicates if the order slip is for a partial refund or credit
… and 7 more columns
order_states (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
color STRING The color associated with the order state for visual identification.
deleted STRING Indicates if the order state has been deleted.
delivery STRING Indicates if the order has been delivered.
hidden STRING Indicates if the order state is hidden from users.
id INT64 The unique identifier for the order state.
invoice STRING Indicates if the order has been invoiced.
logable STRING Indicates if the order state allows logging.
module_name STRING The name of the module associated with the order state.
name STRING The name or label of the order state.
… and 8 more columns
orders (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
carrier_tax_rate STRING Tax rate applied to the carrier service
conversion_rate STRING Currency conversion rate at the time of the order
current_state STRING Current status/state of the order
date_add TIMESTAMP Date and time when the order was added
date_upd TIMESTAMP Date and time when the order was last updated
delivery_date STRING Expected delivery date of the order
delivery_number STRING Delivery number associated with the order
gift STRING Flag indicating if the order is a gift
gift_message STRING Message included with the gift order
… and 38 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • orders__associations__order_rows (16 columns)
price_ranges (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
delimiter1 STRING The first delimiter for the price range data
delimiter2 STRING The second delimiter for the price range data
id INT64 The unique identifier for the price range data
id_carrier STRING The unique identifier for the carrier associated with the price range
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_customization_fields (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING The type of customization field such as text, image, file, etc.
id INT64 The unique identifier for the product customization field.
id_product STRING The ID of the product to which this customization field is associated.
is_deleted STRING A flag indicating whether the customization field has been deleted.
is_module STRING A flag indicating whether the customization field is a module or not.
name STRING The name or label of the customization field.
required STRING A flag indicating whether this customization field is required for the product.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_feature_values (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
custom STRING Any custom data related to the product feature value.
id INT64 The unique identifier for the product feature value.
id_feature STRING The identifier of the feature associated with the product.
value STRING The actual value of the product feature.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_features (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier of the product feature.
name STRING The name of the product feature.
position STRING The position of the product feature in the list of features.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_option_values (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
color STRING The color of the product option value.
id INT64 The unique identifier of the product option value.
id_attribute_group STRING The identifier of the attribute group to which the product option value belongs.
name STRING The name or label of the product option value.
position STRING The position or order of the product option value in the list of values.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_options (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
group_type STRING Type or category of the product option group
id INT64 Unique identifier for the product option
is_color_group STRING Indicates if the product option group represents colors
name STRING Name of the product option group
position STRING Position of the product option group in the list
public_name STRING Publicly visible name of the product option group
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • product_options__associations__product_option_values (4 columns)
product_suppliers (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the product supplier entry.
id_currency STRING Unique identifier for the currency used in pricing.
id_product STRING Unique identifier for the product associated with the supplier.
id_product_attribute STRING Identifier for the product attribute if applicable.
id_supplier STRING Unique identifier for the supplier of the product.
product_supplier_price_te STRING Price at which the supplier offers the product, excluding taxes.
product_supplier_reference STRING Unique reference code for the product used by the supplier.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (72 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING The type of the product.
description STRING The description of the product.
active STRING Indicates if the product is active or not.
additional_delivery_times STRING Additional delivery times for the product.
additional_shipping_cost STRING Additional shipping cost associated with the product.
advanced_stock_management STRING Indicates if advanced stock management is enabled for the product.
available_date STRING The date when the product is available.
available_for_order STRING Indicates if the product is available for order.
available_later STRING Information about availability later.
… and 62 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • products__associations__categories (4 columns)
  • products__associations__images (4 columns)
  • products__associations__stock_availables (5 columns)
shop_groups (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates whether the shop group is active or not.
deleted STRING Indicates whether the shop group has been deleted.
id INT64 The unique identifier for the shop group.
name STRING The name of the shop group.
share_customer STRING Indicates if customers are shared among shops within this group.
share_order STRING Indicates if orders are shared among shops within this group.
share_stock STRING Indicates if stock information is shared among shops within this group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shop_urls (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the shop URL is active or not
domain STRING The domain name of the shop
domain_ssl STRING The SSL domain name of the shop
id INT64 The unique identifier of the shop URL
id_shop STRING The shop ID associated with the URL
main STRING Indicates if this is the main shop URL
physical_uri STRING The physical URI path of the shop
virtual_uri STRING The virtual URI path of the shop
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shops (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the shop is active or not.
deleted STRING Indicates if the shop has been deleted.
id INT64 The unique identifier for the shop.
id_category STRING The category ID that the shop belongs to.
id_shop_group STRING The shop group ID the shop is associated with.
name STRING The name of the shop.
theme_name STRING The name of the theme used by the shop.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
specific_price_rules (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
from STRING Start date/time of the specific price rule
from_quantity STRING Minimum quantity required for the specific price rule to apply
id INT64 Unique identifier of the specific price rule
id_country STRING ID of the country to which the specific price rule is applicable
id_currency STRING ID of the currency in which the prices are defined
id_group STRING ID of the customer group to which the specific price rule applies
id_shop STRING ID of the shop to which the specific price rule is associated
name STRING Name or title of the specific price rule
price STRING Original price before the reduction is applied
… and 5 more columns
specific_prices (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
from STRING The start date and time for the specific price to be applied.
from_quantity STRING The minimum quantity of the product for the specific price to be applied.
id INT64 The unique identifier for the specific price entry.
id_cart STRING The cart ID to which the specific price applies.
id_country STRING The country ID for which the specific price is applicable.
id_currency STRING The currency ID in which the price is defined.
id_customer STRING The customer ID for whom the specific price is valid.
id_group STRING The customer group ID for which the specific price is set.
id_product STRING The product ID to which the specific price applies.
… and 10 more columns
states (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Specifies if the state is active (true) or inactive (false)
id INT64 The unique identifier for the state
id_country STRING The ID of the country to which the state belongs
id_zone STRING The ID of the geographic zone to which the state belongs
iso_code STRING The ISO code representing the state
name STRING The name of the state
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stock_availables (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
depends_on_stock STRING Indicates if the stock is dependent on the main product stock
id INT64 Unique identifier for the stock availability record
id_product STRING Identifier of the product associated with the stock availability
id_product_attribute STRING Identifier of the product attribute associated with the stock availability
id_shop STRING Identifier of the shop where the stock availability applies
id_shop_group STRING Identifier of the shop group where the stock availability applies
location STRING Location of the stock within the store or warehouse
out_of_stock STRING Indicates if the product is currently out of stock
quantity STRING The quantity of the product available in stock
… and 1 more columns
stock_movement_reasons (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the stock movement reason was added
date_upd TIMESTAMP The date and time when the stock movement reason was last updated
deleted STRING Indicates if the stock movement reason has been deleted
id INT64 The unique identifier of the stock movement reason
name STRING The name of the stock movement reason
sign STRING The sign associated with the stock movement reason (e.g., positive or negative)
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stock_movements (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
current_wa STRING Current weighted average cost of the product
date_add TIMESTAMP Date and time of the stock movement
ean13 STRING EAN-13 barcode for the product
id INT64 Unique identifier for the stock movement record
id_currency STRING Currency ID used for the transaction
id_employee STRING Employee ID responsible for the stock movement
id_order STRING Order ID associated with the stock movement
id_product STRING Product ID related to the stock movement
id_product_attribute STRING Product attribute ID if any
… and 14 more columns
stores (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the store is currently active or not.
address1 STRING First line of the store’s address.
address2 STRING Second line of the store’s address.
city STRING City where the store is located.
date_add TIMESTAMP Date and time when the store was added.
date_upd TIMESTAMP Date and time when the store was last updated.
email STRING Email address of the store contact.
fax STRING Fax number of the store.
hours STRING Operating hours of the store.
… and 10 more columns
suppliers (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING A brief description of the supplier
active STRING Whether the supplier is currently active or not
date_add TIMESTAMP The date and time when the supplier was added
date_upd TIMESTAMP The date and time when the supplier’s information was last updated
id INT64 The unique identifier of the supplier
link_rewrite STRING The SEO-friendly URL of the supplier
meta_description STRING The meta description for the supplier
meta_keywords STRING The meta keywords associated with the supplier
meta_title STRING The meta title for the supplier
… and 2 more columns
tags (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier of the tag
id_lang STRING The identifier for the language associated with the tag
name STRING The name of the tag
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tax_rule_groups (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the tax rule group is currently active or not.
date_add TIMESTAMP The date and time when the tax rule group was added.
date_upd TIMESTAMP The date and time when the tax rule group was last updated.
deleted STRING Indicates if the tax rule group has been marked as deleted or not.
id INT64 The unique identifier for the tax rule group.
name STRING The name of the tax rule group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tax_rules (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING A description of the tax rule for reference.
behavior STRING The behavior of the tax rule, indicating how it is applied (e.g., ‘order’ or ‘shipping’).
id INT64 The unique identifier for the tax rule.
id_country STRING The ID of the country to which the tax rule applies.
id_state STRING The ID of the state or region to which the tax rule applies.
id_tax STRING The ID of the tax rate applied by the tax rule.
id_tax_rules_group STRING The ID of the tax rule group to which the tax rule belongs.
zipcode_from STRING The starting ZIP code range for the tax rule.
zipcode_to STRING The ending ZIP code range for the tax rule.
… and 1 more columns
taxes (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates if the tax is currently active or not.
deleted STRING Indicates if the tax has been soft-deleted or not.
id INT64 Unique identifier for the tax.
name STRING Name of the tax.
rate STRING Tax rate percentage for calculations.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
translated_configurations (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_add TIMESTAMP The date and time when the configuration was created.
date_upd TIMESTAMP The date and time when the configuration was last updated.
id INT64 The unique identifier for the translated configuration entry.
id_shop STRING The ID of the shop associated with this translated configuration.
id_shop_group STRING The ID of the shop group to which the translated configuration belongs.
name STRING The name of the configuration entry.
value STRING The value assigned to the configuration entry.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
weight_ranges (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
delimiter1 STRING The lower weight limit in this weight range.
delimiter2 STRING The upper weight limit in this weight range.
id INT64 The unique identifier for the weight range.
id_carrier STRING The ID of the carrier associated with this weight range.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
zones (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active STRING Indicates whether the zone is currently active or not.
id INT64 The unique identifier for the zone.
name STRING The name of the zone.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where PrestaShop supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for PrestaShop?

Section titled “How long does the initial sync take for PrestaShop?”

It depends on how much history is in your PrestaShop account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when PrestaShop’s schema changes?

Section titled “What happens when PrestaShop’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in PrestaShop, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in PrestaShop instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the PrestaShop connector in Kaivo and all of its synced data is deleted with it.

Combine orders, order_details, and order_histories to track revenue and order status over time.

Join order_details with categories to see best sellers and margin by category.

Use customers and customer_threads to measure repeat purchases and support volume.

Bring products, combinations, and manufacturers together to understand your catalogue.

Use PrestaShop data in your AI and BI tools

Section titled “Use PrestaShop data in your AI and BI tools”

Once PrestaShop data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with PrestaShop data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for PrestaShop connector pricing and plan details.