How to automate weekly inventory alerts for low stock products?

Solved

How to automate weekly inventory alerts for low stock products?

TwistyPuzzles
Excursionist
17 0 8

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):
CleanShot 2023-09-11 at 08.21.27@2x.png

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!

 

Accepted Solution (1)
paul_n
Shopify Staff
1150 142 273

This is an accepted solution.

Template 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.

View solution in original post

Replies 6 (6)

paul_n
Shopify Staff
1150 142 273

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 | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
paul_n
Shopify Staff
1150 142 273

This is an accepted solution.

Template 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
TwistyPuzzles
Excursionist
17 0 8

Thanks for that Paul!

TwistyPuzzles
Excursionist
17 0 8

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
Excursionist
23 0 12

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.Screenshot 2024-06-26 at 11.19.08 AM.png

DaveMcV
Shopify Staff
101 31 27

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

 

DaveMcV | Flow Development Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.