New Shopify Certification now available: Liquid Storefronts for Theme Developers

Shopify Flow & Tagging Customer Accounts

Solved
TwistyPuzzles
Tourist
13 0 4

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
Shopify Staff
614 98 157

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 4 (4)
paul_n
Shopify Staff
Shopify Staff
614 98 157

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
Shopify Staff
614 98 157

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
Tourist
13 0 4

Thanks for that Paul!

TwistyPuzzles
Tourist
13 0 4

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?