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.
| Category | E-commerce |
|---|
| Authentication | API key |
|---|
| Setup | Self-service |
|---|
- Sign up for Kaivo and create a workspace.
- Connect your PrestaShop account.
- Choose which tables to sync.
- Wait for the initial sync to finish.
- 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.
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.
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.
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.
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.