AirPower
Bulk edit 
Shopify variants with 
Airtable
Every size, color, and SKU on its own Airtable row: price, compare-at price, SKU, barcode, weight, and option values. Change thousands of variants 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
Variant fields you can edit in Airtable
Each variant gets its own row on a Variants table, linked to its product. Almost every field below can be changed in Airtable and sent back to Shopify. Add only the ones you need.
| Area | Fields | Into Airtable | Back to Shopify |
|---|---|---|---|
| Options | Option 1, 2, and 3 values, such as Small, Blue, or Oak, plus the variant title and position Add new variants | ||
| Pricing | Price, compare-at price, and whether the variant is taxable Run a bulk price change | ||
| Unit price | Show unit price, total amount, and base measure with their units, such as 500 g priced per 100 g Set unit prices | ||
| Identifiers | SKU and barcode | ||
| Shipping | Weight, weight unit, and whether the variant requires shipping | ||
| Inventory settings | Whether Shopify tracks stock, inventory management, and inventory policy (keep selling when sold out or stop) | ||
| Cost and customs | Cost per item, country and province of origin, and harmonized system (HS) code | ||
| Stock by location | Available quantity at each Shopify location, one column per location on the same Variants table Inventory fields | ||
| Shopify-only details | Tax code, total inventory quantity, available for sale, the calculated unit price, and the variant's store URL | Read only |
Variant images, metafields, and market prices have their own pages: Images, Metafields, and Market prices on the Plus plan.
From Shopify to Airtable and back
Two Syncs do the work. One brings your variants in and keeps them current. The other sends your edits to Shopify.
-
Bring your variants in
Add Products and Variants to a Shopify to Airtable Sync and save it. Every variant downloads onto its own row, linked to its product, and changes made in Shopify keep arriving on their own.
-
Edit in bulk
Group by product or filter by option value, then paste, fill down, find and replace, or drive prices from a formula across thousands of rows.
-
Click Sync now
Rows with a Shopify ID update their variant. A new row linked to a product becomes a new variant, and AirPower writes the new Shopify ID back. Add variants
Give variants their own table. Use a Variants table linked to Products when products come in sizes or colors. If Products and Variants share one table, each row only holds the product's first variant, and the other variants are not visible. Compare the layouts
Shopify admin or Airtable for variants
Shopify's bulk editor and CSV files already handle some variants edits. Here is what changes when you work in Airtable.
| Task | In the Shopify admin | In Airtable with AirPower |
|---|---|---|
| Change option values | Changing Option1, Option2, or Option3 values in a product CSV deletes the existing variant IDs and creates new ones. | Each row keeps its Shopify ID, so AirPower updates the variant that's already there. |
| Variant metafields | Variant metafields aren't supported in product CSV import and export. | Variant metafields are columns on the Variants table and go back to Shopify. See Metafields. |
| Stock at several locations | The product CSV's Inventory quantity column is only for stores with a single location. | Available quantity at each location is its own column on the same Variants row. |
Shopify details from the Shopify Help Center: product CSV import, product CSV columns.
Common variant jobs
Step-by-step guides for the variant 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…”
Variant questions
More answers in the help center, or email team@airpowersync.com.
Can I add new variants from Airtable?
Yes. Add a row to the Variants table, leave the Shopify ID column blank, link it to its product row, and fill in the option values. When you sync, Shopify creates the variant and AirPower writes the new Shopify ID back into the row. Add variants
Can I change cost and customs details in bulk?
Yes. Cost per item, country and province of origin, and harmonized system code sit on the variant row next to price and SKU. Edit them across any number of rows, then sync.
Can I set unit prices from Airtable?
Yes. Each variant row can hold its total amount and base measure with their units, such as 500 g priced per 100 g, and whether shoppers see the unit price. Shopify works out the unit price from the variant's price. Unit prices
Can I edit stock on the same table?
Yes. Inventory columns live on the Variants table, one per location. Only Available quantities are sent back to Shopify. Other quantity types come into Airtable for reporting. Inventory page
Do Airtable edits reach Shopify right away?
No. Edits reach Shopify when your Airtable to Shopify Sync runs. That happens when you click Sync now, on a schedule as often as every hour or once a day, or from another tool, with the link in Settings under Start it from another tool. Schedule options
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.