The way im doing it at the moment means everytime a customers orders something i get an email (if the product inventory levels go from 8 to 7). Currently getting over 100 emails/month which is annoying, i just want it to run every week and collate it all into one email on a weekly basis if the products go from 6 to 5.
Hopefully you don’t have 100 workflows using Inventory quantity changed. If so, it will eventually use up your API limit in Flow and things will start to slow down. It also hammers your API on every single inventory change. So regardless, if you have it set up that way, you should def fix this before it becomes a problem.
That said, to send a single email, you can use the new “Get variant data” action. Generally, the workflow would look like:
Scheduled time trigger (every week)
Get variant data (inventory <= 7)
Send Internal email
One note - the “Get data” actions currently have a max limit of 100 return results. If you might go over that, then you might also want to add more filters to that query to narrow down the results.
Im trying to adjust this slightly as you suggested by filtering it down (im well above the 100 variant limit).
Id like to create 2 or 3 of these for my main brands. How would i incorporate BRAND into this? (product vendor) so that it only scanned products of that vendor to see if they were below 5 total inventory?
