Bulk Edit Shopify Collections with Airtable
Collections group your Shopify products for the storefront and apps. Manual collections list specific products by hand, smart collections pull products in dynamically based on rules, and each collection carries its own title, description, image, sort order, and sales-channel publishing state.
Editing collections in the Shopify admin means clicking into each collection page one at a time. For seasonal merchandising, bulk descriptions, or coordinated SEO updates, that is slow.
AirPower brings collections into Airtable. Both manual and smart collections land in the same Airtable table, so you can review every collection in a grid, edit titles, descriptions, images, sort order, and publishing channels in bulk, and push the changes back to Shopify.
What Collections contain
Fields that sync in both directions include title, description (HTML), handle, collection type, image URL, image alt text, image width, image height, sort order, and template suffix.
Read-only fields pulled from Shopify include store URL and published at date.
Publication channels (Online Store, Point of Sale, Google & YouTube, Facebook & Instagram) are mapped in the Publishing pane using checkbox columns.
The Collection Type field
Collection Type identifies whether a collection is manual (custom) or smart (smart). This field is read-only in Shopify for existing collections. Do not change it after a collection has been created: Shopify does not allow converting between manual and smart collections via the API.
Set up Shopify → Airtable (download collections)
- Open or create a Shopify → Airtable sync
- In Connections, select your Airtable base
- Go to Data & fields
- Click Collections
- Select an Airtable table
- Map fields in Main fields
- Click Save sync
- Go to Settings → Download Shopify data
- Click Download next to Collections to load both custom and smart collections
Update or create collections from Airtable
With an Airtable → Shopify sync, rows with a Shopify ID update the matching Shopify collection. Rows without a Shopify ID can create a new collection if the required fields are present.
After creation, AirPower writes the new Shopify ID back to the row.
Collection images
Map image fields using Image URL, Image Alt Text, Image Width, and Image Height in Main fields. If you use an Airtable attachment column for the image source, AirPower sends the attachment URL to Shopify.
Publishing channels
Open the Publishing pane within the Collections data type to map publication channels to Airtable checkbox columns. Checking the checkbox in Airtable and syncing publishes the collection to that channel. Unchecking and syncing unpublishes it.
What you’ll see after loading data in Airtable
After the download completes, every collection from your Shopify store appears as a row in the Airtable table you mapped. AirPower fills in the Shopify ID column on each row so future updates know which Shopify collection each row points to.
The fields you mapped show the current values from Shopify: title, description, handle, image fields, sort order, and any other columns you configured. The Collection Type column indicates whether each row is a manual (custom) or smart (smart) collection.
If you mapped the Publishing pane, the checkbox columns reflect which sales channels each collection is currently published to.
From here you can filter, sort, and group collections in Airtable views to plan merchandising, bulk-edit descriptions or sort orders, or pair the table with an Airtable → Shopify sync to push the edits back to your store.
Any errors encountered during the download appear on the dashboard sync card.