Play

AirPower Overview - Connect Shopify and Airtable in Minutes

Welcome to AirPower — the most advanced and fastest way to sync your Shopify data to Airtable and back.

What AirPower can do (quick tour)

  • Products, variants, collections, orders, customers: Sync core Shopify data both ways so Airtable becomes your workspace for editing and reporting.
  • Metafields: AirPower auto-detects all metafield definitions per object and lets you map them to Airtable columns (or create missing columns from inside AirPower). You can pull, edit, and push them back.
  • 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.

Best practices for your first sync

  • Let AirPower create defaults first: On a new setup, let AirPower create the tables/columns; you can refine mappings later.
  • Variants first for prices and inventory: Both pricing and inventory live on variants, so ensure Variants are mapped before configuring inventory, market prices, or B2B prices.
  • Use “Add column to table”: When a column is missing, let AirPower create it instead of switching tools.
  • Separate directions: Keep one profile for Shopify → Airtable (automatic flow in) and another for Airtable → Shopify (explicit push) so you control when edits go live.
  • Run one full backfill: Use Load all existing data once to populate Airtable; after that, updates flow automatically from Shopify.
  • 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 stand up a full Shopify ↔ Airtable workflow in minutes, then grow into advanced scenarios: bulk metafield editing, per-location inventory control, metaobject content ops, and cross-market or B2B pricing — all without leaving Airtable.