Welcome to AirPower — the fastest way to sync your Shopify data to Airtable and back.
Shopify objects
Sync products, variants, collections, images, pages, blogs, blog posts, customers, orders, order line items, refunds, draft orders, payouts, order transactions, balance transactions, and locations.
Metafields
Auto-detect all metafield definitions per object and map them to Airtable columns (or create missing columns directly). Pull, edit, and push them back to Shopify.
Inventory
Track per-location quantities, pull all Shopify inventory types, and push Available quantities back to Shopify.
Metaobjects
Auto-generate Airtable tables per metaobject type, with every field ready to edit or create new instances.
International market prices
Map fixed and relative market prices per variant, refresh them on demand, and push fixed values back.
B2B prices
Map B2B price lists, refresh them, and push fixed B2B prices back to Shopify.
Media and SEO
Manage images, tags, descriptions (including rich text), and SEO title/description straight from Airtable.
Let AirPower create defaults first
On a new setup, let the app create the tables and columns automatically. You can refine your mappings later.
Set up variants before prices and inventory
Both pricing and inventory live on variants, so make sure Variants are mapped before configuring inventory, market prices, or B2B prices.
Use “Add column to table”
When a column is missing, let the app create it instead of 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
Use Advanced and Load Existing Shopify Data to backfill existing Shopify records into Airtable. After that, updates flow automatically from Shopify.
Set a schedule
Choose when the sync runs. Shopify → Airtable can run immediately, periodically, or once per day. Airtable → Shopify starts manually when you trigger it.
Set sync priority
Use Sync Priority to control run order when you have multiple syncs. Higher-priority syncs run first.
Filter Shopify → Airtable tables
Use filtering rules to control what flows from Shopify into your Airtable table for supported objects like Products, Images, Inventory, Pages, Orders, and Customers. Combine multiple conditions with AND and OR logic to build complex rules.
Review metafields and metaobjects early
Bring them in at the start so your Airtable schema matches Shopify’s structure and custom data.
With these steps, you can set up a complete Shopify ↔ Airtable workflow in minutes, then expand into advanced scenarios like bulk metafield editing, per-location inventory control, metaobject content management, and cross-market or B2B pricing — all without leaving Airtable.