AirPower Overview - Connect Shopify and Airtable in Minutes
AirPower is a two-way sync between Shopify and Airtable. It pulls your store’s data into Airtable tables and pushes edits back to Shopify, so Airtable becomes a working surface for the catalog, orders, customers, and content you already manage in Shopify.
Use it to bulk edit products and variants, manage pricing and inventory across locations, translate content for international markets, reconcile orders and payouts, or build internal workflows on top of Shopify data. Updates flow on a schedule, on demand, or automatically as changes happen in Shopify.
Each sync runs in one direction, Shopify → Airtable or Airtable → Shopify, so you decide when edits go live and which side is the source of truth for each data type.
What you can sync
Shopify objects
Products, variants, collections, images, pages, blogs, blog posts, customers, orders, order line items, fulfillments, fulfillment line items, refunds, refund line items, draft orders, payouts, balance transactions, order transactions, companies, company locations, and locations.
Metafields
Map metafield definitions per object to Airtable columns. Pull, edit, and push them back to Shopify.
Inventory
Sync per-location quantities from Shopify to Airtable across every inventory type Shopify supports: Available, Committed, Damaged, Incoming, On hand, Quality Control, Reserved, and Safety Stock. Only Available can be synced from Airtable to Shopify.
Metaobjects
Sync structured custom data types. Each metaobject type maps to its own Airtable table.
International market prices
Map fixed and relative market prices per variant. Refresh on demand and push fixed values back.
B2B catalog prices
Map B2B price lists, refresh them, and push fixed B2B prices back to Shopify.
Translations and metafield translations
Sync translated field values and metafield values by language locale or market. Pull translations from Shopify, edit them in Airtable, and push changes back.
Media and SEO
Manage product images, alt text, tags, descriptions, and SEO fields from Airtable.
Getting started: best practices
Let AirPower create defaults first
On a new setup, let the app create tables and columns automatically. Refine mappings later.
Set up Variants before prices and inventory
Pricing and inventory both live on variants. Configure Variants in Data & fields before setting up inventory, market prices, or B2B catalog prices.
Use “Create column”
When a column is missing, let the app create it rather than switching between tools.
Separate your sync directions
Keep one sync for Shopify → Airtable and another for Airtable → Shopify so you control when edits go live.
Run one full backfill
After first setup, use Settings → Download Shopify data to pull existing Shopify records into Airtable for supported data types. After that, updates flow automatically.
Set a schedule
Shopify → Airtable can run real-time, on an interval, or once per day. Airtable → Shopify can run when triggered, on an interval, once per day, or when you click Sync now on the dashboard sync card.
Set sync priority
Use Sync priority in the Schedule section to control processing order when multiple syncs run at the same time. High-priority syncs are processed first.
Filter Shopify → Airtable records
Use filtering rules to control which Shopify records flow into Airtable for supported objects: Products, Images, Pages, Orders, and Customers. Combine conditions with AND and OR logic.
Review metafields and metaobjects early
Bring custom data in at the start so your Airtable schema matches Shopify’s structure from the beginning.