Shopify

Generally AvailableETL Sources

Extract data from applications, files, databases, and events.

Features

Feature Name	Supported	Notes
OAuth	✓	OAuth 2.0 authentication
Access Token	✓	API key or access token
Full Refresh	✓	Complete data reload
Incremental Sync	✓	Only new/updated records
Distribution Stage	✓	Generally Available
Dynamic Streams	—
Start Date	✓	Streams support threshold date
Column Hashing	—

Sync Overview

Total Streams: 157
Parent Streams: 49
Sub-Streams: 108
Supported Sync Modes: Full Refresh, Incremental

Available Streams

abandoned_checkout (Full Refresh, Incremental)
- abandoned_checkout_discount_code
- abandoned_checkout_line
- abandoned_checkout_line_custom_attribute
- abandoned_checkout_tax_line
balance_transaction (Full Refresh, Incremental)
- adjustment_order
catalog (Full Refresh) (Supports Re-import)
- app
- company_location_catalog
collection (Full Refresh, Incremental)
- collection_product
- collection_rule
company (Full Refresh, Incremental)
- company_contact
company_location (Full Refresh, Incremental)
- company_location_tax_exemption
country (Full Refresh) (Supports Re-import)
- country_language
customer (Full Refresh, Incremental)
- customer_address
- customer_tag
- customer_tax_exemption
customer_segment (Full Refresh) (Supports Re-import)
discount_automatic_app (Full Refresh, Incremental)
discount_automatic_basic (Full Refresh, Incremental)
- discount_customer_gets_collection
- discount_customer_gets_product
- discount_customer_gets_product_variant
discount_automatic_bxgy (Full Refresh, Incremental)
- 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_automatic_free_shipping (Full Refresh, Incremental)
- discount_destination_selection_country
discount_code_app (Full Refresh, Incremental)
- discount_customer_segment_selection
- discount_customer_selection
- discount_redeem_code
- discount_shareable_url
discount_code_basic (Full Refresh, Incremental)
- discount_customer_gets_collection
- discount_customer_gets_product
- discount_customer_gets_product_variant
- discount_customer_segment_selection
- discount_customer_selection
- discount_redeem_code
- discount_shareable_url
discount_code_bxgy (Full Refresh, Incremental)
- 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_redeem_code
- discount_shareable_url
discount_code_free_shipping (Full Refresh, Incremental)
- discount_customer_segment_selection
- discount_customer_selection
- discount_destination_selection_country
- discount_redeem_code
- discount_shareable_url
discount_customer_buys_collection (Incremental)
discount_customer_buys_product (Incremental)
discount_customer_buys_product_variant (Incremental)
discount_customer_gets_collection (Incremental)
discount_customer_gets_product (Incremental)
discount_customer_gets_product_variant (Incremental)
discount_customer_segment_selection (Incremental)
discount_customer_selection (Incremental)
discount_destination_selection_country (Incremental)
discount_redeem_code (Incremental)
discount_shareable_url (Incremental)
dispute (Full Refresh, Incremental)
draft_order (Full Refresh, Incremental)
- draft_order_custom_attribute
- draft_order_line
- draft_order_line_custom_attribute
- draft_order_line_tax_line
- draft_order_tag
- draft_order_tax_line
fulfillment (Full Refresh, Incremental)
- fulfillment_event
- fulfillment_line
- fulfillment_tracking_info
fulfillment_order (Full Refresh, Incremental)
- fulfillment_order_fulfillment_hold
- fulfillment_order_line
- fulfillment_order_supported_action
gift_card (Full Refresh) (Supports Re-import)
inventory_item (Full Refresh, Incremental)
- inventory_level
- inventory_quantity
location (Full Refresh) (Supports Re-import)
marketing_event (Full Refresh, Incremental)
metafield (Full Refresh, Incremental)
order (Full Refresh, Incremental)
- customer_visit
- discount_allocation
- discount_application
- order_custom_attribute
- order_discount_code
- order_line
- order_line_custom_attribute
- order_line_tax_line
- order_merchant_editable_errors
- order_payment_gateway_name
- order_risk_assessment
- order_risk_fact
- order_risk_summary
- order_shipping_line
- order_shipping_line_tax_line
- order_tag
payout (Full Refresh, Incremental)
- payout_balance
product (Full Refresh, Incremental)
- external_video
- media
- media_error
- media_file_error
- media_image
- media_source
- media_warning
- model_3d
- product_media
- product_option
- product_option_value
- product_tag
- video
product_variant (Full Refresh, Incremental)
- product_variant_media
- product_variant_option_value
publication (Full Refresh) (Supports Re-import)
- product_publication
refund (Full Refresh, Incremental)
- order_adjustment
- refund_line
- refund_shipping_line
return (Full Refresh, Incremental)
- return_exchange_line
- return_exchange_line_order_line
- return_line
- return_shipping_fee
sales_agreement (Full Refresh, Incremental)
- sale
- sales_tax
shop (Full Refresh) (Supports Re-import)
- fulfillment_service
staff_member (Full Refresh) (Supports Re-import)
tender_transaction (Full Refresh, Incremental)
transaction (Full Refresh, Incremental)

Next Steps

Setup Guide — Learn how to connect Shopify
API Configuration — View schema and API details
Release Notes — See recent changes