Shopify Legacy

Shopify Legacy

Generally AvailableETL Sources

Extract data from this source and load it into your data warehouse.

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: 79
• Parent Streams: 24
• Sub-Streams: 55
• Supported Sync Modes: Full Refresh, Incremental

Available Streams

• abandoned_checkout (Full Refresh, Incremental)
  • abandoned_checkout_discount_code
  • abandoned_checkout_line_item
  • abandoned_checkout_line_item_custom_attribute
  • abandoned_checkout_tax_line
• balance_transaction (Full Refresh, Incremental)
  • adjustment_order_transaction
• collection (Full Refresh, Incremental)
  • collection_product
  • collection_rule
• company (Full Refresh, Incremental)
  • company_contact
• country (Full Refresh)
  • country_language
• customer (Full Refresh, Incremental)
  • customer_address
  • customer_tag
  • customer_tax_exemption
• discount_code (Full Refresh, Incremental)
  • discount_code_redeem_code
• dispute (Full Refresh, Incremental)
• draft_order (Full Refresh, Incremental)
  • draft_order_custom_attribute
  • draft_order_line_item
  • draft_order_line_item_custom_attribute
  • draft_order_line_item_tax_line
  • draft_order_shipping_line_discount_allocation
  • draft_order_shipping_line_tax_line
  • draft_order_tag
  • draft_order_tax_line
• fulfillment (Full Refresh, Incremental)
  • fulfillment_event
  • fulfillment_line_item
  • fulfillment_tracking_info
• fulfillment_order (Full Refresh, Incremental)
  • fulfillment_order_fulfillment_hold
  • fulfillment_order_line_item
  • fulfillment_order_supported_action
• gift_card (Full Refresh)
• inventory_item (Full Refresh, Incremental)
  • inventory_level
  • inventory_level_quantity
• location (Full Refresh)
• metafield (Full Refresh, Incremental)
• order (Full Refresh, Incremental)
  • order_custom_attribute
  • order_customer_journey
  • order_discount_application
  • order_discount_code
  • order_line_item
  • order_line_item_custom_attribute
  • order_line_item_discount_allocation
  • order_line_item_tax_line
  • order_payment_gateway_name
  • order_risk_assessment
  • order_risk_assessment_fact
  • order_shipping_line
  • order_shipping_line_discount_allocation
  • order_shipping_line_tax_line
  • order_tag
• payout (Full Refresh, Incremental)
• product (Full Refresh, Incremental)
  • product_media
  • product_option
  • product_tag
• product_variant (Full Refresh, Incremental)
  • product_variant_option
• refund (Full Refresh, Incremental)
  • refund_duty
  • refund_line_item
  • refund_order_adjustment
• shop (Full Refresh)
  • shop_category
  • shop_fulfillment_service
  • shop_presentment_currency
• staff_member (Full Refresh)
  • staff_member_permission
• tender_transaction (Full Refresh, Incremental)
• transaction (Full Refresh, Incremental)

Next Steps

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