The Shopify Reverse ETL connector enables streaming data from a user determined warehouse to the Shopify platform in an automated manner.
This sync can be used to upload customers' details from your data warehouse to the Shopify platform.
This sync can be used to upload inventory items' details from your data warehouse to the Shopify platform.
This sync can be used to upload orders' details from your data warehouse to the Shopify platform.
This sync can be used to upload products' details from your data warehouse to the Shopify platform.
MySQL to Shopify
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a MySQL 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.
3. Configure your Data Destination - Navigate to Destinations tab and select Shopify.