Release Notes

October 2025

We unified each connector’s pre-built dbt Core*–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

We have added a new authentication method, Custom App to the setup form. You can now create and authorize a custom Shopify app directly from your Shopify admin to connect with Fivetran. For more information, see our setup guide.

September 2025

We have added the following new columns to the PRODUCT table:

• category_ancestor_ids
• category_children_ids
• category_full_name
• category_id
• category_is_archived
• category_is_leaf
• category_is_root
• category_level
• category_name
• category_parent_id

To ensure these new columns are backfilled with data, please perform a re-sync of the PRODUCT table.

We have updated the Quickstart packages for the following connectors:

• Amazon Selling Partner to version 0.2.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
• Qualtrics to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
• QuickBooks to version 0.21.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
• Recharge to version 1.1.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 20, 2025.
• Reddit Ads to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 12, 2025.
• SAP ERP on HANA to version 0.3.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.
• Shopify to version 0.22.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
• Zendesk Support to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.

August 2025

We've updated the Shopify connector schema. The new schema only applies to Fivetran accounts created on or after August 1, 2025.

We have added the following new tables:

• BUNDLE_COMPONENT
• BUNDLE_COMPONENT_OPTION_SELECTION
• BUNDLE_COMPONENT_VARIANT
• COMPANY_LOCATION
• COMPANY_LOCATION_CATALOG
• COMPANY_LOCATION_TAX_EXEMPTION
• MARKETING_EVENT
• SALE
• SALE_TAX
• SALES_AGREEMENT

We are gradually rolling out these changes to all connections. These new tables' MAR will be free until September 30, 2025.

We have updated the Quickstart packages for the following connectors:

• Amazon Ads to version 1.0.0.
• Asana to version 1.0.0.
• Facebook Pages to version 1.0.0.
• Fivetran Platform to version 2.3.0.
• GitHub to version 1.0.0.
• Greenhouse to version 1.0.0.
• Instagram Business to version 1.0.0.
• Intercom to version 1.0.0.
• Iterable to version 1.0.0.
• Jira to version 1.0.0.
• Klaviyo to version 1.0.0.
• Lever to version 1.0.0.
• LinkedIn Ad Analytics to version 1.0.0.
• LinkedIn Company Pages to version 1.0.0.
• Mailchimp to version 1.0.0.
• Marketo to version 1.0.0.
• Microsoft Advertising to version 1.0.0.
• Mixpanel to version 0.14.0.
• NetSuite SuiteAnalytics to version 1.0.0.
• Pardot to version 1.0.0.
• Pendo to version 1.0.0.
• Pinterest Ads to version 1.0.0.
• Qualtrics to version 1.0.0.
• QuickBooks to version 0.21.0.
• Recharge to version 1.0.0.
• Recurly to version 1.0.0.
• Reddit Ads to version 1.0.0.
• Sage Intacct to version 1.0.0.
• Salesforce Marketing Cloud to version 0.3.0.
• ServiceNow to version 0.5.0.
• Shopify to version 0.21.0.

July 2025

We have updated the Quickstart packages for the following connectors:

• Connectors supporting the Ad Reporting data model to version 1.17.0.
• Fivetran Platform Connector to version 2.2.2.
• GitHub to version 0.9.1.
• HubSpot to version 0.26.0.
• Iterable to version 0.14.0.
• Microsoft Dynamics 365 CRM to version 0.1.0-b2.
• Qualtrics to version 0.4.0.
• QuickBooks to version 0.20.1.
• Recharge to version 0.5.0.
• Reddit Ads to version 0.7.0.
• SAP ERP on HANA to version 0.2.1.
• Shopify to version 0.19.1.
• Stripe to version 0.19.2.
• Zendesk Support to version 0.25.0.

We have added the following new tables to store web pixels event data to analyze customer interactions. We sync all the standard Shopify web pixels events that are sent by the Shopify web pixels. For more information, see our documentation.

• ALERT_DISPLAYED_EVENT
• CART_ATTRIBUTE_EVENT
• CART_LINE_EVENT
• CART_VIEWED_EVENT
• CHECKOUT_ATTRIBUTES_EVENT
• CHECKOUT_DELIVERY_OPTION_EVENT
• CHECKOUT_DISCOUNT_APPLICATION_EVENT
• CHECKOUT_EVENT
• CHECKOUT_LINE_ITEM_DISCOUNT_ALLOCATION_EVENT
• CHECKOUT_LINE_ITEM_EVENT
• CHECKOUT_LINE_ITEM_PROPERTY_EVENT
• CHECKOUT_TRANSACTION_EVENT
• COLLECTION_VIEWED_EVENT
• COLLECTION_VIEWED_PRODUCT_VARIANT_EVENT
• PAGE_VIEWED_EVENT
• PRODUCT_ADDED_TO_CART_EVENT
• PRODUCT_REMOVED_FROM_CART_EVENT
• PRODUCT_VIEWED_EVENT
• SEARCH_RESULT_PRODUCT_VARIANT_EVENT
• SEARCH_SUBMITTED_EVENT
• UI_EXTENSION_ERRORED_EVENT

