AirPower
Sync Page Overview: Map Shopify Fields to Airtable Columns
Tour the AirPower sync page: connect Shopify fields to Airtable columns with live examples, add data types and fields, review errors, and change sync settings.
A sync decides which Shopify fields reach which Airtable columns. A product alone has dozens of fields, from title and tags to SEO and sales channels.
Matching them one at a time against a list of column names makes it hard to tell what each column will hold. Mistakes show up only after the data lands in Airtable.
The AirPower sync page shows each data type as a tab, laid out like Shopify’s own product or order page. Every field shows a real example from your store next to the Airtable column it uses.
Open a sync page
Click a sync’s name or Edit on its dashboard sync card. A new sync opens here after setup.
The header holds the sync’s controls.
- Your syncs: back to the dashboard
- Name: click the pencil to rename the sync
- Status: shown when there is something to know, such as Needs attention
- Sync now: Airtable to Shopify syncs only
- Open in Airtable: opens the base at the table of the tab you’re on
- ⋯: Pause or Resume, Duplicate, Turn off or Turn on, and Delete
Data tabs
Each data type in the sync has its own tab, with the number of fields it syncs. When the tabs don’t fit, the rest fold into a tab that counts them, such as 3 more. Errors and Settings stay on the right.
The top of each data tab explains what the tab covers.
Example record
One of your three most recent records in Shopify, such as a product. Use the arrows to switch between them. Products, variants, collections, orders, customers, discounts, customer segments, inventory transfers and shipments, returns, refunds, fulfillments, files, locations, pages, blogs, blog posts, and metaobject entries show examples. Other data types list their fields without one.
Into or From
The Airtable table the tab uses. Click the table name to pick another table. Airtable to Shopify syncs also show every row, which you can change to one Airtable view.
Field count
A line such as 19 parts go into Airtable says how many fields sync. Columns the sync doesn’t use are left alone.
Only what syncs and Whole product
Switch between the fields the sync uses and every field Shopify has for the record. Airtable to Shopify syncs label the first view Only what’s sent.
Add more or Send more
Opens the list of fields to add. See Add fields.
Fields and columns
Fields are grouped the way Shopify’s own page groups them, such as Media, Variants, Search engine listing, Status, Publishing, and Product organization.
Each row shows the example value on the left and its column on the right. Shopify to Airtable syncs say Syncs to, and Airtable to Shopify syncs say Comes from. A legend above the fields explains the colors, such as Syncs to a column, Needs a look, and Changes when you save.
Click a row to change its column.
The dialog describes the Shopify field, with an example, and shows the column it uses now. Under Or use another column, pick a Recommended new column, which is added when you save, or search your table’s columns. Stop sending to Airtable removes the field from the sync. Click Done to close the dialog.
Behind the scenes holds fields that aren’t on Shopify’s page, such as Shopify ID, Created, and Store URL. The Shopify ID is required, because it is how AirPower finds each record’s row. See Set up the Shopify ID column.
To take a data type out of the sync, click the link at the bottom of its tab, such as Remove products from this sync.
Add fields
Add more opens the fields Shopify has for the data type, grouped into packs. Each pack matches a card on Shopify’s page, such as Basics, Price, Stock, Shipping, Sales channels, or Dates and IDs.
- Click Add more
- Tick the fields you want, or search for one, such as barcode or weight
- Click the add button, which counts your picks, such as Add 2 fields
New fields take effect when you save the sync.
Filter which records sync
Shopify to Airtable syncs show a card such as Which products sync under the tab summary. With AirPower Plus, set rules that Only sync or Don’t sync matching records. See Filter Shopify records.
Add a data type
Click Add data next to the tabs to add a data type. It gets its own tab, where you choose its table and fields. Data types already in the sync are marked In this sync.
Errors tab
The Errors tab lists every error, newest first. Each error names the record, with a link to it, and gives the reason.
Fix the cause in Airtable or Shopify. Dismiss these errors hides the list once you’ve fixed it, and Show more errors loads older ones. See Shopify-Airtable sync errors.
Settings tab
Settings holds everything that isn’t about fields, in five sections: When it syncs, Connection, Download data, Linked tables, and Manage. Click a section name on the left to jump to it.
When it syncs
The schedule, with the same choices as the setup. Priority when syncs overlap sets Normal or High, which goes first when several syncs use your store at once. Airtable to Shopify syncs also show Start it from another tool, a trigger link with a Copy button.
Connection
The Sync name, your store, and your base. Refresh tables and columns reads the base again after you change it in Airtable, and the base list next to it points the sync at another base. How rows are matched names the Shopify ID column.
A sync’s direction can’t be changed. To sync the other way, create a new sync.
Download data
Shopify to Airtable only. Copies records from Shopify again, one data type at a time, with each row’s Download button. Rows already in Airtable are updated, not duplicated. See Download Shopify data.
Linked tables
The linked-record columns that connect rows across your tables, such as Products → Variants. AirPower finds each column on its own. When it picks the wrong one, choose the right column, and the link shows Picked by you. The switch turns a link on or off. See Linked-record columns.
Manage
Duplicate, Clear errors, Cancel waiting changes, Turn off or Turn on, and Delete. Each row says what the action does.
Save your changes
Changes on the sync page wait until you save them. Shopify’s save bar appears at the top of the admin with Discard and Save.
On a Shopify to Airtable sync, when a change adds or changes fields, the Save changes panel opens after you click Save. It offers to download the changed data again, so rows already in Airtable get the new columns. Anything you leave unticked fills in the next time it changes in Shopify. An Airtable to Shopify sync saves straight away, without the panel.
- Tick the data to download again
- Click Save changes
Click Keep editing to go back without saving.
Related pages
Still stuck?
Email the team and tell us which store and which Airtable base you're working with.