Skip to content
Book a demoStart free
Connectors

Shopify connector

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

Shopify connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Shopify 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 Shopify store data into BigQuery with Kaivo to analyse orders, products, and customers without exporting reports by hand.

CategoryE-commerce
AuthenticationUsername and password
SetupSelf-service

Getting started with the Shopify connector

Section titled “Getting started with the Shopify connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Shopify 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.

Connect with your Shopify login. You provide:

Field Description
API Password
The Admin API access token of a custom app in your Shopify store (Settings → Apps and sales channels → Develop apps → your app → API credentials).

|

When you set up the connector, you provide:

Field Description
Shopify Store
The name of your Shopify store found in the URL. For example, if your URL was https://my-store.myshopify.com, then the name would be ‘my-store’ or ‘my-store.myshopify.com’.

| | Start Date |

Any data before this date will not be fetched.

| | Include Closed Fulfillment Orders |

If enabled, the Fulfillment Orders table includes closed fulfillment orders. Shopify excludes closed orders by default.

|

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

abandoned_checkouts (103 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
location_id INT64 ID of the location
buyer_accepts_marketing BOOL Indicates if the buyer accepts marketing
currency STRING Currency used for the checkout
completed_at TIMESTAMP Date and time when the checkout was completed
token STRING Token associated with the checkout
billing_address__phone STRING Phone number associated with the billing address
billing_address__country STRING Country of the customer’s billing address
billing_address__first_name STRING First name of the customer
billing_address__name STRING Full name associated with the billing address
… and 93 more columns

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

  • abandoned_checkouts__note_attributes (5 columns)
  • abandoned_checkouts__discount_codes (6 columns)
  • abandoned_checkouts__tax_lines (14 columns)
  • abandoned_checkouts__line_items (14 columns)
  • abandoned_checkouts__shipping_lines (16 columns)
  • abandoned_checkouts__shipping_lines__applied_discounts (4 columns)
  • abandoned_checkouts__shipping_lines__tax_lines (14 columns)
  • abandoned_checkouts__customer__addresses (20 columns)
  • abandoned_checkouts__customer__tax_exemptions (4 columns)
articles (20 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 article
title STRING The title of the article
created_at TIMESTAMP The date and time when the article was created
body_html STRING The HTML content of the article body
blog_id INT64 The unique identifier of the blog to which the article belongs
author STRING The name of the author of the article
user_id STRING The unique identifier of the user who created the article
published_at TIMESTAMP The date and time when the article was published
updated_at TIMESTAMP The date and time when the article was last updated
… and 10 more columns
balance_transactions (17 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 balance transaction.
type STRING The type of transaction.
test BOOL Flag indicating if the transaction is a test transaction.
payout_id INT64 The identifier of the associated payout.
payout_status STRING The status of the payout associated with this transaction.
payoucurrencyt_status STRING Indicates the status of the payout for the currency in which the transaction occurred.
amount FLOAT64 The amount of the transaction in the specified currency.
fee FLOAT64 The fee associated with the transaction.
net FLOAT64 The final amount received after deducting fees.
… and 7 more columns
blogs (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
commentable STRING Indicates whether comments are allowed on the blog.
created_at TIMESTAMP The date and time when the blog was created.
feedburner TIMESTAMP The Feedburner date for the blog.
feedburner_location INT64 The location information related to Feedburner.
handle STRING The unique handle used in the blog’s URL.
id INT64 The unique identifier for the blog.
tags STRING Tags associated with the blog.
template_suffix STRING The template suffix used in the blog’s layout.
title STRING The title of the blog.
… and 7 more columns
collection_products (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
collection_id INT64 The unique identifier for the collection.
collection_admin_graphql_api_id STRING The Admin GraphQL API ID for the collection.
collection_handle STRING The handle (URL-friendly name) for the collection.
collection_updated_at TIMESTAMP The date and time when the collection was last updated.
product_id INT64 The unique identifier for the product.
product_admin_graphql_api_id STRING The Admin GraphQL API ID for the product.
shop_url STRING The URL of the shop associated with this collection-product association.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
collections (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the collection.
handle STRING A unique URL-friendly string that represents the collection.
title STRING The title or name of the collection.
updated_at TIMESTAMP The datetime when the collection was last updated.
body_html STRING The HTML content describing the collection.
published_at TIMESTAMP The datetime when the collection was published.
sort_order STRING The order in which the collection should be sorted.
template_suffix STRING The name of the template that is used to render the collection.
products_count INT64 The number of products within the collection.
… and 5 more columns
collects (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the collect.
collection_id INT64 The unique identifier for the collection.
created_at TIMESTAMP The date and time when the collect was created.
position INT64 The position of the product in the collection.
product_id INT64 The unique identifier of the product.
sort_value STRING The value used to sort the products in the collection.
shop_url STRING The URL of the shop associated with the collect.
updated_at TIMESTAMP The date and time when the collect was last updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
countries (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING ISO country code.
id INT64 Unique identifier for the country.
name STRING Name of the country.
rest_of_world BOOL Whether the country in a catch-all group of countries that are not individually listed or assigned to any specific zone or market.
translated_name STRING Translated name of the country
shop_url STRING URL for the shop related to this country.
_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.

  • countries__provinces (8 columns)
custom_collections (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
handle STRING The unique URL-friendly string that identifies the custom collection.
sort_order STRING The order in which the custom collection should be displayed.
body_html STRING The full description of the custom collection for display purposes.
title STRING The title of the custom collection.
id INT64 The unique identifier of the custom collection.
published_scope STRING The scope where the custom collection is published (global or web).
admin_graphql_api_id STRING The unique identifier of the custom collection accessible via GraphQL Admin API.
updated_at TIMESTAMP The date and time when the custom collection was last updated.
image__alt STRING The alternative text description of the image.
… and 11 more columns
customer_address (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address1 STRING The first line of the customer’s street address.
address2 STRING The second line of the customer’s street address.
city STRING The city where the customer resides.
country STRING The full name of the country associated with the address.
country_code STRING The ISO 3166-1 alpha-2 country code of the address country.
country_name STRING The name of the country associated with the address.
company STRING The company name associated with the customer’s address.
customer_id INT64 The unique identifier of the customer to whom the address belongs.
first_name STRING The first name of the customer.
… and 11 more columns
customer_journey_summary (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
order_id INT64 The id of the order.
created_at TIMESTAMP The date and time when the order was created.
updated_at TIMESTAMP The date and time when the order was last updated.
customer_journey_summary__ready BOOL Whether the attributed sessions for the order have been created yet.
customer_journey_summary__moments_count__count INT64 Count of elements.
customer_journey_summary__moments_count__precision STRING Precision of count, how exact is the value.
customer_journey_summary__customer_order_index INT64 The position of the current order within the customer’s order history. Test orders aren’t included.
customer_journey_summary__days_to_conversion INT64 The number of days between the first session and the order creation date. The first session represents the first session since the last order, or the first session within the 30 day attribution window, if more than 30 days have passed since the last order.
customer_journey_summary__first_visit__id INT64 A globally-unique ID.
… and 32 more columns

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

  • customer_journey_summary__customer_journey_summary__moments (18 columns)
customers (50 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
last_order_name STRING Name of the customer’s last order.
currency STRING Currency associated with the customer.
email STRING Customer’s email address.
multipass_identifier STRING Multipass identifier for the customer.
shop_url STRING URL of the customer’s associated shop.
default_address__city STRING City where the customer’s default address is located.
default_address__address1 STRING First line of customer’s default address.
default_address__zip STRING Postal or ZIP code of the customer’s default address.
default_address__id INT64 Unique identifier for the default address.
… and 40 more columns

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

  • customers__addresses (20 columns)
deleted_products (7 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 deleted product.
deleted_at TIMESTAMP The date and time when the product was deleted.
deleted_message STRING Message related to the deletion of the product.
deleted_description STRING Description of the reason for deletion.
shop_url STRING The URL of the shop where the product was listed.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
discount_codes (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the discount code
price_rule_id INT64 The identifier of the price rule associated with the discount code
code STRING The discount code that customers can use during checkout to apply the discount
usage_count INT64 The number of times the discount code has been used by customers
created_at TIMESTAMP The date and time when the discount code was created
created_by__id STRING
created_by__title STRING
updated_at TIMESTAMP The date and time when the discount code was last updated
summary STRING A brief summary or description of the discount code
… and 15 more columns
disputes (14 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 dispute
order_id INT64 The identifier of the order associated with the dispute
type STRING The type of dispute (e.g., chargeback, refund request)
currency STRING The currency in which the dispute amount is represented
amount STRING The disputed amount in the currency specified
reason STRING The reason provided for the dispute
network_reason_code STRING The reason code provided by the network for the dispute
status STRING The current status of the dispute
initiated_at TIMESTAMP The date and time when the dispute was initiated
… and 4 more columns
draft_orders (102 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier of the draft order
note STRING Additional notes or comments related to the draft order
email STRING Email address associated with the draft order
taxes_included BOOL Indicates if taxes are included in the prices
currency STRING Currency used for the draft order
invoice_sent_at TIMESTAMP Timestamp when the invoice was sent
created_at TIMESTAMP Timestamp when the draft order was created
updated_at TIMESTAMP Timestamp when the draft order was last updated
tax_exempt BOOL Indicates if the draft order is tax exempt
… and 92 more columns

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

  • draft_orders__line_items (25 columns)
  • draft_orders__line_items__tax_lines (10 columns)
  • draft_orders__line_items__properties (5 columns)
  • draft_orders__tax_lines (10 columns)
  • draft_orders__note_attributes (5 columns)
  • draft_orders__customer__tax_exemptions (4 columns)
fulfillment_orders (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assigned_location_id INT64 The unique identifier of the assigned location
channel_id STRING The ID of the channel that created an order
destination__id INT64 The unique identifier of the destination
destination__address1 STRING The primary address of the destination
destination__address2 STRING The secondary address of the destination
destination__city STRING The city of the destination
destination__company STRING The name of the company at the destination
destination__country STRING The country of the destination
destination__email STRING The email address of the recipient at the destination
… and 32 more columns

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

  • fulfillment_orders__fulfillment_holds (5 columns)
  • fulfillment_orders__line_items (11 columns)
  • fulfillment_orders__supported_actions (5 columns)
  • fulfillment_orders__merchant_requests (7 columns)
fulfillments (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
admin_graphql_api_id STRING The unique identifier of the resource in the Admin GraphQL API.
created_at TIMESTAMP The date and time when the fulfillment was created.
id INT64 The unique identifier of the fulfillment.
location_id INT64 The location identifier where the fulfillment takes place.
name STRING The name of the fulfillment.
notify_customer BOOL Indicates if the customer should be notified about the fulfillment.
order_id INT64 The unique identifier of the order associated with the fulfillment.
origin_address__address1 STRING The first line of the origin address.
origin_address__address2 STRING The second line of the origin address.
… and 16 more columns

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

  • fulfillments__tracking_numbers (4 columns)
  • fulfillments__tracking_urls (4 columns)
  • fulfillments__line_items (33 columns)
  • fulfillments__line_items__properties (4 columns)
  • fulfillments__line_items__tax_lines (11 columns)
  • fulfillments__line_items__duties (10 columns)
  • fulfillments__line_items__duties__tax_lines (11 columns)
  • fulfillments__line_items__discount_allocations (13 columns)
  • fulfillments__duties (10 columns)
  • fulfillments__duties__tax_lines (11 columns)
inventory_items (16 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 inventory item
admin_graphql_api_id STRING The unique identifier for the inventory item in the admin GraphQL API
cost FLOAT64 The cost of the inventory item
currency_code STRING Currency of the money
country_code_of_origin STRING The country code indicating the origin of the inventory item
duplicate_sku_count INT64 The number of inventory items that share the same SKU with this item
harmonized_system_code STRING The harmonized system code for the inventory item
province_code_of_origin STRING The province code indicating the origin of the inventory item
updated_at TIMESTAMP The date and time when the inventory item was last updated
… and 6 more columns

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

  • inventory_items__country_harmonized_system_codes (4 columns)
inventory_levels (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The unique identifier for the inventory level.
admin_graphql_api_id STRING The unique identifier for the inventory levels in GraphQL format.
available INT64 The quantity of items available for sale in the inventory.
can_deactivate BOOL Whether the inventory items associated with the inventory level can be deactivated.
created_at TIMESTAMP The date and time when the inventory level was created.
inventory_history_url STRING The URL that points to the inventory history for the item.
locations_count__count INT64 The count of elements.
deactivation_alert STRING Describes either the impact of deactivating the inventory level, or why the inventory level can’t be deactivated.
inventory_item_id INT64 The unique identifier for the associated inventory item.
… and 4 more columns

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

  • inventory_levels__quantities (8 columns)
locations (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Indicates if the location is currently active or not.
address1 STRING The first line of the location’s address.
address2 STRING The second line of the location’s address.
admin_graphql_api_id STRING The Admin GraphQL API ID of the location.
city STRING The city where the location is based.
country STRING The full name of the country where the location is located.
country_code STRING The ISO country code of the location.
country_name STRING The name of the country where the location is located.
created_at TIMESTAMP The date and time when the location was created.
… and 12 more columns
metafield_articles (15 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 metafield
namespace STRING The namespace under which the metafield is defined
key STRING The key or identifier used to access the metafield
value STRING The actual value stored in the metafield
value_type STRING The type of value stored in the metafield (e.g., single, array)
description STRING The description or details of the metafield
owner_id INT64 The unique identifier of the resource that owns the metafield
created_at TIMESTAMP The date and time when the metafield was created
updated_at TIMESTAMP The date and time when the metafield was last updated
… and 5 more columns
metafield_blogs (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
owner_id INT64 The unique identifier of the owner associated with the metafield data
admin_graphql_api_id STRING The unique identifier for the metafield data in the Admin GraphQL API
owner_resource STRING The resource type of the owner associated with the metafield data
value_type STRING The data type of the value stored in the metafield
key STRING The key associated with the metafield data
created_at TIMESTAMP The date and time when the metafield data was created
id INT64 The unique identifier for the metafield data
namespace STRING The namespace of the metafield data
description STRING The description of the metafield data
… and 5 more columns
metafield_collections (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
owner_id INT64 The ID of the owner associated with the metafield collection
admin_graphql_api_id STRING The unique identifier for the metafield collection in the Admin GraphQL API
owner_resource STRING The resource type of the owner associated with the metafield collection
value_type STRING The type of the value in the metafield collection
key STRING The key associated with the metafield collection
created_at TIMESTAMP The date and time when the metafield collection was created
id INT64 The unique identifier for the metafield collection
namespace STRING The namespace for the metafield collection
description STRING The description of the metafield collection
… and 5 more columns
metafield_customers (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the metafield.
namespace STRING The namespace in which the metafield is defined.
key STRING The key or title that identifies the metafield.
value STRING The actual value of the metafield.
value_type STRING The type of value stored in the metafield (e.g., string, integer, boolean).
description STRING The description or additional information about the metafield.
owner_id INT64 The unique identifier of the resource owner associated with the metafield.
created_at TIMESTAMP The date and time when the metafield was created.
updated_at TIMESTAMP The date and time when the metafield was last updated.
… and 5 more columns
metafield_draft_orders (15 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 metafield draft order.
namespace STRING The namespace of the metafield draft order.
key STRING The key associated with the metafield draft order.
value STRING The value of the metafield draft order.
value_type STRING The data type of the value of the metafield draft order.
description STRING The textual description of the metafield draft order.
owner_id INT64 The unique identifier of the owner (e.g., shop) associated with the metafield draft order.
created_at TIMESTAMP The date and time when the metafield draft order was created.
updated_at TIMESTAMP The date and time when the metafield draft order was last updated.
… and 5 more columns
metafield_locations (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the metafield
namespace STRING The namespace of the metafield
key STRING The key or name of the metafield
value STRING The actual value of the metafield
value_type STRING The data type of the metafield value
description STRING The description of the metafield
owner_id INT64 The unique identifier of the resource that owns the metafield
created_at TIMESTAMP The date and time when the metafield was created
updated_at TIMESTAMP The date and time when the metafield was last updated
… and 5 more columns
metafield_orders (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the metafield record.
namespace STRING The area or group to which the metafield belongs.
key STRING The name that identifies the metafield.
value STRING The actual value of the metafield.
value_type STRING The type of data stored in the metafield value.
description STRING Additional information or notes about the metafield.
owner_id INT64 The unique identifier of the resource that owns the metafield.
created_at TIMESTAMP The date and time when the metafield was created.
updated_at TIMESTAMP The date and time when the metafield was last updated.
… and 5 more columns
metafield_pages (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 A unique identifier for the metafield.
namespace STRING The namespace for the metafield, used to group related metafields together.
key STRING The key or name of the metafield.
value STRING The actual value stored in the metafield.
value_type STRING The data type of the value stored in the metafield (e.g., string, integer).
description STRING The description or purpose of the metafield.
owner_id INT64 The ID of the resource (e.g., product, order) that owns the metafield.
created_at TIMESTAMP The date and time when the metafield was created.
updated_at TIMESTAMP The date and time when the metafield was last updated.
… and 5 more columns
metafield_product_images (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique ID of the metafield.
namespace STRING The namespace of the metafield.
key STRING The key that identifies the metafield.
value STRING The actual value stored in the metafield.
value_type STRING The type of the value stored in the metafield.
description STRING The description of the metafield.
owner_id INT64 The ID of the owner of the metafield.
created_at TIMESTAMP The date and time when the metafield was created.
updated_at TIMESTAMP The date and time when the metafield was last updated.
… and 5 more columns
metafield_product_variants (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the metafield
namespace STRING The namespace for grouping metafields
key STRING The key associated with the metafield for identifying purposes
value STRING The actual value of the metafield
value_type STRING The type that the value of the metafield represents (e.g., URL, text)
description STRING The description of the metafield content
owner_id INT64 The unique identifier of the entity that owns the metafield
created_at TIMESTAMP The date and time when the metafield was created
updated_at TIMESTAMP The date and time when the metafield was last updated
… and 5 more columns
metafield_products (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 A unique identifier for the metafield.
namespace STRING The namespace for the metafield, helping to group related metafields together.
key STRING The key or name that identifies the metafield.
value STRING The actual value of the metafield based on its type.
value_type STRING A representation of the type of the value (for example, ‘string’ or ‘integer’).
description STRING The description of the metafield, providing additional information.
owner_id INT64 The unique identifier of the resource that owns the metafield.
created_at TIMESTAMP The date and time the metafield was created in ISO 8601 format.
updated_at TIMESTAMP The date and time the metafield was last updated in ISO 8601 format.
… and 5 more columns
metafield_shops (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the metafield.
namespace STRING The namespace to which the metafield belongs.
key STRING The key that identifies the metafield.
value STRING The actual value stored in the metafield.
value_type STRING The data type of the value stored in the metafield.
description STRING The additional information about the metafield.
owner_id INT64 The unique identifier of the owner resource linked to this metafield.
created_at TIMESTAMP The date and time when the metafield was created.
updated_at TIMESTAMP The date and time when the metafield was last updated.
… and 5 more columns
metafield_smart_collections (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the metafield.
namespace STRING The container for a set of metafields. Typically corresponds to a section of the store.
key STRING The key or name associated with the metafield.
value STRING The actual value of the metafield.
value_type STRING The type of value stored in the metafield (e.g., string, integer, json_string).
description STRING The detailed description of the metafield data.
owner_id INT64 The ID of the resource to which the metafield is attached.
created_at TIMESTAMP The date and time when the metafield was created.
updated_at TIMESTAMP The date and time when the metafield was last updated.
… and 5 more columns
order_agreements (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 A globally-unique Order ID
created_at TIMESTAMP The date and time when the order was created
updated_at TIMESTAMP The date and time when the order was last updated
admin_graphql_api_id STRING The original order id reference for the shopify api
shop_url STRING URL of the shop where the order was placed.
_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.

  • order_agreements__agreements (7 columns)
  • order_agreements__agreements__sales (18 columns)
order_refunds (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
order_id INT64 ID of the original order for which the refund was issued
restock BOOL Indicates if the refund involves restocking items
processed_at STRING Date and time when the refund was processed
user_id INT64 ID of the user who initiated the refund
note STRING Any additional notes or comments regarding the refund
id INT64 Unique identifier for the order refund resource
created_at TIMESTAMP Date and time when the order refund was created
admin_graphql_api_id STRING ID of the Shopify API resource
duties STRING Information about any duties associated with the refund
… and 8 more columns

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

  • order_refunds__order_adjustments (10 columns)
  • order_refunds__refund_line_items (52 columns)
  • order_refunds__refund_line_items__line_item__tax_lines (11 columns)
  • order_refunds__refund_line_items__line_item__properties (4 columns)
  • order_refunds__refund_line_items__line_item__discount_allocations (9 columns)
  • order_refunds__refund_line_items__line_item__duties (8 columns)
  • order_refunds__transactions (34 columns)
order_risks (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the order risk entry.
order_id INT64 The identifier of the order to which the risk is related.
checkout_id INT64 The unique identifier of the checkout associated with the order.
source STRING Source of the risk notification.
score FLOAT64 Numerical score indicating the level of risk.
recommendation STRING Suggested action to mitigate the risk.
display BOOL Flag to determine if the risk should be displayed to the merchant.
cause_cancel BOOL Reason indicating why the order is at risk of cancellation.
message STRING Description of the risk associated with the order.
… and 5 more columns

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

  • order_risks__assessments (27 columns)
  • order_risks__assessments__facts (5 columns)
  • order_risks__assessments__provider__features (4 columns)
  • order_risks__assessments__provider__failed_requirements (7 columns)
  • order_risks__assessments__provider__feedback__messages (5 columns)
orders (207 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 order
admin_graphql_api_id STRING The unique identifier of the order in the GraphQL Admin API
app_id INT64 The ID of the app that created the order
browser_ip STRING The IP address of the customer’s browser
buyer_accepts_marketing BOOL Indicates if the customer has agreed to receive marketing emails
cancel_reason STRING The reason provided if the order was canceled
cancelled_at TIMESTAMP The date and time when the order was canceled
cart_token STRING Token representing the cart associated with the order
checkout_id INT64 The ID of the checkout that processed the order
… and 197 more columns

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

  • orders__discount_applications (11 columns)
  • orders__discount_codes (6 columns)
  • orders__note_attributes (5 columns)
  • orders__payment_gateway_names (4 columns)
  • orders__tax_lines (11 columns)
  • orders__customer__tax_exemptions (4 columns)
  • orders__discount_allocations (13 columns)
  • orders__fulfillments (22 columns)
  • orders__fulfillments__tracking_numbers (4 columns)
  • orders__fulfillments__tracking_urls (4 columns)
  • orders__fulfillments__line_items (49 columns)
  • orders__fulfillments__line_items__properties (5 columns)
  • orders__fulfillments__line_items__tax_lines (11 columns)
  • orders__fulfillments__line_items__duties (11 columns)
  • orders__fulfillments__line_items__duties__tax_lines (11 columns)
  • orders__fulfillments__line_items__discount_allocations (13 columns)
  • orders__line_items (49 columns)
  • orders__line_items__properties (5 columns)
  • orders__line_items__tax_lines (11 columns)
  • orders__line_items__duties (11 columns)
  • orders__line_items__duties__tax_lines (11 columns)
  • orders__line_items__discount_allocations (13 columns)
  • orders__refunds (15 columns)
  • orders__refunds__order_adjustments (18 columns)
  • orders__refunds__transactions (34 columns)
  • orders__refunds__refund_line_items (47 columns)
  • orders__refunds__refund_line_items__line_item__properties (4 columns)
  • orders__refunds__refund_line_items__line_item__tax_lines (11 columns)
  • orders__refunds__refund_line_items__line_item__discount_allocations (9 columns)
  • orders__refunds__refund_line_items__line_item__duties (8 columns)
  • orders__refunds__duties (8 columns)
  • orders__shipping_lines (20 columns)
  • orders__shipping_lines__tax_lines (4 columns)
  • orders__shipping_lines__discount_allocations (13 columns)
pages (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
author STRING The author of the page.
admin_graphql_api_id STRING The unique identifier for the page in the Admin GraphQL API.
body_html JSON The HTML content of the page.
created_at TIMESTAMP The timestamp when the page was created.
handle STRING The unique URL path segment for the page.
id INT64 The unique identifier for the page.
published_at TIMESTAMP The timestamp when the page was published.
shop_id INT64 The ID of the shop to which the page belongs.
template_suffix STRING The suffix of the liquid template used for the page.
… and 7 more columns
price_rules (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
allocation_method STRING The method used to allocate the discount
admin_graphql_api_id STRING The unique identifier for the price rule in the GraphQL Admin API
created_at TIMESTAMP The date and time when the price rule was created
updated_at TIMESTAMP The date and time when the price rule was last updated
customer_selection STRING The customer selection criteria for the discount
ends_at TIMESTAMP The date and time when the discount ends
id INT64 The unique identifier for the price rule
once_per_customer BOOL Whether the discount can only be applied once per customer
prerequisite_quantity_range__greater_than_or_equal_to INT64 The minimum quantity required for the discount
… and 18 more columns

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

  • price_rules__customer_segment_prerequisite_ids (4 columns)
  • price_rules__entitled_collection_ids (4 columns)
  • price_rules__entitled_country_ids (4 columns)
  • price_rules__entitled_product_ids (4 columns)
  • price_rules__entitled_variant_ids (4 columns)
  • price_rules__prerequisite_customer_ids (4 columns)
  • price_rules__prerequisite_saved_search_ids (4 columns)
  • price_rules__prerequisite_product_ids (4 columns)
  • price_rules__prerequisite_variant_ids (4 columns)
  • price_rules__prerequisite_collection_ids (4 columns)
product_images (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP Date and time when the image was created
id INT64 Unique identifier for the image
position INT64 Position order of the image relative to other images of the same product
product_id INT64 Unique identifier of the product associated with the image
src STRING URL of the image
width INT64 Width of the image in pixels
height INT64 Height of the image in pixels
updated_at TIMESTAMP Date and time when the image was last updated
admin_graphql_api_id STRING Unique identifier for the image in the Admin GraphQL API
… and 3 more columns

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

  • product_images__variant_ids (4 columns)
product_variants (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the variant
product_id INT64 The unique identifier for the product associated with the variant
title STRING The title of the variant
price FLOAT64 The price of the variant
sku STRING The unique SKU (stock keeping unit) of the variant
position INT64 The position of the variant in the product’s list of variants
inventory_policy STRING The inventory policy for the variant
compare_at_price STRING The original price of the variant before any discount
option1 STRING The value for option 1 of the variant
… and 23 more columns

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

  • product_variants__options (14 columns)
  • product_variants__presentment_prices (7 columns)
products (66 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
published_at TIMESTAMP The date and time when the product was published.
created_at TIMESTAMP The date and time when the product was created.
published_scope STRING The scope of where the product is available for purchase.
status STRING The status of the product.
vendor STRING The vendor or manufacturer of the product.
updated_at TIMESTAMP The date and time when the product was last updated.
body_html STRING The HTML description of the product.
product_type STRING The type or category of the product.
tags STRING Tags associated with the product.
… and 56 more columns

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

  • products__options (7 columns)
  • products__options__values (4 columns)
  • products__image__variant_ids (4 columns)
  • products__images (13 columns)
  • products__images__variant_ids (4 columns)
  • products__variants (30 columns)
  • products__variants__presentment_prices (6 columns)
  • products__featured_media__media_errors (6 columns)
  • products__featured_media__media_warnings (5 columns)
profile_location_groups (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING ID of the location group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shop (60 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address1 STRING The first line of the shop’s address
address2 STRING The second line of the shop’s address
auto_configure_tax_inclusivity STRING Flag indicating if taxes are automatically configured to be inclusive
checkout_api_supported BOOL Flag indicating if the shop supports the checkout API
city STRING The city where the shop is located
country STRING The country where the shop is located
country_code STRING The country code of the shop’s location
country_name STRING The name of the country where the shop is located
county_taxes BOOL Flag indicating if county taxes are applicable
… and 50 more columns

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

  • shop__enabled_presentment_currencies (4 columns)
smart_collections (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the smart collection
handle STRING The human-friendly URL for the collection
title STRING The title or name of the smart collection
updated_at TIMESTAMP The date and time when the collection was last updated
body_html STRING The description or details of the smart collection
published_at TIMESTAMP The date and time when the collection was published
sort_order STRING The order in which the collection is displayed
template_suffix STRING The suffix added to the collection template filename
disjunctive BOOL Indicates whether the collection uses disjunctive filtering
… and 4 more columns

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

  • smart_collections__rules (4 columns)
tender_transactions (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the tender transaction.
order_id INT64 The identifier of the order associated with the transaction.
amount STRING The transaction amount in the specified currency.
currency STRING The currency in which the transaction amount is stated.
user_id INT64 Unique identifier of the user associated with the transaction.
test BOOL Flag indicating whether the transaction was done in a testing environment.
processed_at TIMESTAMP The date and time when the transaction was processed.
remote_reference STRING Reference to an external system for the transaction.
payment_details__credit_card_number STRING The masked credit card number used for payment.
… and 4 more columns
transactions (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
error_code STRING Error code associated with the transaction
device_id INT64 ID of the device used to process the transaction
user_id INT64 ID of the user associated with the transaction
parent_id INT64 ID of the parent transaction if applicable
test BOOL Flag to indicate if the transaction is a test transaction
kind STRING Type of transaction
order_id INT64 ID of the order associated with the transaction
amount FLOAT64 The amount of the transaction
amount_set__shop_money__amount FLOAT64 Amount in the shop currency
… and 35 more columns

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

  • transactions__fees (15 columns)

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

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

It depends on how much history is in your Shopify 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 Shopify’s schema changes?

Section titled “What happens when Shopify’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 Shopify, 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 Shopify 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 Shopify connector in Kaivo and all of its synced data is deleted with it.

Bring your Shopify orders into BigQuery to track revenue and average order value over time.

Analyse orders and products to see best sellers and margin by category.

Use your customer data to measure repeat purchase rates and lifetime value.

Once Shopify 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 Shopify 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 Shopify connector pricing and plan details.