Sync Shopify product inventory with Airtable

In Shopify, inventory is tracked per variant and per location. Each variant carries a separate quantity at every store, warehouse, or fulfillment location, broken into types like Available, Committed, On hand, and Damaged. Even a product with no explicit variants has one underlying variant that holds these numbers.

Updating stock from the Shopify admin means clicking into each variant, switching between locations, and editing one quantity field at a time. For multi-location stores, recurring stock counts, or end-of-month adjustments, this becomes the bottleneck.

AirPower brings inventory into Airtable. Each location and quantity type becomes its own column on the Variants table, so you can review stock across your whole catalog in one grid. Edit Available quantities and push the updates back to Shopify in a single sync run.

Inventory types

AirPower supports all of Shopify’s inventory quantity types. Only Available syncs in both directions. All other types are Shopify → Airtable only.

• Available: sellable units. Bi-directional: can be pushed back to Shopify from Airtable.
• Committed: units on open orders
• Damaged: unsellable inventory
• Incoming: stock on purchase orders or transfers
• On hand: total physical units at a location
• Quality Control: units under inspection
• Reserved: units held in carts or POS
• Safety Stock: buffer inventory kept aside

To push an inventory adjustment back to Shopify, use the Available type. All other types reflect Shopify’s data and are read-only in Airtable.

Set up Shopify → Airtable inventory sync

1. Open a Shopify → Airtable sync or create a new one
2. In Connections, select your Airtable base
3. Go to Data & fields
4. Click Variants and select the Airtable table to sync to
5. Open the Inventory pane
6. Click + Add row for each inventory quantity you want to track. For each row, choose the Shopify Location, the Airtable column to store the value in, and the Inventory type (Available, On hand, Committed, etc.).
7. Click Save sync

To load your existing Shopify inventory data into Airtable:

1. Scroll to Settings
2. Click Download Shopify data
3. Find Products and click Download

Sync inventory updates from Airtable back to Shopify

Only Available quantities can be written back to Shopify.

1. Open the Airtable → Shopify sync
2. In Connections, select your Airtable base
3. Go to Data & fields
4. Click Variants
5. Select the Airtable table that contains the variant records
6. Open the Inventory pane
7. Add a row for each location you want to update. Set the Inventory type to Available and choose the Airtable column that holds your updated quantities.
8. Click Save sync

Click Sync now on the dashboard sync card to push the changes to Shopify. Edit the Available values in Airtable whenever needed, then run Sync now again to update Shopify.

Related pages

• Bulk Edit Shopify Locations with Airtable
• Auto hide out-of-stock Shopify products with Airtable