Skip to main content

Hi, I am pretty new to this and not a developer. We are using Airtable for our product database for our Shopify store, and have Airpower as the sync between them. This works pretty good, but there is one major thing we need that Airpower does not support.

We need the number of "committed" inventory of the products to sync from Shopify into Airtable in real-time. Right now, the Airpower Inventory sync only brings the "available" number through, but both are required for us, and we need the data to by syncing constantly so it's up to date.

Is this something we could use a webhook for? Or is there a simpler process?

Did you ask the Airpower team to see if they can add that feature?

If they can't do it, my guess is that you should be able to set that up with Make's Shopify integrations & automations for Airtable. (And yes, if Shopify provides that information via a webhook, you can always use Make's custom webhooks to receive that information and send it into Airtable.)

However, there is quite a learning curve with Make, so I provide some Make training resources in this thread.

if you can confirm with Make's support team that this is possible with their Shopify modules, then I am available for hire to help you set this up. I am one of the top Airtable & Make experts, and you can feel free to contact me through my website: Airtable Consultant — ScottWorld

Did you ask the Airpower team to see if they can add that feature?

If they can't do it, my guess is that you should be able to set that up with Make's Shopify integrations & automations for Airtable. (And yes, if Shopify provides that information via a webhook, you can always use Make's custom webhooks to receive that information and send it into Airtable.)

However, there is quite a learning curve with Make, so I provide some Make training resources in this thread.

if you can confirm with Make's support team that this is possible with their Shopify modules, then I am available for hire to help you set this up. I am one of the top Airtable & Make experts, and you can feel free to contact me through my website: Airtable Consultant — ScottWorld


Thanks for your input! I actually just solved it myself with a really easy fix 😅 

The committed inventory is already being brought through to Airtable in our "Order Line Items" table, as order quantity. So I just linked the order quantity field back into our Variants table, and filtered it by orders that have not been shipped yet. Easy Peasy. 

Hi Senna

I’m one of the builder of SyncBase (currently the best rated Airtable - Shopify integration). 

With our app you can get:

  • Committed inventory (in addition to Available, On-hand… inventory) for each location.
  • And also Orders Line Items in real time. It only takes a few seconds to sync to Airtable once the order has been placed on your store.

It sync your data in real time and both direction between Airtable and Shopify.

=> The app can be found and installed on the Shopify App Store.

 

Feel free to ping me if you want a demo or have any question :)

Nice catch, ​@Senna  linking unshipped order quantities back to the variant table is a clean, no-code solution. For others reading this, Shopify’s “committed” vs “available” inventory values can indeed be surfaced this way if your order data is syncing properly.

When real-time visibility becomes critical (for example, instant updates when orders change status), webhooks or an event-driven integration can help eliminate any lag between systems (https://airtable.com/developers/web/api/webhooks-overview). Tools like Stacksync can also handle two-way, sub-second syncs between Shopify and Airtable automatically, no scripting needed, keeping stock data consistent across all locations.

Terms & ConditionsAccessibility statement