Shopify is in closed alpha! If you'd like early access, send us a note.
This guide walks you through setting up Shopify on Sync Inc.
In just a couple of minutes, you'll have a Postgres database with all your Shopify data, syncing in real-time.
First, connect to your Shopify store using your Shopify credentials.
Step 1: Create a new Sync Inc account at https://app.syncinc.so/signup.
Step 2: Select Shopify as the platform you want to sync.
Step 3: Enter your
`.myshopify.com` store domain and click the Connect to Shopify button.
You can find your
`.myshopify.com`domain from the Domains page of your Shopify admin.
Step 4: Login to your Shopify account and then approve the Sync Inc Shopify app:
Step 5: Select the destination database you want to sync your data to. By default, we'll sync to a new Postgres Database we host for you. Or, we can sync to a new schema in a database you've created with Sync Inc or that you host:
Step 6: Click Create.
After you click Create, we'll immediately connect to your Shopify store and begin back filling all your data.
As soon as your database is provisioned, you can connect to it and start querying.
If you chose to sync your data to a Sync Inc provisioned database, then your database is hosted on AWS RDS. If you chose to sync to a database you are hosting, then you or a database admin will know the details of your hosting.
For this setup guide, we'll use TablePlus as an example.
Step 1: Download and install TablePlus from https://tableplus.com/.
Step 2: Open TablePlus and click Create a new connection...
Step 3: Click the Import from URL button.
Step 4: Copy and paste the Connect URL from Sync Inc into the Connection URL in TablePlus then click Import.
Step 5: Then name your TablePlus connection and click Create.
You'll now see all your Shopify data represented in Postgres. To start querying, click the SQL button and write your first statement:
selectcustomer.id,count(order.id),sum(order.total_price)fromcustomerleft join public.orderon order.customer_id = customer.idgroup by customer.id;