January 2022link
We have released a pre-built, dbt Core-compatible data model to combine Shopify e-commerce 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 2021link
We have added a new column, body_html
, to the PRODUCT
and COLLECTION
tables.
September 2021link
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 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 2021link
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 2021link
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 2021link
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.
IMPORTANT: You may observe slow sync speeds if you sync the metafields of the non-default endpoints.
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 2021link
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 most recent 30 days 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 deprecate 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 2021link
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 2021link
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 deprecate the properties_*
and note_attribute__*
columns from the Shopify schema after March 31, 2021. Be sure to update your queries.
We will deprecate 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 2020link
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 theDRAFT_ORDER_LINE
tabletype
to theORDER_DISCOUNT_CODE
tableprerequisite_to_entitlement_purchase_*
to thePRICE_RULE
tableorder_id
andtotal_duties_set
to theREFUND
tableis_default
andvariant_ids
to thePRODUCT_IMAGE
tableusage_count
andupdated_at
to theDISCOUNT_CODE
tablevariant_title
andgift_card
to theABANDONED_CHECKOUT_LINE
tablediscounted_price_set
andprice_set
to theORDER_SHIPPING_LINE
tablepresentment_currency
andtotal_duties
to theABANDONED_CHECKOUT
tableacceptsMarketingUpdatedAt
andmarketingOptInLevel
to theCUSTOMER
tablecountry_code_of_origin
andprovince_code_of_origin
to theINVENTORY_ITEM
table
-
We have added three new fields,
option1
,option2
, andoption3
, to thePRODUCT_VARIANT
table. -
We have added three new fields,
rules
,sort_order
, anddisjunctive
, to theCUSTOM_COLLECTION
andSMART_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 2020link
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 theORDER
tablenote
to theCUSTOMER
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 2020link
We have deprecated the CHECKOUT
and GIFT_CARD
tables. We have also deprecated the following sub-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 2020link
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 2020link
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 sub-tables to replace the following sub-tables:
ABANDONED_APPLIED_DISCOUNT
replacesAPPLIED_DISCOUNT
ABANDONED_CHECKOUT_DISCOUNT_CODE
replacesCHECKOUT_DISCOUNT_CODE
ABANDONED_CHECKOUT_LINE
replacesCHECKOUT_LINE
ABANDONED_CHECKOUT_SHIPPING_LINE
replacesCHECKOUT_SHIPPING_LINE
ABANDONED_CHECKOUT_TAX_LINE
replacesCHECKOUT_TAX_LINE
ABANDONED_CHECKOUT_URL_TAG
replacesCHECKOUT_URL_TAG
We will deprecate 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 2019link
-
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 fields 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 add the new table,
CUSTOMER_TAX_EXEMPTION
, which lists the tax exemptions associated with a customer.
November 2019link
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 for 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 2019link
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 thePRODUCT
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 2019link
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 2019link
- 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 2019link
-
We have added the 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 fields: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
-
Added the
quantity
column to theORDER_LINE_REFUND
table.
April 2019link
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:
Table | Fields Added |
---|---|
PRODUCT_VARIANT |
inventory_item_id |
FULFILMENT |
location_id |
LOCATION |
legacy , active |
ORDER_LINE_ITEMS |
restock_type , location_id |
March 2019link
In order to ensure the accuracy of Order data, we now use Shopify Webhooks to capture Order Updates.
February 2019link
Added 4 new tables:
DRAFT_ORDER
DRAFT_ORDER_NOTE_ATTRIBUTE
DRAFT_ORDER_LINE
DRAFT_ORDER_LINE_TAX_LINE
January 2019link
- We have removed all
note_attributes_*
fields from theORDER
table. The newORDER_NOTE_ATTRIBUTE
table contains allnote_attributes
data.-
The
landing_site
field no longer exists. Thelanding_site
base URLs are now in thelanding_site_base_url
fields in theORDER
andCHECKOUT
tables. Each base URL’s query parameters can be found in theORDER_URL_TAG
andCHECKOUT_URL_TAG
tables. -
We have added four new tables:
CHECKOUT_URL_TAG
DISCOUNT_APPLICATION
ORDER_URL_TAG
DISCOUNT_ALLOCATION
-
We have added two new fields to the
ORDER_LINE
table:total_discount
pre_tax_price
-
December 2018link
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 2018link
Users now receive warnings about GDPR data deletion requests.
We have added a new field, note
, to the ORDER
table.
We have added two new fields, script_version_id
and price_rule_id
, to the APPLIED_DISCOUNT
table.
August 2018link
We have added two new fields, cart_token
and checkout_token
, to the ORDER
table.
April 2018link
We have added the following tables:
APPLIED_DISCOUNT
CHECKOUT
CHECKOUT_DISCOUNT_CODE
CHECKOUT_LINE
CHECKOUT_SHIPPING_LINE
CHECKOUT_TAX_LINE
APPLIED_GIFT_CARD