AirPower
Bulk edit 
Shopify collections with 
Airtable
Manual and smart collections in one Airtable table: titles, descriptions, images, sort order, and sales channels. Add or remove products by editing a linked field, then send the changes to Shopify.
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
Collection fields you can edit in Airtable
Manual and smart collections land in the same Airtable table. Most fields can be changed there and sent back to Shopify. Add only the ones you need.
| Area | Fields | Into Airtable | Back to Shopify |
|---|---|---|---|
| Collection details | Title, handle, description (HTML), and template suffix | ||
| Sort order | How products are ordered on the collection page, such as best selling, price, or manual | ||
| Image | Image URL and alt text. An Airtable attachment column can be the image source. | ||
| Sales channels | Online Store, Point of Sale, Google & YouTube, and Facebook & Instagram. Each channel is a checkbox column. Collection setup | ||
| Products in each collection | Which products belong to each manual collection, through linked Products and Collections tables Add or remove products | ||
| Shopify-only details | Collection type (manual or smart), product count, image width and height, published date, and store URL | Read only |
Collection metafields and translations have their own pages: Metafields and Translations.
From Shopify to Airtable and back
Two Syncs do the work. One brings your collections in and keeps them current. The other sends your edits to Shopify.
-
Bring your collections in
Add Collections to a Shopify to Airtable Sync and save it. Manual and smart collections both download into your table, each with its Shopify ID.
-
Edit in bulk
Rewrite descriptions, swap images, change sort order, or tick channel checkboxes across a filtered view. To change which products are in a collection, edit the linked Collections field on your product rows.
-
Click Sync now
Rows with a Shopify ID update their collection. Rows without one become new collections, as long as they have a title, and AirPower writes the new ID back.
Link Products and Collections. To add or remove products, put Products and Collections on the same Airtable to Shopify Sync, each on its own table, with linked-record fields between them. AirPower can create the link fields when you save the Sync. How it works
Shopify admin or Airtable for collections
Shopify's bulk editor and CSV files already handle some collections edits. Here is what changes when you work in Airtable.
| Task | In the Shopify admin | In Airtable with AirPower |
|---|---|---|
| Import or export a file | Shopify's CSV import and export cover products, customers, and inventory, but not collections. | Every collection is a row in one Airtable table, ready to sort, filter, and edit. |
| Bulk actions | Bulk actions on the Collections page make collections available, make them unavailable, or delete them. | Titles, descriptions, sort order, images, and sales channels are columns you edit across any number of rows. |
| Products in each collection | A product CSV export doesn't include the Collection column. | Manual collection membership syncs through linked Products and Collections tables, both ways. |
Shopify details from the Shopify Help Center: CSV files, bulk actions.
Common collection jobs
Step-by-step guides for the collection edits merchants make most often.
“We've got over 3000 SKU's, and roughly 100 metafields for our extensive product library that are all synced with our custom Airtable base.”
Collection questions
More answers in the help center, or email team@airpowersync.com.
Can I create new collections from Airtable?
Yes. A row without a Shopify ID becomes a new collection when you sync, as long as it has a title. AirPower then writes the new Shopify ID back into the row.
How do I add products to a collection in bulk?
Edit the linked Collections field on your product rows, then sync. AirPower adds and removes products in Shopify to match the links. Products and Collections must both be on the Sync, on linked tables. Step-by-step guide
Does this work for smart collections?
Smart collections come into Airtable next to manual ones, and you can edit their title, description, image, sort order, and channels. Their product rules stay in Shopify, so adding or removing products from Airtable applies to manual collections. A collection's type can't be changed after it is created.
Can I publish collections to sales channels in bulk?
Yes. In the Publishing card, send each channel from a checkbox column. Tick or untick boxes on any number of rows, then sync to publish or unpublish.
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.