How to automate weekly inventory alerts for low stock products?

[TwistyPuzzles]

Hey Shopifyers, 

So im trying to figure out if this is possible. 

Once a week (prehaps on a sunday?) Flow will scan my website and make a big list of all products where the inventory is low (<5 remaining).

I've done this on a product by product basis (below):

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. 

Thanks in advance, im sure this can be done!

[paul_n]

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.

[paul_n · Accepted solution]

Template 

https://shopify.com/admin/apps/flow/editor/templates/77bac685-ead1-47fa-a597-352cb14cacdb

[TwistyPuzzles]

Thanks for that Paul!

[TwistyPuzzles]

Hey Paul, 

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?

[Jackson_McLean]

This link no longer works. Can someone update with a new template link that does work? I would like to generate these reports as well.

[DaveMcV]

Here is the updated link. Thanks for calling that out!

https://shopify.com/admin/apps/flow/editor/templates/77bac685-ead1-47fa-a597-352cb14cacdb