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?
Best answer by Senna
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.)
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.
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.)
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.)
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.
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.
