Built this for Shopify stores that use Airtable as a master inventory list — solves the classic problem of Airtable stock going stale the moment something sells.
How it works:
- New Shopify order triggers instantly
- Loops through every SKU in the order
- Looks up the matching row in your Airtable “Master Inventory” base
- Subtracts the quantity sold and updates the Stock field — in seconds
It’s a “set it and forget it” system, no manual reconciliation needed. 4-node workflow with loop + lookup logic, ships with a step-by-step setup guide.
Full details and other workflows are on my profile.
Happy to walk through the node setup if anyone’s building something similar.