You must re-authenticate the connection to sync these tables. These syncs count towards free Monthly Active Rows (MAR) till 31st August, 2025.

We are gradually rolling out these changes for all connections.

We have removed pre_tax_price and pre_tax_price_set columns from the ORDER_LINE table.

June 2025

We have added a missing scope, read_fulfillments, to our Shopify OAuth configuration. This scope is required to register the fulfillment_events/delete webhook.

If you've already connected your Shopify account, re-authorize it to make sure that the new scope is applied.

We have removed column async_usage_count, from the DISCOUNT_REDEEM_CODE table.

May 2025

We have updated the Quickstart packages for the following connectors:

• Connectors supporting the Ad Reporting data model to version 1.14.0.
• Connectors supporting the Social Media Reporting data model to version 0.7.0.
• Google Ads to version 0.13.0.
• Instagram Business to version 0.3.0.
• Intercom to version 0.9.2.
• Mailchimp to version 0.10.1.
• QuickBooks to version 0.18.1.
• Recharge to version 0.4.0.
• Recurly to version 0.6.0.
• Shopify to version 0.19.0.
• Stripe to version 0.18.0.
• TikTok Ads to version 0.8.1.
• Zendesk Support to version 0.22.0.
• Zuora to version 0.5.0.

We have changed the sync logic for the DISCOUNT_* tables. We now sync these tables:

• Daily if the sync takes less than 30 minutes
• Weekly on Saturday if the sync takes over 30 minutes

This change affects the following tables:

• DISCOUNT_AUTOMATIC_APP
• DISCOUNT_AUTOMATIC_BASIC
• DISCOUNT_AUTOMATIC_BXGY
• DISCOUNT_AUTOMATIC_FREE_SHIPPING
• DISCOUNT_CODE_APP
• DISCOUNT_CODE_BASIC
• DISCOUNT_CODE_BXGY
• DISCOUNT_CODE_FREE_SHIPPING
• DISCOUNT_CUSTOMER_BUYS_COLLECTION
• DISCOUNT_CUSTOMER_BUYS_PRODUCT
• DISCOUNT_CUSTOMER_BUYS_PRODUCT_VARIANT
• DISCOUNT_CUSTOMER_GETS_COLLECTION
• DISCOUNT_CUSTOMER_GETS_PRODUCT
• DISCOUNT_CUSTOMER_GETS_PRODUCT_VARIANT
• DISCOUNT_CUSTOMER_SEGMENT_SELECTION
• DISCOUNT_CUSTOMER_SELECTION
• DISCOUNT_DESTINATION_SELECTION_COUNTRY
• DISCOUNT_REDEEM_CODE
• DISCOUNT_SHAREABLE_URL

April 2025

Due to upcoming changes in the Shopify API, we are making the following schema changes:

• We've discontinued the following tables:

  • DISCOUNT_CODE
  • PRICE_RULE
  • PRICE_RULE_PREREQ_PRODUCT
  • PRICE_RULE_PREREQ_VARIANT
  • PRICE_RULE_PREREQ_CUSTOMER
  • PRICE_RULE_PREREQ_CUSTOMER_SEGMENT
  • PRICE_RULE_PREREQ_COLLECTION
  • PRICE_RULE_ENT_PRODUCT
  • PRICE_RULE_ENT_VARIANT
  • PRICE_RULE_ENT_COUNTRY
  • PRICE_RULE_ENT_COLLECTION
  • PRICE_RULE_PREREQ_CUSTOMER
  • PRODUCT_IMAGE

• We've discontinued the image_id column in the PRODUCT_VARIANT table.

• We've added the following tables:

  • DISCOUNT_AUTOMATIC_APP
  • DISCOUNT_AUTOMATIC_BASIC
  • DISCOUNT_AUTOMATIC_BXGY
  • DISCOUNT_AUTOMATIC_FREE_SHIPPING
  • DISCOUNT_CODE_APP
  • DISCOUNT_CODE_BASIC
  • DISCOUNT_CODE_BXGY
  • DISCOUNT_CODE_FREE_SHIPPING
  • DISCOUNT_REDEEM_CODE
  • DISCOUNT_SHAREABLE_URL
  • DISCOUNT_DESTINATION_SELECTION_COUNTRY
  • DISCOUNT_CUSTOMER_SEGMENT_SELECTION
  • DISCOUNT_CUSTOMER_SELECTION
  • DISCOUNT_CUSTOMER_GETS_COLLECTION
  • DISCOUNT_CUSTOMER_GETS_PRODUCT
  • DISCOUNT_CUSTOMER_GETS_PRODUCT_VARIANT
  • DISCOUNT_CUSTOMER_BUYS_COLLECTION
  • DISCOUNT_CUSTOMER_BUYS_PRODUCT
  • DISCOUNT_CUSTOMER_BUYS_PRODUCT_VARIANT
  • MEDIA
  • MEDIA_IMAGE
  • EXTERNAL_VIDEO
  • VIDEO
  • MODEL_3_D
  • MEDIA_SOURCE
  • MEDIA_WANRING
  • MEDIA_FILE_ERROR
  • MEDIA_ERROR
  • PRODUCT_MEDIA
  • PRODUCT_VARIANT_MEDIA

