Dec 17, 2020 01:00 PM
I have a situation where shopify inventory levels in airtable can be changed manually by a user or automatically by shopify when a product is sold.
I have an automation that watches changes to the stock level value and on change, triggers an automation to update shopify via a webhook via integromat.
The problem is that when an order is placed in shopify, this automatically changes the stock level in airtable via integromat, but, this also triggers the airtable automation which then updates shopify again.
How can I prevent the automation from running if the stock level change was a result of an automatic update from shopify rather than a user created update action to the stock level please?
I have tried looking at last modified by but this doesn’t change whether it’s an automation of a webhook that changed the value.
Any help would be gratefully received.
Dec 17, 2020 01:24 PM
Try adding a “Last Modified By” field and adjusting your Automation not to run if that field is “Automations” or maybe “Anonymous”
Dec 17, 2020 01:26 PM
‘Last Modified By’ doesn’t change whether it’s an automation or an external service that affected the change in value - in my case at least. This was my first idea that I mentioned above.
Dec 17, 2020 01:36 PM
Sorry I missed that part of your post. I believe external sources uses your API key so Airtable considers it “you” making the change. Is there any way data from Shopify comes in that only happens when Shopify does it?
Can you set the Automation not to run if the last modified time of the Stock field is equal to the last modified time of whatever other fields Shopify is editing?