Require some help on moving/changing data between Airtable and Shopify, using integromat.
Reason? We have items where stock is managed in Airtable and Shopify. Shopify is used for items sold online, the Airtable system for items associated with jobs within the business (the items are automotive parts, so we sell some, and use some internally).
The reason the items are managed on Airtable is for integration with other data/information requirements.
Stock is managed in Airtable by having 1x table that is a list of items, and one times table where a stock adjustment record is added. Example, Item A exists in the list table. On the stock adjustment table, if stock is removed, a line is added that links to that item, with ‘1’ added to a Stock Out field, likewise for stock in. On the list table, the stock amount of Item A is calculated as a simple In minus Out roll-up.
We have put together an Integromat automation that watches Shopify orders, and can add a new stock record when an order is placed, this all works as needed.
What we need to be able to do is when a new stock record is added in the Stock Record table, to modify the Shopify inventory. We can either do this from Airtable to Shopify, or we have a third party Shopify app that downloads product information to a base, and can upload when needed (direct to Shopify seems most sensible).
The question, what trigger can I use when an Airtable record is created, to then run the Integromat scenario to update Shopify inventory? At the moment, can only see the option of a webhook, which relies on a form submission? Or a periodic check that looks at a modified/created date field.
Anyone with a bit more experience think of a way to achieve this? Any help much appreciated.