We are gradually rolling out the changes. We will continue to sync the discontinued tables until June 30, 2025. The new tables' MAR will be free until June 1, 2025.

March 2025

We have updated the Quickstart packages for the following connectors:

• Connectors supporting the Ad Reporting data model to version 1.13.0
• Facebook Ads to version 0.8.1
• Fivetran Platform Connector to version 2.1.0
• HubSpot to version 0.22.0
• Microsoft Advertising to version 0.10.0
• Mixpanel to version 0.12.0
• NetSuite SuiteAnalytics to version 0.18.0
• Shopify to version 0.18.0
• Connectors supporting the Social Media Reporting data model to version 0.6.0
• Stripe to version 0.17.0
• Xero to version 0.8.0
• Zendesk Support to version 0.21.0

February 2025

We have updated the Quickstart packages for the following connectors:

• Ad Reporting data model connectors to version 0.5.0
• Amplitude to version 0.6.0
• Apple App Store to version 0.5.0
• App reporting data model connectors to version 0.5.0
• Asana to version 0.8.3
• HubSpot to version 0.21.0
• Sage Intacct to version 0.6.0
• Shopify to version 0.17.0
• Snapchat Ads to version 0.8.0
• Stripe to version 0.16.1
• Zuora to version 0.3.2

We have upgraded our Shopify connector from version 2024-04 to 2025-01 of the Shopify API. We are gradually rolling out this change to all existing connections.

As part of this upgrade, we have discontinued the COUNTRY and PROVINCE tables and we will stop syncing them from March 14, 2025. For more information, see Shopify API changelog.

January 2025

We have updated the Quickstart packages for the following connectors:

• Fivetran Platform Connector to version 1.11.0
• Marketo to version 0.13.1
• Mixpanel to version 0.11.0
• NetSuite SuiteAnalytics to version 0.17.1
• Qualtrics to version 0.3.0
• QuickBooks to version 0.17.1
• Salesforce to version 1.2.0
• ServiceNow to version 0.4.0
• Shopify to version 0.16.0
• Stripe to version 0.16.0
• Xero to version 0.7.0
• Zendesk Support to version 0.19.3
• Zuora to version 0.3.1

We have migrated from REST API to GraphQL for the ORDER_RISK endpoint to align with the Shopify API changes. For more information, see the Shopify documentation. As part of this migration, we have made the following schema changes:

We have added the following new tables:

• ORDER_RISK_FACT
• ORDER_RISK_ASSESSMENT
• ORDER_RISK_SUMMARY

You need to perform a re-sync to backfill historical data for the new tables. We are gradually rolling out this change to all existing connections.

We have migrated from REST API to GraphQL for the PRODUCT endpoint to align with the Shopify API changes. For more information, see the Shopify documentation. As part of this migration, we have made the following schema changes:

• We have added the following new columns to the PRODUCT table:

  • compare_at_price_range_*
  • description
  • description_html
  • featured_media_id
  • gift_card_template_suffix
  • has_only_default_variant
  • has_out_of_stock_variants
  • has_variants_that_requires_components
  • is_gift_card
  • legacy_resource_id
  • online_store_preview_url
  • max_variant_price_amount
  • max_variant_price_currency_code
  • min_variant_price_amount
  • min_variant_price_currency_code
  • requires_selling_plan
  • seo_description
  • seo_title
  • total_inventory
  • tracks_inventory

• We have removed the following columns from the PRODUCT table:

  • body_html
  • published_scope

• We have added the linked_metafield_key and linked_metafield_namespace columns to the PRODUCT_OPTION table.

• We have added the following new columns to the PRODUCT_VARIANT table:

  • available_for_sale
  • display_name
  • legacy_resource_id
  • requires_components
  • sellable_online_quantity

• We have removed the following columns from the PRODUCT_VARIANT table:

  • fulfillment_service
  • grams
  • inventory_management
  • inventory_quantity_management
  • inventory_quantity_adjustment
  • old_inventory_quantity
  • option_*
  • presentment_prices
  • requires_shipping
  • weight
  • weight_unit

• We have added the following new columns to the PRODUCT_IMAGE table:

  • alt_text
  • media_id
  • status
  • url

• We have removed the following columns from the PRODUCT_IMAGE table:

  • alt
  • created_at
  • is_default
  • position
  • src
  • updated_at
  • variant_ids

• We have added the following new columns to the INVENTORY_ITEM table:

  • duplicate_sku_count
  • harmonized_system_code
  • inventory_history_url
  • legacy_resource_id
  • measurement_id
  • measurement_weight_value
  • measurement_weight_unit
  • tracked_editable_locked
  • tracked_editable_reason
  • unit_cost_amount
  • unit_cost_currency_code

