Adobe Commerce connector

Kaivo is a fully managed data platform that syncs your Adobe Commerce 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.

What is the Adobe Commerce connector

Sync your Adobe Commerce (Magento) 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

Getting started with the Adobe Commerce connector

1. Sign up for Kaivo and create a workspace.
2. Connect your Adobe Commerce 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.

Authenticating Adobe Commerce

Authenticate with your Integration Access Token.

Field	Description
Integration Access Token
Your Adobe Commerce integration access token.

|

Configuring the Adobe Commerce connector

When you set up the connector, you provide:

Field	Description
Start Date
Any data before this date will not be fetched.

| | Store Host |

Your Magento store hostname, e.g. magento.mystore.com.

|

Tables and columns synced from Adobe Commerce

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

carts (55 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
currency__base_currency_code	STRING
currency__base_to_quote_rate	FLOAT64
currency__store_to_base_rate	FLOAT64
currency__base_to_global_rate	FLOAT64
currency__quote_currency_code	STRING
currency__store_currency_code	STRING
currency__store_to_quote_rate	FLOAT64
currency__global_currency_code	STRING
customer__id	FLOAT64
customer__dob	STRING
customer__email	STRING
customer__gender	FLOAT64
customer__group_id	FLOAT64
customer__lastname	STRING
customer__store_id	FLOAT64
customer__firstname	STRING
customer__created_at	STRING
customer__created_in	STRING
customer__updated_at	STRING
customer__website_id	FLOAT64
customer__default_billing	STRING
customer__default_shipping	STRING
customer__extension_attributes__is_subscribed	BOOL
customer__extension_attributes__assistance_allowed	FLOAT64
customer__disable_auto_group_change	FLOAT64
store_id	FLOAT64
is_active	BOOL
items_qty	FLOAT64
created_at	STRING
is_virtual	BOOL
updated_at	STRING
items_count	FLOAT64
orig_order_id	FLOAT64
billing_address__id	FLOAT64
billing_address__city	STRING
billing_address__email	STRING
billing_address__region	STRING
billing_address__lastname	STRING
billing_address__postcode	STRING
billing_address__firstname	STRING
billing_address__region_id	FLOAT64
billing_address__telephone	STRING
billing_address__country_id	STRING
billing_address__customer_id	FLOAT64
billing_address__region_code	STRING
billing_address__same_as_billing	FLOAT64
billing_address__save_in_address_book	FLOAT64
customer_is_guest	BOOL
reserved_order_id	STRING
customer_note_notify	BOOL
extension_attributes__kl_masked_id	STRING
customer_tax_class_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• carts__items (10 columns)
• carts__customer__addresses (4 columns)
• carts__customer__custom_attributes (5 columns)
• carts__billing_address__street (4 columns)
• carts__extension_attributes__shipping_assignments (4 columns)

coupons (12 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	FLOAT64
code	STRING
rule_id	FLOAT64
coupon_id	FLOAT64
created_at	STRING
is_primary	BOOL
times_used	FLOAT64
usage_limit	FLOAT64
expiration_date	STRING
usage_per_customer	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

creditmemos (46 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
state	FLOAT64
order_id	FLOAT64
store_id	FLOAT64
subtotal	FLOAT64
entity_id	FLOAT64
adjustment	FLOAT64
created_at	STRING
email_sent	FLOAT64
invoice_id	FLOAT64
tax_amount	FLOAT64
updated_at	STRING
grand_total	FLOAT64
increment_id	STRING
base_subtotal	FLOAT64
transaction_id	STRING
base_adjustment	FLOAT64
base_tax_amount	FLOAT64
discount_amount	FLOAT64
shipping_amount	FLOAT64
base_grand_total	FLOAT64
shipping_incl_tax	FLOAT64
subtotal_incl_tax	FLOAT64
base_currency_code	STRING
base_to_order_rate	FLOAT64
billing_address_id	FLOAT64
store_to_base_rate	FLOAT64
adjustment_negative	FLOAT64
adjustment_positive	FLOAT64
base_to_global_rate	FLOAT64
order_currency_code	STRING
shipping_tax_amount	FLOAT64
store_currency_code	STRING
store_to_order_rate	FLOAT64
base_discount_amount	FLOAT64
base_shipping_amount	FLOAT64
discount_description	STRING
global_currency_code	STRING
base_shipping_incl_tax	FLOAT64
base_subtotal_incl_tax	FLOAT64
base_adjustment_negative	FLOAT64
base_adjustment_positive	FLOAT64
base_shipping_tax_amount	FLOAT64
discount_tax_compensation_amount	FLOAT64
base_discount_tax_compensation_amount	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• creditmemos__items (30 columns)
• creditmemos__comments (9 columns)

customer_groups (6 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
code	STRING
tax_class_id	FLOAT64
tax_class_name	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

customers (20 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
dob	STRING
email	STRING
gender	FLOAT64
group_id	FLOAT64
lastname	STRING
store_id	FLOAT64
firstname	STRING
created_at	STRING
created_in	STRING
updated_at	STRING
website_id	FLOAT64
confirmation	STRING
default_billing	STRING
default_shipping	STRING
extension_attributes__is_subscribed	BOOL
extension_attributes__assistance_allowed	FLOAT64
disable_auto_group_change	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• customers__addresses (17 columns)
• customers__addresses__street (4 columns)
• customers__custom_attributes (5 columns)

directory_countries (7 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING
full_name_locale	STRING
full_name_english	STRING
two_letter_abbreviation	STRING
three_letter_abbreviation	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• directory_countries__available_regions (6 columns)

directory_currency (6 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
base_currency_code	STRING
base_currency_symbol	STRING
default_display_currency_code	STRING
default_display_currency_symbol	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• directory_currency__exchange_rates (5 columns)
• directory_currency__available_currency_codes (4 columns)

inventory_source_items (6 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sku	STRING
status	FLOAT64
quantity	FLOAT64
source_code	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

inventory_sources (13 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
name	STRING
enabled	BOOL
latitude	FLOAT64
postcode	STRING
longitude	FLOAT64
country_id	STRING
source_code	STRING
extension_attributes__frontend_name	STRING
extension_attributes__is_pickup_location_active	BOOL
use_default_carrier_config	BOOL
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• inventory_sources__carrier_links (4 columns)

inventory_stocks (4 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name	STRING
stock_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• inventory_stocks__extension_attributes__sales_channels (5 columns)

invoices (44 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
state	FLOAT64
order_id	FLOAT64
store_id	FLOAT64
subtotal	FLOAT64
entity_id	FLOAT64
total_qty	FLOAT64
created_at	STRING
email_sent	FLOAT64
tax_amount	FLOAT64
updated_at	STRING
grand_total	FLOAT64
increment_id	STRING
base_subtotal	FLOAT64
transaction_id	STRING
base_tax_amount	FLOAT64
discount_amount	FLOAT64
shipping_amount	FLOAT64
base_grand_total	FLOAT64
shipping_incl_tax	FLOAT64
subtotal_incl_tax	FLOAT64
base_currency_code	STRING
base_to_order_rate	FLOAT64
billing_address_id	FLOAT64
store_to_base_rate	FLOAT64
base_to_global_rate	FLOAT64
order_currency_code	STRING
shipping_tax_amount	FLOAT64
store_currency_code	STRING
store_to_order_rate	FLOAT64
base_discount_amount	FLOAT64
base_shipping_amount	FLOAT64
discount_description	STRING
extension_attributes__gift_cards_amount	FLOAT64
extension_attributes__base_gift_cards_amount	FLOAT64
global_currency_code	STRING
base_shipping_incl_tax	FLOAT64
base_subtotal_incl_tax	FLOAT64
base_shipping_tax_amount	FLOAT64
discount_tax_compensation_amount	FLOAT64
base_discount_tax_compensation_amount	FLOAT64
shipping_discount_tax_compensation_amount	FLOAT64
base_shipping_discount_tax_compensation_amnt	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• invoices__items (24 columns)
• invoices__comments (9 columns)

orders (127 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
state	STRING
status	STRING
weight	FLOAT64
payment__method	STRING
payment__cc_type	STRING
payment__cc_last4	STRING
payment__entity_id	FLOAT64
payment__parent_id	FLOAT64
payment__amount_paid	FLOAT64
payment__cc_exp_year	STRING
payment__cc_trans_id	STRING
payment__cc_exp_month	STRING
payment__last_trans_id	STRING
payment__amount_ordered	FLOAT64
payment__shipping_amount	FLOAT64
payment__base_amount_paid	FLOAT64
payment__cc_ss_start_year	STRING
payment__amount_authorized	FLOAT64
payment__cc_ss_start_month	STRING
payment__shipping_captured	FLOAT64
payment__base_amount_ordered	FLOAT64
payment__base_shipping_amount	FLOAT64
payment__base_amount_authorized	FLOAT64
payment__base_shipping_captured	FLOAT64
payment__base_amount_paid_online	FLOAT64
quote_id	FLOAT64
store_id	FLOAT64
subtotal	FLOAT64
entity_id	FLOAT64
remote_ip	STRING
total_due	FLOAT64
created_at	STRING
email_sent	FLOAT64
is_virtual	FLOAT64
store_name	STRING
tax_amount	FLOAT64
total_paid	FLOAT64
updated_at	STRING
coupon_code	STRING
customer_id	FLOAT64
grand_total	FLOAT64
increment_id	STRING
protect_code	STRING
tax_canceled	FLOAT64
tax_invoiced	FLOAT64
base_subtotal	FLOAT64
base_total_due	FLOAT64
customer_email	STRING
total_canceled	FLOAT64
total_invoiced	FLOAT64
base_tax_amount	FLOAT64
base_total_paid	FLOAT64
billing_address__city	STRING
billing_address__email	STRING
billing_address__region	STRING
billing_address__company	STRING
billing_address__lastname	STRING
billing_address__postcode	STRING
billing_address__entity_id	FLOAT64
billing_address__firstname	STRING
billing_address__parent_id	FLOAT64
billing_address__region_id	FLOAT64
billing_address__telephone	STRING
billing_address__country_id	STRING
billing_address__region_code	STRING
billing_address__address_type	STRING
billing_address__customer_address_id	FLOAT64
discount_amount	FLOAT64
shipping_amount	FLOAT64
applied_rule_ids	STRING
base_grand_total	FLOAT64
total_item_count	FLOAT64
base_tax_canceled	FLOAT64
base_tax_invoiced	FLOAT64
customer_group_id	FLOAT64
customer_is_guest	FLOAT64
customer_lastname	STRING
discount_canceled	FLOAT64
discount_invoiced	FLOAT64
shipping_canceled	FLOAT64
shipping_incl_tax	FLOAT64
shipping_invoiced	FLOAT64
subtotal_canceled	FLOAT64
subtotal_incl_tax	FLOAT64
subtotal_invoiced	FLOAT64
total_qty_ordered	FLOAT64
base_currency_code	STRING
base_to_order_rate	FLOAT64
billing_address_id	FLOAT64
customer_firstname	STRING
store_to_base_rate	FLOAT64
base_to_global_rate	FLOAT64
base_total_canceled	FLOAT64
base_total_invoiced	FLOAT64
order_currency_code	STRING
shipping_tax_amount	FLOAT64
store_currency_code	STRING
store_to_order_rate	FLOAT64
base_discount_amount	FLOAT64
base_shipping_amount	FLOAT64
customer_note_notify	FLOAT64
discount_description	STRING
extension_attributes__total_price_usd	STRING
extension_attributes__gift_cards_amount	FLOAT64
extension_attributes__converting_from_quote	BOOL
extension_attributes__base_gift_cards_amount	FLOAT64
global_currency_code	STRING
base_discount_canceled	FLOAT64
base_discount_invoiced	FLOAT64
base_shipping_canceled	FLOAT64
base_shipping_incl_tax	FLOAT64
base_shipping_invoiced	FLOAT64
base_subtotal_canceled	FLOAT64
base_subtotal_incl_tax	FLOAT64
base_subtotal_invoiced	FLOAT64
base_shipping_tax_amount	FLOAT64
base_total_invoiced_cost	FLOAT64
shipping_discount_amount	FLOAT64
base_shipping_discount_amount	FLOAT64
discount_tax_compensation_amount	FLOAT64
discount_tax_compensation_invoiced	FLOAT64
base_discount_tax_compensation_amount	FLOAT64
base_discount_tax_compensation_invoiced	FLOAT64
shipping_discount_tax_compensation_amount	FLOAT64
base_shipping_discount_tax_compensation_amnt	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• orders__items (113 columns)
• orders__items__parent_item__product_option__extension_attributes__configurable_item_options (5 columns)
• orders__items__parent_item__extension_attributes__itemized_taxes (4 columns)
• orders__items__product_option__extension_attributes__configurable_item_options (5 columns)
• orders__items__extension_attributes__itemized_taxes (4 columns)
• orders__payment__additional_information (4 columns)
• orders__billing_address__street (4 columns)
• orders__status_histories (11 columns)
• orders__extension_attributes__taxes (4 columns)
• orders__extension_attributes__gift_cards (4 columns)
• orders__extension_attributes__applied_taxes (4 columns)
• orders__extension_attributes__item_applied_taxes (4 columns)
• orders__extension_attributes__shipping_assignments (17 columns)
• orders__extension_attributes__shipping_assignments__items (113 columns)
• orders__extension_attributes__shipping_assignments__items__parent_item__product_option__extension_attributes__configurable_item_options (5 columns)
• orders__extension_attributes__shipping_assignments__items__parent_item__extension_attributes__itemized_taxes (4 columns)
• orders__extension_attributes__shipping_assignments__items__product_option__extension_attributes__configurable_item_options (5 columns)
• orders__extension_attributes__shipping_assignments__items__extension_attributes__itemized_taxes (4 columns)
• orders__extension_attributes__payment_additional_info (4 columns)
• orders__extension_attributes__additional_itemized_taxes (4 columns)

products (13 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
sku	STRING
name	STRING
price	FLOAT64
status	FLOAT64
weight	FLOAT64
type_id	STRING
created_at	STRING
updated_at	STRING
visibility	FLOAT64
attribute_set_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• products__options (15 columns)
• products__options__values (9 columns)
• products__tier_prices (4 columns)
• products__product_links (4 columns)
• products__custom_attributes (5 columns)
• products__extension_attributes__website_ids (4 columns)
• products__extension_attributes__category_links (5 columns)
• products__extension_attributes__giftcard_amounts (4 columns)
• products__extension_attributes__configurable_product_links (4 columns)
• products__extension_attributes__configurable_product_options (8 columns)
• products__extension_attributes__configurable_product_options__values (4 columns)
• products__media_gallery_entries (8 columns)
• products__media_gallery_entries__types (4 columns)

sales_rules (30 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
name	STRING
is_rss	BOOL
rule_id	FLOAT64
condition__value	STRING
condition__condition_type	STRING
condition__aggregator_type	STRING
from_date	STRING
is_active	BOOL
sort_order	FLOAT64
times_used	FLOAT64
coupon_type	STRING
is_advanced	BOOL
discount_qty	FLOAT64
discount_step	FLOAT64
simple_action	STRING
discount_amount	FLOAT64
uses_per_coupon	FLOAT64
action_condition__value	STRING
action_condition__condition_type	STRING
action_condition__aggregator_type	STRING
apply_to_shipping	BOOL
uses_per_customer	FLOAT64
use_auto_generation	BOOL
extension_attributes__show_banner_for	FLOAT64
extension_attributes__banner_product_sku	STRING
simple_free_shipping	STRING
stop_rules_processing	BOOL
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• sales_rules__condition__conditions (8 columns)
• sales_rules__condition__conditions__conditions (8 columns)
• sales_rules__website_ids (4 columns)
• sales_rules__store_labels (4 columns)
• sales_rules__action_condition__conditions (7 columns)
• sales_rules__customer_group_ids (4 columns)
• sales_rules__extension_attributes__promo_banners_lite (9 columns)
• sales_rules__extension_attributes__banner_product_categories (4 columns)

shipments (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
order_id	FLOAT64
entity_id	FLOAT64
total_qty	FLOAT64
created_at	STRING
updated_at	STRING
increment_id	STRING
billing_address_id	FLOAT64
extension_attributes__source_code	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• shipments__items (10 columns)
• shipments__tracks (11 columns)
• shipments__comments (9 columns)
• shipments__packages (4 columns)

store_groups (8 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
code	STRING
name	STRING
website_id	FLOAT64
default_store_id	FLOAT64
root_category_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

store_views (8 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
code	STRING
name	STRING
is_active	FLOAT64
website_id	FLOAT64
store_group_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

store_websites (6 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
code	STRING
name	STRING
default_group_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

tax_classes (5 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
class_id	FLOAT64
class_name	STRING
class_type	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

tax_rates (9 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
code	STRING
rate	FLOAT64
region_name	STRING
tax_postcode	STRING
tax_region_id	FLOAT64
tax_country_id	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• tax_rates__titles (4 columns)

transactions (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
txn_id	STRING
order_id	FLOAT64
txn_type	STRING
is_closed	FLOAT64
parent_id	FLOAT64
created_at	STRING
payment_id	FLOAT64
parent_txn_id	STRING
transaction_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

• transactions__child_transactions (12 columns)
• transactions__child_transactions__child_transactions (12 columns)
• transactions__child_transactions__child_transactions__child_transactions (4 columns)
• transactions__child_transactions__child_transactions__additional_information (4 columns)
• transactions__child_transactions__additional_information (4 columns)
• transactions__additional_information (4 columns)

How the Adobe Commerce sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Adobe Commerce 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.

Frequently asked questions

How long does the initial sync take for Adobe Commerce?

It depends on how much history is in your Adobe Commerce 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.

Can I sync only some tables or columns?

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 Adobe Commerce’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 Adobe Commerce, 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?

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 Adobe Commerce 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 Adobe Commerce connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Adobe Commerce data

Sales reporting

Combine orders, invoices, and transactions to track revenue, refunds, and average order value over time.

Product performance

Join orders with products to see best sellers, slow movers, and margin by category.

Customer analysis

Use customers and customer_groups to measure repeat purchase rates and lifetime value.

Inventory and fulfilment

Bring inventory_stocks and shipments together to monitor stock levels and fulfilment speed.

Use Adobe Commerce data in your AI and BI tools

Once Adobe Commerce 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 Adobe Commerce data.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

See our pricing page for Adobe Commerce connector pricing and plan details.

Related connectors

• Google Analytics: Sync Google Analytics to BigQuery.
• Recharge: Sync Recharge to BigQuery.
• Extensiv 3PL Warehouse Manager: Sync Extensiv 3PL Warehouse Manager to BigQuery.
• WooCommerce: Sync WooCommerce to BigQuery.
• Amazon Selling Partner: Sync Amazon Selling Partner to BigQuery.
• Akeneo: Sync Akeneo to BigQuery.