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.