• We have removed the cost column from the INVENTORY_ITEM table.

• We have added the following new columns to the INVENTORY_LEVEL table:

  • can_deactivate
  • created_at
  • deactivation_alert
  • id

• We have removed the available column from the INVENTORY_LEVEL table.

• We have three new tables, PRODUCT_OPTION_VALUE, PRODUCT_VARIANT_OPTION_VALUE and INVENTORY_QUANTITY.

You must perform a re-sync to backfill historical data for the new columns. We are gradually rolling out this change to all existing connections.

We have changed the data type of the published_at column of the PRODUCT table from STRING to TIMESTAMP. To apply this change, you must drop the published_at column in your connection schema. We update the datatype in the next sync. You must perform a re-sync if you need to backfill the historical data for this column.

We have added a new column, order_line_id, to the RETURN_LINE_ITEM table.

We have added a new table, RETURN_SHIPPING_FEE. Previously, we synced the data to the return_shipping_fees column of the RETURN table. We are gradually rolling out this change to all existing connections.

We have added a new field, Historical sync time frame, to the connection setup form. This allows you to select how many months' worth of historical data you want to sync. For an existing connection, you can edit the connection details and set the time frame value. For more information, see our Shopify connector historical sync time frame documentation.

We apply the historical sync limit to the following tables:

• ABANDONED_CHECKOUT
• ABANDONED_CHECKOUT_LINE
• ABANDONED_CHECKOUT_SHIPPING_LINE
• ABANDONED_CHECKOUT_DISCOUNT_CODE
• ABANDONED_CHECKOUT
• ABANDONED_CHECKOUT_TAX_LINE
• ABANDONED_APPLIED_DISCOUNT
• APPLIED_GIFT_CARD
• ABANDONED_CHECKOUT_URL_TAG
• CUSTOMER_VISIT
• DRAFT_ORDER
• DRAFT_ORDER_LINE
• DRAFT_ORDER_LINE_TAX_LINE
• DRAFT_ORDER_NOTE_ATTRIBUTE
• DRAFT_ORDER_TAG
• ORDER
• ORDER_RISK
• ORDER_LINE
• ORDER_DISCOUNT_CODE
• TRANSACTION
• REFUND
• ORDER_ADJUSTMENT
• FULFILLMENT_EVENT
• FULFILLMENT
• ORDER_LINE_REFUND
• FULFILLMENT_ORDER_LINE
• TAX_LINE
• DISCOUNT_ALLOCATION
• ORDER_SHIPPING_TAX_LINE
• ORDER_SHIPPING_LINE
• ORDER_NOTE_ATTRIBUTE
• ORDER_TAG
• ORDER_URL_TAG
• DISCOUNT_APPLICATION
• FULFILLMENT_ORDER
• FULFILLMENT_ORDER_LINE_ITEM
• FULFILLMENT_ORDER_FULFILLMENT_HOLD
• TENDER_TRANSACTION

December 2024

We have updated the Quickstart packages for the following connectors:

• Fivetran Platform Connector to version 1.10.0
• Greenhouse to version 0.8.0
• LinkedIn Ad Analytics to version 0.10.0
• Mailchimp to version 0.10.0
• Marketo to version 0.12.1
• QuickBooks to version 0.17.0
• Shopify to version 0.14.0
• Stripe to version 0.15.1
• Tiktok Ads to version 0.7.0
• Twilio to version 0.4.0
• Zendesk Support to version 0.19.1

We have also updated the Quickstart package for the Ad Reporting multi-connector data model to version 1.10.0.

We have added the following new tables:

• APP
• CATALOG
• DISPUTE
• PRODUCT_PUBLICATION
• PUBLICATION
• RETURN
• RETURN_LINE_ITEM

We are gradually rolling out this change to all existing connections.

We have changed our sync strategy and now re-import all tables and their child tables (except for the ORDER table) to capture updates and deletes.

Perform a re-sync of ORDER table to fetch historical data for RETURN and RETURN_LINE_ITEM.

November 2024

We have fixed a data integrity issue in the currency column of the CUSTOMER table. If you observe null values for the column in your destination, trigger a re-sync of the CUSTOMER table.

September 2024

We have upgraded our connector to Shopify API v2024-04. As a part of the upgrade, we have added a new column, is_removed, to the ORDER_SHIPPING_LINE table. We are gradually rolling out this improvement to all existing connections.

We have added two new tables, COMPANY and COMPANY_CONTACT. We are gradually rolling out this change to all existing connections.

August 2024

We have added two new tables, ADJUSTMENT_ORDER_TRANSACTION and BALANCE_TRANSACTION.

July 2024

We have added two new columns, company_id and company_location_id, to the ORDER table. Be sure to re-sync the ORDER table to backfill the data for these columns or contact our support team to re-sync it for you.

June 2024

