Bulk Edit Shopify Metafields in Airtable

In Shopify, metafields hold custom data on standard objects like products, variants, collections, orders, customers, blog posts, and pages. They store values that do not fit into Shopify’s built-in fields, such as care instructions, internal references, or product specifications.

Editing metafield values in the Shopify admin means opening each record’s metafields section and updating values one at a time. For larger catalogs that gets slow.

AirPower brings metafields into Airtable. Each metafield definition maps to a column on the table for the object. Edit a row to change a value. When the sync runs, Shopify reflects the change. The steps below use product metafields as an example.

Sync metafields from Shopify to Airtable

1. Open the Shopify → Airtable sync
2. Go to Data & fields
3. Click Products
4. Select the Airtable table to sync to
5. Open the Metafields pane
6. Click + Add metafield for each metafield you want to sync. Select the metafield from the dropdown. Metafields defined in your Shopify admin appear as options automatically. Then choose the Airtable column to map it to.
7. Click Save sync

To load your existing Shopify metafield values into Airtable:

1. Scroll to Settings
2. Click Download Shopify data
3. Find Products and click Download

Sync metafield edits from Airtable back to Shopify

1. Open the Airtable → Shopify sync
2. Go to Data & fields
3. Click Products
4. Select the Airtable table that contains the product records
5. Open the Metafields pane
6. Add only the metafields you want to write back. Map each to the Airtable column that holds your edits.
7. Click Save sync

Click Sync now on the dashboard sync card to push the changes to Shopify. AirPower updates the mapped metafield values for every row included in the sync.

Linking a metafield to another table

By default, metafields map to text or number columns in Airtable. To link metafield data to a separate Airtable table, map the metafield to a linked-record column instead.

When the mapped Airtable column is a linked-record column, AirPower detects the target table and column automatically. The mapping row shows Links to table with the detected target, and values are fetched from there on the next sync. No extra setup is needed.

To point the link at a different table or column, click Override next to Links to table. In Set linked table target, pick the Target table and Link column, save the target, then click Save sync.

Related pages

• Bulk Edit Shopify Metafield Translations