Bulk Edit Shopify Customers with Airtable
Each Shopify customer record carries contact details, addresses, marketing consent, tags, internal notes, and spend rollups. Working with that list at scale in the Shopify admin means clicking into each customer to edit a tag, add a note, or update an address.
AirPower brings your full Shopify customer list into Airtable. Download existing customers into a table you control, update profiles in bulk through Airtable views and edits, or create new customers in Shopify directly from Airtable rows.
What Customers contain
Fields that sync in both directions include email, first name, last name, phone, tags, and note.
Read-only fields pulled from Shopify include store URL, created at, verified email, accepts marketing, total spent, orders count, tax exempt, and address fields (first name, last name, company, line 1, line 2, city, province, country, ZIP, and phone for both Address 1 and the default address).
Set up Shopify → Airtable (download customers)
- Open or create a Shopify → Airtable sync
- In Connections, select your Airtable base
- Go to Data & fields
- Click Customers
- Select an Airtable table
- Map fields in Main fields
- Click Save sync
- Go to Settings → Download Shopify data
- Click Download next to Customers
If Orders is also configured, customer rows can link to related order rows.
Update or create customers from Airtable
With an Airtable → Shopify sync, rows with a Shopify ID update the matching Shopify customer. Rows without a Shopify ID create a new customer in Shopify. After creation, AirPower writes the new Shopify ID back to the row.
For reliable customer creation, map at least one of Email or Phone.
What you’ll see after saving
After the download completes, customer rows appear in the Airtable table with Shopify IDs written by AirPower. For Airtable → Shopify syncs, updated or newly created customers appear in the Shopify admin with the Shopify ID filled back into Airtable. Any sync errors appear on the dashboard sync card.