We have fixed an issue in our Shopify connector where we were unable to capture deletes in the METAFIELD table. This issue occurs only when you delete all the metafields in the source. We recommend that you re-sync your connector if you observe any data integrity issues. We are gradually rolling out this change to all existing connections.

March 2024

We have upgraded our Shopify connector from version 2023-04 to 2024-01 of the Shopify API. As part of the upgrade, we have deprecated the delivery_category column of the ORDER_SHIPPING_LINE table. We are gradually rolling out this change to all existing connections. For more information about the change, see Shopify API's changelog.

November 2023

We have added a new table, PAYOUT. By default, we do not sync this table. However, if you want to sync the new table, select it in the Schema tab of your connector details page. We are gradually rolling out this change to all existing connections.

We now capture deletes for the METAFIELD table.

August 2023

We have added four new tables:

• CUSTOMER_VISIT
• FULFILLMENT_ORDER
• FULFILLMENT_ORDER_FULFILLMENT_HOLD
• FULFILLMENT_ORDER_LINE_ITEM

We can now sync data from the CUSTOMER VISIT and FULFILLMENT_ORDER endpoints. By default, we exclude these new tables from the sync as syncing them might reduce the sync performance. To sync the historical data of the FULFILLMENT_ORDER table, re-sync the ORDER table.

June 2023

We have upgraded our Shopify connector from version 2022-07 to 2023-04 of the Shopify API. As part of the upgrade, we have deprecated the following columns:

• fulfillment_service column of the ABANDONED_CHECKOUT_LINE table
• fulfillment_service column of the FULFILLMENT_ORDER_LINE table
• fulfillment_service column of the ORDER_LINE table
• can_delete and lifetime_duration columns of the CUSTOMER table
• total_price_usd and processing_method columns of the ORDER table
• total_price_usd column of the DRAFT_ORDER table
• destination_location_*, fulfillment_service, and origin_location_* columns of the ORDER_LINE table

We are gradually rolling out these changes to all existing connections.

April 2023

Shopify connections created after April 17, 2023 use the Fivetran app by default. For more information, see our setup instructions. However, you can continue to create a connection using a non-Fivetran app (custom, private or another public app) by using the Fivetran REST API.

December 2022

We have upgraded our Shopify connector from version 2022-01 to 2022-7 of the Shopify API and made the following schema changes:

• We have added two new tables, CUSTOMER_SEGMENT and PRICE_RULE_PREREQ_CUSTOMER_SEGMENT.

• We have added the following new fields to the CUSTOMER table:

  • email_marketing_consent_state
  • email_marketing_consent_consent_updated_at
  • email_marketing_consent_marketing_opt_in_level

• We have deprecated the CUSTOMER_SAVED_SEARCH and PRICE_RULE_PREREQ_SAVED_SEARCH tables.

• We have deprecated the following fields from the CUSTOMER table:

  • accepts_marketing
  • accepts_marketing_updated_at
  • marketing_opt_in_level

We are gradually rolling out these changes to all existing connections.

November 2022

We have added a new column, checkout_id, to the ORDERS table.

September 2022

We have changed the new connection creation process for our Shopify connector. Shopify connections created on or after October 7, 2022, require a Shopify custom app. For more information, see our setup instructions.

We will continue to support the existing Shopify connections without a custom app.

June 2022

We have upgraded our Shopify connector from version 2021-07 to 2022-01 of the Shopify API. For more information, see Shopify's 2022-01 release notes. We have removed the value_type column from the METAFIELD table. Use the type column in place of the value_type column in your queries.

January 2022

We have released a pre-built, dbt Core-compatible data model to combine Shopify ecommerce data with data from marketing connectors. The Shopify Holistic model supports combining Shopify data with email and SMS marketing data from Fivetran's Klaviyo data model. Find the model in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

November 2021

We have added a new column, body_html, to the PRODUCT and COLLECTION tables.

September 2021

We have added a new column, type, to the METAFIELD table.

We have added a new column, template_suffix, to the COLLECTION and PRODUCT tables.

We have added two new columns, created_at and updated_at, to the ABANDONED_CHECKOUT_DISCOUNT_CODE table.

We have added two new columns, currency and metafield, to the CUSTOMER table.

We have added two new columns, tax_exemptions and tax_lines, to the DRAFT_ORDER table.

We have added two new columns, presentment_prices and inventory_quantity_adjustment, to the PRODUCT_VARIANT table.

We have added two new columns, extended_authorization_standard_authorization_expires_at and extended_authorization_extended_authorization_expires_at, to the TRANSACTION table.

We have added the following new columns to the FULFILLMENT table:

• service
• name
• receipt_authorization

The Shopify connector's priority-first syncs now fetch the most recent 15 days' worth of data. Previously, the priority fetch period was 30 days.

We have upgraded our Shopify connector from version 2020-10 to 2021-07 of the Shopify API.

August 2021

We now use webhooks to capture deletes for the following tables:

• CHECKOUT
• COLLECTION
• CUSTOMER
• CUSTOMER_SAVED_SEARCH
• DRAFT_ORDER
• FULFILLMENT_EVENT
• INVENTORY_ITEM
• LOCATION
• ORDER
• PRODUCT

