Shopify GraphQL Admin API lets you build apps and integrations that extend and enhance the Shopify admin.
This pipeline can be used to request and retrieve abandoned checkouts' data from Shopify store into your data warehouse
This pipeline can be used to request and retrieve data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve customers' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve discount codes' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve draft orders' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve inventory items and levels' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve locations' data from Shopify store into your data warehouse
This pipeline can be used to request and retrieve order risk data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve orders' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve product collections' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve product custom collections' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve product smart collections' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve products' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve shops' data from Shopify store into your data warehouse.
This pipeline can be used to request and retrieve tender transactions' data from Shopify store into your data warehouse. Tender transactions represent transactions that modify the shop’s balance since they represent money passing between the merchant and a customer.
Amazon Redshift to Shopify (Graph QL)
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a Redshift Warehouse.
2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse.
(Eg. Select * from Schema_Name.Table_Name)
*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.
*You can fetch data directly from any table / view existing in your warehouse if you don’t want to set up a data model. In that case you can skip this step and directly move to configuring your destination.
3. Configure your Data Destination - Navigate to Reverse ETL tab, click on "All Destinations" and select Shopify (Graph QL).
