AirPower
Bulk edit 
Shopify products with 
Airtable
Your whole catalog in one Airtable table: titles, descriptions, tags, status, SEO, and sales channels. Change hundreds of products at once, then send the edits to Shopify with one click.
5‑day free trial, then from $35 a month. Billed through Shopify.
Built for Shopify
Shopify admin 3.8 billion Shopify records synced since 2019 for brands like these
Product fields you can edit in Airtable
Every field below comes into Airtable, and almost all of them can be changed there and sent back to Shopify. Add only the ones you need.
| Area | Fields | Into Airtable | Back to Shopify |
|---|---|---|---|
| Catalog details | Title, handle, description (HTML), product type, vendor, tags, and template suffix | ||
| Status and category | Status, such as active, draft, or archived, and the Shopify product category | ||
| Options | Option 1, 2, and 3 names, such as Size, Color, or Material | ||
| Sales channels | Online Store, Point of Sale, Google & YouTube, Facebook & Instagram, and the published date. Each channel is a checkbox column. How publishing works | ||
| SEO | SEO title and meta description Set up SEO fields | ||
| Variants | Price, compare-at price, SKU, barcode, weight, inventory policy, and cost, on a linked Variants table Variant fields | ||
| Images | Product and variant images, from an Images table linked to your products or an upload column How images work | ||
| Store link | The product's page URL on your store | Read only |
Metafields, translations, and collection membership have their own pages: Metafields, Translations, and Collections.
From Shopify to Airtable and back
Two Syncs do the work. One brings your catalog in and keeps it current. The other sends your edits to Shopify.
-
Bring your catalog in
Add Products and Variants to a Shopify to Airtable Sync and save it. Every product downloads into your tables, and changes made in Shopify keep arriving on their own.
-
Edit in bulk
Filter a view, then paste, fill down, find and replace, or drive prices from a formula across hundreds of rows.
-
Click Sync now
Rows with a Shopify ID update their product. Rows without one become new products, and AirPower writes the new ID back.
One table or two. Keep variants on their own linked table when products come in sizes or colors, or on the same row as the product if each product has a single variant. Compare the layouts
Shopify admin or Airtable for products
Shopify's bulk editor and CSV files already handle some products edits. Here is what changes when you work in Airtable.
| Task | In the Shopify admin | In Airtable with AirPower |
|---|---|---|
| Import changes from a file | A product CSV import can't be canceled once it starts, and blank cells in optional columns overwrite existing values as blank. | Only the columns you add to the Sync are sent, so fields you leave out stay as they are. You review every change in Airtable before clicking Sync now. |
| Collections | A product CSV export doesn't include the Collection column. | Collection membership syncs on linked Products and Collections tables. See Collections. |
| Keep the catalog current | A CSV export is a snapshot of the moment you download it. | Changes made in Shopify keep arriving in Airtable on their own. |
Shopify details from the Shopify Help Center: product CSV import, product CSV columns.
Common product jobs
Step-by-step guides for the edits merchants make most often.
“We run a furniture e-commerce with ~7,400 variants and use AirPower as the backbone of our Airtable PIM…”
Product questions
More answers in the help center, or email team@airpowersync.com.
Can I create new products from Airtable?
Yes. A row without a Shopify ID becomes a new product when you sync, as long as it has a title. AirPower then writes the new Shopify ID back into the row.
Do variants need their own table?
No. Use separate, linked Products and Variants tables when products come in sizes or colors. If each product has a single variant, keep both on one row. On a single row you only see the first variant.
Can I change status and sales channels in bulk?
Yes. Status is a regular field, and each sales channel, such as Online Store or Point of Sale, syncs to a checkbox column. Change any number of rows, then sync.
Can I sync only some products?
Yes. For Airtable to Shopify, choose an Airtable view and only its rows are sent. On the Plus plan, filters decide which Shopify products come into Airtable, for example by tag or vendor.
Related features
Try AirPower on your own store
Install it from the Shopify App Store, connect an Airtable base, and run your first Sync today. Free for 5 days.