Shopify
Shopify is an ecommerce platform that has everything you need to sell online, on social media, or in person.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ADJUSTMENT_ORDER_TRANSACTION, APP, BALANCE_TRANSACTION, CATALOG, CHECKOUT, COLLECTION, COUNTRY, CUSTOMER, DISPUTE, CUSTOMER_SAVED_SEARCH, DRAFT_ORDER, FULFILLMENT_EVENT, GIFT_CARD, INVENTORY_ITEM, LOCATION, METAFIELD, ORDER, PAYOUT, PRODUCT, PRODUCT_PUBLICATION, PROVINCE, PUBLICATION, SHOP, and USER tables. |
| History mode | ||
| Custom data | check | CHECKOUT, CHECKOUT_LINE, ORDER, ORDER_LINE, and DRAFT_ORDER_LINE tables. |
| Data blocking | check | |
| Column hashing | ||
| Re-sync | check | |
| 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 | |
| Private networking | ||
| Authorization via API | check |
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 guide
Follow our step-by-step Shopify setup guide to connect Shopify with your destination using Fivetran connectors.
Sync overview
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_METAFIELDPROVINCERETURNRETURN_LINE_ITEMTAX_LINE
Incremental sync
We cannot track incremental updates for the following tables because the necessary parameters are not available in Shopify's API:
APPCATALOGCOUNTRYCUSTOMER_SAVED_SEARCHDISPUTELOCATIONGIFT_CARDUSERCUSTOMER_SEGMENTSSHOPMETAFIELDPAYOUTPUBLICATIONPRODUCT_PUBLICATION
As a result, we sync data for the above tables once a day. However, you can sync the latest data by syncing each table manually. See our table re-sync documentation for more information.
Sync limitations
If an update in a child object does not trigger an update in its parent object, we do not capture it until the parent object is updated. For example, if the productVariantMetafield object is updated, we do not capture the update until its parent object, productId is updated.
Schema information
This schema applies to all Shopify connectors.
To zoom, open the ERD in a new window.Metafields
Fivetran supports Shopify's Metafield resource. We support the metafields of the following tables:
COLLECTIONCUSTOMERDRAFT_ORDERORDERPRODUCTPRODUCT_IMAGEPRODUCT_VARIANTSHOP
To sync your Shopify account's metafields to your destination, you must sync the METAFIELD table. Also, sync all applicable metafields of any resources for which you have configured metafields. For example, the COLLECTION_METAFIELD or CUSTOMER_METAFIELD table.
All the metafields data for the resources you have selected will appear in the METAFIELD table in your destination following the next incremental sync. The owner column indicates the resource the metafields data refers to.
Syncing empty tables and columns
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 scopes
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_localesread_publicationsread_shopify_payments_disputesread_returns
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.