July 2021

We have added the following new columns to the ORDER table:

• current_total_price
• current_total_discounts
• current_total_tax
• current_total_discounts_set
• current_total_duties_set
• current_total_price_set
• current_subtotal_price_set
• current_total_tax_set

We have deprecated the following columns from the ABANDONED_CHECKOUT_DISCOUNT_CODE table:

• discount_id
• created_at
• updated_at
• usage_count

Make sure to update your queries with the DISCOUNT_CODE table columns.

May 2021

We have added a new table, SHOP, to support Shopify's Shop resource.

We have added a new table, METAFIELD, to support Shopify's Metafield resource. We support the metafields of the following endpoints:

• COLLECTION
• CUSTOMER
• DRAFT_ORDER
• ORDER
• PRODUCT
• PRODUCT_IMAGE
• PRODUCT_VARIANT
• SHOP

By default, we sync the metafields of the CUSTOMER and SHOP endpoints.

To sync the metafields of other supported endpoints, go to the Schema tab of your connector details page and select the related *_METAFIELD options. For example, to sync the metafields of the ORDER endpoint, select ORDER_METAFIELD.

We have added a new table, ORDER_RISK. By default, we exclude the table from your syncs. On your Connector Details page, go to the Schema tab and select the table. For more information, see Shopify's Order Risk documentation.

The Shopify connector now supports table-level re-syncs.

The Shopify connector now supports table blocking for all Shopify tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables. If you want to sync a child table, you must include the parent table in the sync.

We now support table grouping in the Schema tab of your connector details page.

March 2021

The Shopify connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Shopify's priority-first syncs fetch the past 30 days' worth of data from the following tables:

• ABANDONED_CHECKOUT
• COLLECTION
• CUSTOMER
• DRAFT_ORDER
• ORDER
• PRICE_RULE
• PRODUCT
• TENDER_TRANSACTION

To learn more, see our priority-first sync documentation.

We have added the _fivetran_deleted column to the USER table.

We have added a new column, is_account_owner, to replace the account_owner column in the USER table. We will discontinue the account_owner column from the USER table after June 30, 2021. Be sure to update your queries.

We have added a new column, client_details_user_agent, to the ORDER table. See Shopify's Order documentation for more information.

February 2021

We have added the following new columns to the FULFILLMENT table:

• shipment_status
• tracking_numbers
• tracking_urls

We have added the following new columns to the FULFILLMENT_ORDER_LINE table:

• order_id
• product_id
• variant_id
• fulfillable_quantity
• fulfillment_service
• gift_card
• grams
• name
• price_set
• price
• properties
• quantity
• requires_shipping
• sku
• taxable
• title
• variant_title
• vendor

January 2021

We have expanded the public API endpoints Create a connection and Update a connection. Now you can authorize the following connections by adding the auth section to payloads:

• QuickBooks
• Shopify

We now sync the properties field as JSON objects. We have added a new column, properties replacing the property_* column in the following tables:

• ABANDONED_CHECKOUT_LINE
• DRAFT_ORDER_LINE
• ORDER_LINE

We now sync the note_attributes field as JSON objects. We have added a new column, note_attributes replacing the note_attribute__* column in the following tables:

• ABANDONED_CHECKOUT
• DRAFT_ORDER
• ORDER

We will discontinue the properties_* and note_attribute__* columns from the Shopify schema after March 31, 2021. Be sure to update your queries.

We will discontinue the ORDER_NOTE_ATTRIBUTE and DRAFT_ORDER_NOTE_ATTRIBUTE tables after March 31, 2021. Be sure to update your queries.

We have removed the default_address_id column from the CUSTOMER table. You can use the is_default column in the CUSTOMER_ADDRESS table instead. First, re-sync the CUSTOMER_ADDRESS table to populate the is_default column, then update your queries.

We have removed the is_default column from the ADDRESS table.

We have added two new columns, delivery_expectation_range_min and delivery_expectation_range_max, to the ABANDONED_CHECKOUT_SHIPPING_LINE table.

We have added the following new columns to the CUSTOMER table:

• can_delete
• lifetime_duration
• multipass_identifier

November 2020

We have upgraded our Shopify connector and made the following schema changes:

• We now sync the default product image record to the PRODUCT table.

• We have added a new table, ORDER_ADJUSTMENTS, which stores the refunded shipping costs and the differences between calculated and actual refund amounts. See Shopify's Refund Order API documentation for more information.

• We have added the following new fields to the tables below:

  • price_set to the DRAFT_ORDER_LINE table
  • type to the ORDER_DISCOUNT_CODE table
  • prerequisite_to_entitlement_purchase_* to the PRICE_RULE table
  • order_id and total_duties_set to the REFUND table
  • is_default and variant_ids to the PRODUCT_IMAGE table
  • usage_count and updated_at to the DISCOUNT_CODE table
  • variant_title and gift_card to the ABANDONED_CHECKOUT_LINE table
  • discounted_price_set and price_set to the ORDER_SHIPPING_LINE table
  • presentment_currency and total_duties to the ABANDONED_CHECKOUT table
  • acceptsMarketingUpdatedAt and marketingOptInLevel to the CUSTOMER table
  • country_code_of_origin and province_code_of_origin to the INVENTORY_ITEM table

