Work Flow for expiry date notification by email

Shopify Plus
1

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

2

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.

3

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

4

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

5

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.

6

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

7

Thanks mate