Work Flow for expiry date notification by email

[candyshop-ai]

hi, we sell grocery products, so I need to create a flow do get email notifications like : 10 days before, 5 days before and 2 days before effective expiry date. we already created meta fields for expiry date, called  : expiry date. they are visible on product page in online store to customers, but I need to get notifications so I can handle the situation and maybe to add some discounts, it will be even useful to apply automatic discount flow for this products.

thanks

[paul_n]

Normally if you want a scheduled report like that you would use:

• Schedule time trigger
• Get product data 
• Send Internal email      

However, the main problem here is that you cannot yet use metafields with "Get product data" because the underlying API/query doesn't support it yet. 

[shultzy6]

@paul_n any chance using metafields with "Get product data" is on the roadmap? ty!

[paul_n]

It's not a Flow limitation. The API we use (as well as all partners) doesn't support it. That said, querying is very much on the radar for the metafields people, especially on products

[Genakles]

Thanks @paul_n for the info. Is there a job scheduled for that metafields querying or is it just in discovery? We don't see it on the Changelog as yet. It would be a killer enhancement!

Cheers mate.

[paul_n]

I don't have a date yet, but I know it's being actively talked about.

[Genakles]

Thanks mate