AirPower
How to Sync Shopify to Airtable: Set Up Your First Sync
Sync Shopify to Airtable in five steps: pick a direction, connect Airtable, choose your data, set a schedule, and start the first import of your store.
Shopify shows your products, orders, and customers one page at a time. Airtable shows them as rows you can sort, filter, group, and edit together.
Copying that data by hand means exporting CSV files and repeating the export every time something changes. The copy is out of date as soon as you make it.
A Shopify to Airtable sync copies your store’s data into an Airtable base and keeps it current. Most stores start with their product catalog. This first sync changes nothing in your store, so it is a safe place to start.
Setup has five short steps. Nothing is copied until you start the sync at the end, and you can change everything later.
Before you start
You need an Airtable account. If you don’t have one, sign up at airtable.com.
Step 1: Choose a direction
The welcome screen opens the first time you use the app.
- Open AirPower from Apps in your Shopify admin
- Under What do you want to do first?, click Start on Bring my store into Airtable
If you already have syncs, click New sync on the dashboard instead.
The New sync setup opens on Direction. From the welcome screen, Shopify to Airtable is already picked. From the dashboard, click Shopify to Airtable.
Click Continue to Airtable base to go to the next step.
Step 2: Connect Airtable and pick a base
If Airtable isn’t connected yet, this step shows two ways to connect: Connect with Airtable and Use a personal access token. Follow Connect Airtable for either one.
When you connect with Airtable’s sign-in, Airtable brings you back to your syncs. Click New sync again to continue.
Once Airtable is connected, the step lists the bases AirPower can reach. Choose where your data will live.
A base you already have
Pick it from the list. AirPower reads its tables so it can use the ones that match.
A new base
Click Create a new base instead, paste your workspace ID, and click Create base. AirPower creates a base with tables for products, variants, collections, orders, customers, and content, linked together. See Find your Airtable workspace ID.
An AirPower template
Copy one of the Airtable templates for Shopify into Airtable, then pick it from the list.
When the base you pick matches an AirPower template, the step shows This base looks like an AirPower template. Click Set it up to use the template’s tables, columns, and links. A base that AirPower creates for you matches too.
- Pick a base
- Click Continue to data
Step 3: Choose what to copy
Start from a common setup, then add or remove data types.
Product catalog
Products, variants, and collections. Best for bulk editing and catalog reports.
Orders and customers
Orders, line items, refunds, and customers. Best for reporting.
I’ll choose
Starts with nothing selected, so you can pick from the full list.
Each data type shows the table it will use. Uses your Products table means the base already has one. New table: Products means AirPower creates it, with recommended columns and links to the other tables. Click Show all data types to see every data type.
- Click Product catalog
- Click Continue to schedule
Step 4: Choose when it runs
Pick how often changes in Shopify reach Airtable.
Real-time
Changes in Shopify usually reach Airtable within a minute or two. This is the default.
Every few minutes or hours
Changes are collected and copied together, every 1, 5, or 10 minutes, or every 1 to 24 hours.
Once a day
Changes are copied at a time you pick, in your time zone.
- Pick a schedule
- Click Continue to review
Step 5: Review and start
The review lists each choice with a Change link.
- Check your choices
- Click Create sync
If your store hasn’t started its free trial, the button reads Start free trial and sync. After you click it, Shopify asks you to approve the trial, then brings you back to your syncs. Billing goes through Shopify.
What you’ll see after starting
AirPower sets up your tables and copies your store’s existing data into them. This is the first import.
The dashboard shows the import with an Importing label and a count of records copied so far. Its button opens your base in Airtable, so you can watch rows arrive. You can close the page. The import keeps going.
When the import finishes, the dashboard sync card shows Up to date. New changes in Shopify reach Airtable on their own.
Next steps
- To send edits back to your store, follow Update Shopify from Airtable
- To copy more data types, open the sync and click Add data
- To change the schedule or download data again, open the sync and click Settings
Related pages
Still stuck?
Email the team and tell us which store and which Airtable base you're working with.