Shopify connector

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

Written By Lauri Raivio

Last updated 15 days ago

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.

What is the Shopify connector

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

Category	E-commerce
Authentication	Username and password
Setup	Self-service

Getting started with the Shopify connector

Sign up for Kaivo and create a workspace.
Connect your Shopify 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.

Authenticating Shopify

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).

Configuring the Shopify connector

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.

Tables and columns synced from Shopify

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

Nested subtables

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.

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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.

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

transactions__fees (15 columns)

How the Shopify sync works

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.

Frequently asked questions

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.

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 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.

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.

Common use cases for Shopify data

Sales reporting

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

Product performance

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

Customer analysis

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

Use Shopify data in your AI and BI tools

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.

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

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.
Adobe Commerce: Sync Adobe Commerce to BigQuery.

Was this helpful?

Still need help? Share an idea

What is the Shopify connector

Getting started with the Shopify connector

Authenticating Shopify

Configuring the Shopify connector

Tables and columns synced from Shopify

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

How the Shopify sync works

Frequently asked questions

How long does the initial sync take for Shopify?

Can I sync only some tables or columns?

What happens when Shopify's schema changes?

How do I handle GDPR or data deletion requests?

Common use cases for Shopify data

Sales reporting

Product performance

Customer analysis

Use Shopify data in your AI and BI tools

Claude

Power BI

Data Studio

Tableau

Google Sheets

Excel

Metabase

Related connectors