• We have added three new fields, option1, option2, and option3, to the PRODUCT_VARIANT table.

• We have added three new fields, rules, sort_order, and disjunctive, to the CUSTOM_COLLECTION and SMART_COLLECTION tables.

• We have added the following new fields to the LOCATION table:

  • country_code
  • country_name
  • localized_country_name
  • localized_province_name
  • province_code

• We have added the following new fields to the ABANDONED_CHECKOUT_DISCOUNT_CODE table:

  • created_at
  • type
  • updated_at
  • usage_count

• We have added the following new fields to the ABANDONED_CHECKOUT_SHIPPING_LINE table:

  • delivery_expectation_range
  • delivery_expectation_type
  • original_shop_markup
  • original_shop_price
  • presentment_title

• We have added the following new fields to the ORDER_LINE table:

  • pre_tax_price_set
  • price_set
  • product_exists
  • tax_code
  • total_discount_set
  • variant_inventory_management
  • variant_title
  • destination_location_*
  • origin_location_*

• We have added the following new fields to the ORDER_LINE_REFUND table:

  • subtotal
  • subtotal_set
  • total_tax
  • total_tax_set

• We have added the following new fields to the ORDER table:

  • confirmed
  • current_total_duties_set
  • customer_locale
  • device_id
  • landing_site_ref
  • original_total_duties_set
  • payment_gateway_names
  • presentment_currency
  • reference
  • source_identifier
  • source_url
  • subtotal_price_set
  • total_discounts_set
  • total_line_items_price_set
  • total_price_set
  • total_price_usd
  • total_shipping_price_set
  • total_tax_set
  • total_tip_received

We have added a new table, TENDER_TRANSACTION. See Shopify's documentation for more information.

You can now exclude the PRICE_RULE and ORDER_ADJUSTMENT tables from the sync. On your connector details page, go to the Schema tab and deselect the tables to reduce your MAR usage.

You can now exclude the following tables from the sync to improve the connector's sync speed:

• DISCOUNT_CODE
• FULFILLMENT_EVENT
• TRANSACTION

On your connector details page, go to the Schema tab and deselect the tables you want to exclude.

September 2020

We have added two new tables, GIFT_CARD and USER to support Shopify Plus APIs.

We have replaced the COLLECT table with the COLLECTION_PRODUCT table. We have deprecated the COLLECT table because the Shopify API no longer supports the Collect endpoint.

We have added the following new fields to the tables below:

• app_id to the ORDER table
• note to the CUSTOMER table

We have released pre-built, dbt Core-compatible data models for Shopify. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

July 2020

We have deprecated the CHECKOUT and GIFT_CARD tables. We have also deprecated the following child tables of the CHECKOUT table:

• APPLIED_DISCOUNT
• CHECKOUT_DISCOUNT_CODE
• CHECKOUT_LINE
• CHECKOUT_SHIPPING_LINE
• CHECKOUT_TAX_LINE
• CHECKOUT_URL_TAG

We have deprecated the featured field from the COLLECT table because the Shopify API no longer supports it. See Shopify's documentation for more information.

May 2020

We have fixed the Product Records are not sorted! API exception by adding a check to avoid cursor overflows.

We now save the state of the CUSTOMER table at regular intervals during the historical sync to ensure data integrity. Saving the state also ensures that the sync progress is not lost in case of a sync failure.

We have added a new column, index, to the ORDER_LINE table. index gives the order of items in a Shopify order.

April 2020

You can now configure your Shopify connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

We have added a new table, DRAFT_ORDER_TAG.

We have added a new table, ABANDONED_CHECKOUT, to replace the CHECKOUT table. We have also added six new child tables to replace the following child tables:

• ABANDONED_APPLIED_DISCOUNT replaces APPLIED_DISCOUNT
• ABANDONED_CHECKOUT_DISCOUNT_CODE replaces CHECKOUT_DISCOUNT_CODE
• ABANDONED_CHECKOUT_LINE replaces CHECKOUT_LINE
• ABANDONED_CHECKOUT_SHIPPING_LINE replaces CHECKOUT_SHIPPING_LINE
• ABANDONED_CHECKOUT_TAX_LINE replaces CHECKOUT_TAX_LINE
• ABANDONED_CHECKOUT_URL_TAG replaces CHECKOUT_URL_TAG

We will discontinue the replaced tables after July 20, 2020. Be sure to update your queries with the new table names before we remove the old tables.

December 2019

We have added the following new tables:

• COUNTRY
• PROVINCE
• CUSTOMER_SAVED_SEARCH

We have added the following new tables associated with the PRICE_RULE table:

