Bulk Edit Shopify Products and Variants with Airtable
In Shopify, a product holds catalog-level data: title, description, vendor, tags, status, and publishing channels. The variants hold per-SKU data: option values, price, compare-at price, weight, barcode, inventory policy, and tax setup. A product can have one variant or hundreds.
Editing the catalog in the Shopify admin means opening one product page at a time, then clicking into each variant to change a price or update an option value. For bulk price changes, vendor migrations, tag clean-ups, or quarterly catalog audits, that scales poorly.
AirPower brings products and variants into Airtable. Use two linked tables for stores with multi-variant products, or collapse them onto a single combined table for stores that do not really use variants. Either way, you review the catalog in a grid, edit in bulk through Airtable views, and push every change back to Shopify in one sync run. Inventory, market prices, and B2B catalog prices all hang off Variants so they share the same workflow.
What Products and Variants contain
Products hold catalog-level data. Available fields include title, handle, description (HTML), product type, vendor, status, tags, template suffix, option names (Option 1 Name, Option 2 Name, Option 3 Name), published at date, product category, and store URL. Publishing channels (Online Store, Point of Sale, Google & YouTube, Facebook & Instagram) are mapped in the Publishing pane.
Variants hold per-SKU data.
Writable variant fields (Airtable → Shopify): option values (Option 1, Option 2, Option 3), title, SKU, barcode, weight, weight unit, price, compare at price, position, taxable, inventory management, inventory policy, cost, country code of origin, harmonized system code, requires shipping, and tracked.
Read-only variant fields (Shopify → Airtable only): tax code.
A product can have one or many variants.
Products and variants on one table or two
AirPower supports two layouts for the Variants data type.
Separate Products and Variants tables Each variant gets its own row in the Variants table and links back to its parent product row in the Products table. Use this when your store has multi-variant products such as sizes, colors, or materials, so every SKU has somewhere to live.
Products and variants on the same table Products and variants share a single row. AirPower writes product-level and variant-level fields into the same row, so each row represents both the product and its first variant.
The combined layout is useful when your store does not really use variants. Every Shopify product has at least one variant by default, so a single row per product still captures the SKU detail. From the combined row you can only see and edit the first variant. If a product has more than one variant in Shopify, the others are not visible in the combined table.
To pick a layout, point both Products and Variants at the same Airtable table for combined, or at two different tables for separate.
How the Shopify ID column works
AirPower identifies existing Shopify records using the Shopify ID column configured in Connections → Advanced settings. New syncs default to a column named Shopify Id.
- Rows with a Shopify ID update the existing Shopify record
- Rows without a Shopify ID create a new Shopify record when the object supports creation. After creation, AirPower writes the new Shopify ID back to that row.
Set up Shopify → Airtable (download products)
- Open or create a sync
- Set the sync direction to Shopify → Airtable
- In Connections, select your Airtable base
- Go to Data & fields
- Click Products, select an Airtable table, and map fields in Main fields
- Click Variants, select an Airtable table, and map fields in Main fields
- Click Save sync
- Go to Settings → Download Shopify data
- Click Download next to Products to load existing product and variant data into Airtable
Set up Airtable → Shopify (push changes)
- Open or create a sync
- Set the sync direction to Airtable → Shopify
- In Connections, select your Airtable base
- Go to Data & fields
- Configure Products and Variants with an Airtable table and field mappings each
- Click Save sync
- Edit rows in Airtable
- Click Sync now on the dashboard sync card
Inventory, market prices, and B2B catalog prices
Inventory quantities, international market prices, and B2B catalog prices are all configured from within the Variants data type. Open Variants in Data & fields, then use the Inventory, International market prices, or B2B catalog prices panes. Separate Inventory, Market Prices, or B2B Catalog Prices rows in the object grid redirect to Variants when clicked.
What you’ll see after saving
After the first download, product rows appear in the Products table and variant rows appear in the Variants table, each with a Shopify ID written by AirPower. Edits synced back to Shopify show the updated values in the Shopify admin. Any sync errors appear on the dashboard sync card.