Connectors

/

Shopify

Shopify

Finance & Ops Analytics

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
  • 37Streams
  • 44Entities
  • 6Actions
  • 50+Destinations
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.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version4.0.0

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)

    All products associated with each collection, including smart collection matches

  • Collections (GraphQL)

  • Countries (GraphQL)

  • Custom Collections

  • Customers

  • Customer Journey Summary (GraphQL)

  • Customer Address (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

  • OAuth2.0

    Recommended

    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

Explore
All connectors
FAQ

Common questions

Do I need more than one Shopify connection?

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

Do Shopify entity actions need a sync to run first?

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.

What is ETL?

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.

What data can you extract from Shopify?

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.

How do I transfer data from Shopify?

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.

What are top ETL tools to transfer data from Shopify?

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.

What is ELT?

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.

Difference between ETL and ELT?

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