Shopify

is an ecommerce platform that has everything you need to sell online, on social media, or in person.

Features

Feature Name	Supported	Notes
		`CHECKOUT`, `COLLECTION`, `COUNTRY`, `CUSTOMER`, `CUSTOMER_SAVED_SEARCH`, `DRAFT_ORDER`, `FULFILLMENT_EVENT`, `GIFTCARD`, `INVENTORY_ITEM`, `LOCATION`, `ORDER`, `PRODUCT`, `PROVINCE`, `SHOP`, and `USER` tables only
		`CHECKOUT`, `CHECKOUT_LINE`, `ORDER`, `ORDER_LINE`, and `DRAFT_ORDER_LINE` tables
		Table level
Column hashing
		Table level
History

		`ABANDONED_CHECKOUT`, `COLLECTION`, `CUSTOMER`, `CUSTOMER_VISIT`, `DRAFT_ORDER`, `ORDER`, `PRICE_RULE`, `PRODUCT`, and `TENDER_TRANSACTION` tables
		Get the models: / ; Get the ; Supports the
Private networking

The Shopify connector supports accounts. Shopify Plus is an enterprise ecommerce platform. You can sync data from the GIFT_CARD and USER tables.

Setup guide

Follow our to connect Shopify with your destination using Fivetran connectors.

Schema information

This schema applies to all Shopify connectors.

Metafields

Fivetran supports . We support the metafields of the following tables:

COLLECTION
CUSTOMER
DRAFT_ORDER
ORDER
PRODUCT
PRODUCT_IMAGE
PRODUCT_VARIANT
SHOP

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 for Shopify's Admin API:

read_products
read_customers
read_orders
read_price_rules
read_fulfillments
read_shipping
read_draft_orders
read_inventory
read_shopify_payments_payouts
read_shopify_payments_disputes
read_content
read_themes
read_product_listings
read_locations
read_script_tags
read_assigned_fulfillment_orders
read_merchant_managed_fulfillment_orders
read_third_party_fulfillment_orders
read_analytics
read_reports
read_discounts
read_marketing_events
read_resource_feedbacks
read_translations
read_locales

NOTE: The read_gift_cards and read_users scopes are available only for Shopify Plus accounts. To sync data from the GIFT_CARD and USER tables, contact Shopify Support to enable these scopes for your account.