Connectors

/

Shopify

Data replication

Sync Shopify data anywhere.

Shopify is a cloud-based commerce platform focused on small- to medium-sized businesses and designed for ultimate scalability and reliability. Its software allows merchants to set up, design and manage businesses easily across multi-sales channels: mobile, web, social media, marketplaces, pop-up shops, and even brick-and-mortar stores. It offers a plethora of services including customer engagement, payments, marketing, and shipping tools to provide small merchants with the ability to run an online store simply and efficiently.

  • Certified
  • Generally available
  • 37 streams
  • 44 entities
  • Read & write
Sync Shopify dataRead the docs
Shopify

One connector

Everything Shopify can do in Airbyte

  • Sync to your warehouse

    Land 37 Shopify tables in 50+ destinations on a schedule you control.

  • Live entity actions

    Read, create, update and delete Shopify records at runtime through typed entity actions.

  • Context store search

    Query synced Shopify data with filters, sorting and semantic search, without spending Shopify API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

Specifications

What to know before you sync Shopify

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version4.0.0
  • Release stageGenerally available

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 10 steps

  1. First, navigate to the Shopify source connector page on Airbyte's website.
  2. Click on the "Add Source" button to begin the process of adding your Shopify credentials.
  3. In the "Connection Configuration" section, enter your Shopify store URL.
  4. Next, enter your Shopify API key and password in the appropriate fields.
  5. Click on the "Test" button to ensure that your credentials are correct and that Airbyte can connect to your Shopify store.
  6. If the test is successful, click on the "Save & Continue" button to proceed.
  7. In the "Schema Selection" section, choose which Shopify data you want to replicate in Airbyte.
  8. Click on the "Save & Continue" button to proceed.
  9. In the "Destination" section, choose where you want to send your Shopify data.
  10. Click on the "Create Connection" button to finalize the process and start replicating your Shopify data in Airbyte.

37 streams

Every table you can sync from Shopify

  • Abandoned Checkouts

  • Articles

  • Balance Transactions

  • Blogs

  • Collects

  • Collection Products (GraphQL)

  • Collections (GraphQL)

  • Countries (GraphQL)

  • Custom Collections

  • Customers

  • Customer Journey Summary (GraphQL)

  • Customer Address (GraphQL)

  • Deleted Products (GraphQL)

  • Discount Codes (GraphQL)

  • Discount Codes Sync (GraphQL)

  • Disputes

  • Draft Orders

  • Fulfillments

  • Fulfillment Orders (GraphQL)

  • Inventory Items (GraphQL)

  • Inventory Levels (GraphQL)

  • Locations

  • Metafields (GraphQL)

  • Order Agreements (GraphQL)

  • Orders

  • Order Refunds

  • Order Risks (GraphQL)

  • Pages

  • Price Rules

  • Products (GraphQL)

  • Product Images (GraphQL)

  • Product Variants (GraphQL)

  • Shop

  • Smart Collections

  • Tender Transactions

  • Transactions

  • Transactions (GraphQL)

6 actions

Supported Shopify actions

  • List

    Read live records straight from the Shopify API.

  • Get

    Fetch a single record by ID.

  • Create

    Write a new record back into Shopify.

  • Update

    Patch fields on an existing record.

  • Delete

    Remove a record.

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

Full parameter-level details live in the Shopify entity reference.

Authentication

Authenticate Shopify once

    • Recommended

    OAuth2.0

    OAuth2.0

  • API Password

    API Password Auth

Use cases

What teams build with Shopify

List all customers in my Shopify store

Show me details for a recent customer

What products do I have in my store?

List all locations for my store

Show me inventory levels for a recent location

Show me all draft orders

List all custom collections in my store

Show me details for a recent order

Show me product variants for a recent product

Create a new customer in Shopify with email test@example.com

Update a customer's first name

Create a new product called 'Summer T-Shirt'

Update a product title

Create a draft order for a customer

Complete a draft order

Set inventory quantity for a product variant at a location

Create a basic discount code for 10% off

Set a metafield on a product

Create a new page on my store

Create a new blog post

Show me orders from the last 30 days

Show me abandoned checkouts from this week

What price rules are currently active?

Show me all pages on my store

List all blog articles

Are there any open disputes?

Explore

Related connectors

SignNowFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
SimFinFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
SlackFinance & Ops AnalyticsCertified Sources cloudself-managed-enterprise
SmartwaiverFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
SquareFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
StockDataFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

No. One Shopify authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

No. Entity actions read and write through the Shopify API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Shopify's API provides access to a wide range of data related to an online store's operations. The following are the categories of data that can be accessed through Shopify's API:

1. Products: Information about the products available in the store, including their titles, descriptions, prices, images, and variants.

2. Orders: Details about the orders placed by customers, including the customer's name, shipping address, payment information, and order status.

3. Customers: Information about the customers who have created accounts on the store, including their names, email addresses, and order history.

4. Collections: Details about the collections of products that have been created in the store, including their titles, descriptions, and products included.

5. Discounts: Information about the discounts that have been created in the store, including their codes, types, and amounts.

6. Fulfillment: Details about the fulfillment of orders, including the status of each order and the tracking information for shipped orders.

7. Analytics: Data related to the store's performance, including sales reports, traffic reports, and conversion rates.

8. Storefront: Information about the store's design and layout, including the theme, templates, and customizations.

Overall, Shopify's API provides access to a comprehensive set of data that can be used to manage and optimize an online store's operations.

1. First, navigate to the Shopify source connector page on Airbyte's website.

2. Click on the "Add Source" button to begin the process of adding your Shopify credentials.

3. In the "Connection Configuration" section, enter your Shopify store URL.

4. Next, enter your Shopify API key and password in the appropriate fields.

5. Click on the "Test" button to ensure that your credentials are correct and that Airbyte can connect to your Shopify store.

6. If the test is successful, click on the "Save & Continue" button to proceed.

7. In the "Schema Selection" section, choose which Shopify data you want to replicate in Airbyte.

8. Click on the "Save & Continue" button to proceed.

9. In the "Destination" section, choose where you want to send your Shopify data.

10. Click on the "Create Connection" button to finalize the process and start replicating your Shopify data in Airbyte.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Shopify data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Shopify actions.

Try it freeTalk to sales