• PRICE_RULE_ENT_PRODUCT
• PRICE_RULE_ENT_VARIANT
• PRICE_RULE_ENT_COLLECTION
• PRICE_RULE_ENT_COUNTRY
• PRICE_RULE_PREREQ_COLLECTION
• PRICE_RULE_PREREQ_CUSTOMER
• PRICE_RULE_PREREQ_PRODUCT
• PRICE_RULE_PREREQ_SAVED_SEARCH
• PRICE_RULE_PREREQ_VARIANT

We have added the following columns to the PRICE_RULE table:

• allocation_limit
• prerequisite_subtotal_range
• prerequisite_quantity_range
• prerequisite_shipping_price_range
• quantity_ratio_prerequisite_quantity
• quantity_ratio_ entitled_quantity

We have added a new table, CUSTOMER_TAX_EXEMPTION, which lists the tax exemptions associated with a customer.

November 2019

We have added a new table, APPLIED_GIFT_CARD, which is a replica of the existing GIFT_CARD table. APPLIED_GIFT_CARD is the correct name for this table. We will update both tables with data for the past three months, then remove the GIFT_CARD table. Be sure to update your queries with the new name before we remove the GIFT_CARD table.

We have added a new column, test, to the ORDER table.

October 2019

We have added the following columns to the TRANSACTION table to support currency exchange rate adjustments:

• processed_at
• currency_exchange_id
• currency_exchange_adjustment
• currency_exchange_original_amount
• currency_exchange_final_amount
• currency_exchange_currency

We have added a new table, PRODUCT_IMAGE, which contains the following fields:

• id : A unique numeric identifier for the product image. (primary key)
• product_id : The ID of the product associated with the image. (foreign key, references the PRODUCT table)
• position : The order of the product image in the list. The first product image is at position 1 and is the "main" image for the product.
• width : Width dimension of the image which is determined on upload.
• height : Height dimension of the image which is determined on upload.
• created_at: The date and time when the product image was created.
• updated_at: The date and time when the product image was last modified.
• src : Specifies the location of the product image.
• alt : Alternative source if the main image does not exist.
• variant_ids : IDs of the variations of the product associated with the image.

You can read more about product images in Shopify's API documentation.

September 2019

We have added the FULFILLMENT_ORDER_LINE table to support the relationship between FULFILLMENT and ORDER_LINE tables. You will now be able to get fulfillment information for each order line, which is necessary in cases where there is more than one fulfilment per order.

August 2019

Fivetran now deletes all the records in child tables when their parent table gets an update that indicates the parent table no longer has child records.

July 2019

We have added a new table, FULFILLMENT_EVENT which represents tracking events that belong to a fulfillment of one or more items in an order. It contains the following columns:

• id
• order_id
• fulfillment_id
• address1
• city
• country
• created_at
• estimated_delivery_at
• happened_at
• latitude
• longitude
• message
• province
• shop_id
• status
• updated_at
• zip

We have a new column, quantity, to the ORDER_LINE_REFUND table.

April 2019

To integrate Shopify's multi location inventory support, we have added two new tables and added fields to four existing tables.

New tables added:

• INVENTORY_LEVEL
• INVENTORY_ITEM

New fields added:

March 2019

In order to ensure the accuracy of Order data, we now use Shopify webhooks to capture order updates.

February 2019

We have added the following new tables:

• DRAFT_ORDER
• DRAFT_ORDER_NOTE_ATTRIBUTE
• DRAFT_ORDER_LINE
• DRAFT_ORDER_LINE_TAX_LINE

January 2019

We have removed all note_attributes_* columns from the ORDER table. The new ORDER_NOTE_ATTRIBUTE table contains all note_attributes data.

The landing_site column no longer exists. The landing_site base URLs are now in the landing_site_base_url columns in the ORDER and CHECKOUT tables. Each base URL's query parameters can be found in the ORDER_URL_TAG and CHECKOUT_URL_TAG tables.

We have added four new tables:

• CHECKOUT_URL_TAG
• DISCOUNT_APPLICATION
• ORDER_URL_TAG
• DISCOUNT_ALLOCATION

We have added two new columns, total_discount and pre_tax_price, to the ORDER_LINE table.

December 2018

We have removed the ABANDONED_CHECKOUT table. All checkout data can now be found in the CHECKOUT table. Abandoned checkouts have null values in the completed_at field.

September 2018

Users now receive warnings about GDPR data deletion requests.

We have added a new column, note, to the ORDER table.

We have added two new columns, script_version_id and price_rule_id, to the APPLIED_DISCOUNT table.

August 2018

We have added two new fields, cart_token and checkout_token, to the ORDER table.

April 2018

We have added the following new tables:

• APPLIED_DISCOUNT
• CHECKOUT
• CHECKOUT_DISCOUNT_CODE
• CHECKOUT_LINE
• CHECKOUT_SHIPPING_LINE
• CHECKOUT_TAX_LINE
• APPLIED_GIFT_CARD