Daily Email For Products Back in stock

[cortexcreative]

Our customer is looking to create a flow that will send a daily (possibly weekly as well) internal email with product names that have come back in stock. Can someone help with how to build the flow that will check for products that go from inventory of 0 to anything 1+ once per day?  Thank you in advance. 

[paul_n]

There are many templates available in Flow that show how to do this. Click "Browse templates" and then search for something like "back in stock"

[RPiii]

It's possible to send internal email notifications for individual product variants that have come back in stock by using a Product variant inventory quantity changed trigger followed by a condition that compares previous inventory quantity to current inventory quantity followed by a Send internal email action.

However, to create a digest of all relevant products we'd need some way to know what the prior inventory was. From what I can tell, the Get product data action can query products based on current inventory_total but not the prior total. Are products in the relevant shop tagged or assigned metafield values that might help us identify those that had previously been out of stock? If so, a Scheduled time trigger followed by a Get product data action with a query filtered to those products tagged (somehow) as out of stock but with current positive inventory_total could then be used to populate the Send internal email action.