Shopify link
Updated November 16, 2023
Shopify is an ecommerce platform that has everything you need to sell online, on social media, or in person.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | CHECKOUT, COLLECTION, COUNTRY, CUSTOMER, CUSTOMER_SAVED_SEARCH, DRAFT_ORDER, FULFILLMENT_EVENT, GIFT_CARD, INVENTORY_ITEM, LOCATION, ORDER, PRODUCT, PROVINCE, SHOP, and USER tables only |
| Custom data | check | CHECKOUT, CHECKOUT_LINE, ORDER, ORDER_LINE, and DRAFT_ORDER_LINE tables |
| Data blocking | check | Table level |
| Column hashing | ||
| Re-sync | check | Table level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | check | ABANDONED_CHECKOUT, COLLECTION, CUSTOMER, CUSTOMER_VISIT, DRAFT_ORDER, ORDER, PRICE_RULE, PRODUCT, and TENDER_TRANSACTION tables |
| Fivetran data models | check | Get the models: source / transform; Get the Shopify Holistic model; Supports Quickstart data models |
| Private networking |
The Shopify connector supports Shopify Plus accounts. Shopify Plus is an enterprise ecommerce platform. You can sync data from the GIFT_CARD and USER tables.
Setup guidelink
Follow our step-by-step Shopify setup guide to connect Shopify with your destination using Fivetran connectors.
Sync overviewlink
We use hard deletes to remove records from the following tables:
ABANDONED_CHECKOUT_DISCOUNT_CODEABANDONED_CHECKOUT_LINEABANDONED_CHECKOUT_SHIPPING_LINEABANDONED_CHECKOUT_URL_TAGCOLLECTION_METAFIELDCUSTOMER_ADDRESSCUSTOMER_METAFIELDCUSTOMER_TAGCUSTOMER_TAX_EXEMPTIONDISCOUNT_ALLOCATIONDISCOUNT_APPLICATIONDRAFT_ORDER_LINEDRAFT_ORDER_LINE_TAX_LINEDRAFT_ORDER_METAFIELDDRAFT_ORDER_NOTE_ATTRIBUTEDRAFT_ORDER_TAGFULFILLMENT_ORDERFULFILLMENT_ORDER_FULFILLMENT_HOLDFULFILLMENT_ORDER_LINE_ITEMORDER_DISCOUNT_CODEORDER_LINEORDER_METAFIELDORDER_NOTE_ATTRIBUTEORDER_RISKORDER_SHIPPING_LINEORDER_SHIPPING_TAX_LINEORDER_TAGORDER_URL_TAGPRICE_RULE_ENT_COLLECTIONPRICE_RULE_ENT_COUNTRYPRICE_RULE_ENT_PRODUCTPRICE_RULE_ENT_VARIANTPRICE_RULE_PREREQ_COLLECTIONPRICE_RULE_PREREQ_CUSTOMERPRICE_RULE_PREREQ_CUSTOMER_SEGMENTPRICE_RULE_PREREQ_PRODUCTPRICE_RULE_PREREQ_VARIANTPRODUCT_IMAGEPRODUCT_IMAGE_METAFIELDPRODUCT_METAFIELDPRODUCT_TAGPRODUCT_VARIANTPRODUCT_VARIANT_METAFIELDPROVINCETAX_LINE
Schema informationlink
This schema applies to all Shopify connectors.
To zoom, open the ERD in a new window.Metafieldslink
Fivetran supports Shopify's Metafield resource. We support the metafields of the following tables:
COLLECTIONCUSTOMERDRAFT_ORDERORDERPRODUCTPRODUCT_IMAGEPRODUCT_VARIANTSHOP
Syncing empty tables and columnslink
The Shopify connector doesn't support the creation of empty tables and columns in your destination.
We create a table in the destination only if we can retrieve the table data from the source. If Shopify doesn’t return data for the source table, we don’t create the table in your destination.
Shopify API access scopeslink
IMPORTANT: The API access scopes listed in this section are applicable only for the Shopify connectors created using a non-Fivetran app (custom, private or another public app).
Fivetran requires the following authenticated access scopes for Shopify's Admin API:
read_productsread_customersread_ordersread_price_rulesread_fulfillmentsread_shippingread_draft_ordersread_inventoryread_shopify_payments_payoutsread_shopify_payments_disputesread_contentread_themesread_product_listingsread_locationsread_script_tagsread_assigned_fulfillment_ordersread_merchant_managed_fulfillment_ordersread_third_party_fulfillment_ordersread_analyticsread_reportsread_discountsread_marketing_eventsread_resource_feedbacksread_translationsread_locales
NOTE: The
read_gift_cardsandread_usersscopes are available only for Shopify Plus accounts. To sync data from theGIFT_CARDandUSERtables, contact Shopify Support to enable these scopes for your account.