Subscription end reminder using shopify flow

[dcorp]

Hi, I have a magazine subscription that is quarterly, semi-annual and annual. I want to set up a workflow where it would send a reminder email a week before their subscription ends. At the moment I've added a workflow where it tags each customer based on which subscription they bought and adds a custom metafield value with a reminder date (adding a relevant number of days). 

I plan on doing a scheduled workflow to check everyday for customers that are tagged and have their reminder  metafield value for that day. But there's a limit of 100 customers that I can retrieve. Just thinking if there's a way to avoid the 100 customer data limit? Or some other ideas on how to set this up? Thanks! 

[paul_n]

You could create a segment based on that metafield. And then in Flow use the Customer joined segment trigger. Look at birthday segments for an example of how to do that. 

[dcorp]

Thank you Paul, this worked great. One additional question - my setup is really simple, 1 product (print magazine) with 3 variants for subscription frequency (quarterly, semi-annual, annual). Currently, when an order is placed, I add a tag to the customer and update a customer metafield value, setting when is the next reminder date (adding relevant number of days). The value is stored with the customer. The anniversary solution works when there is one order. But what if the customer orders more than one subscription? I guess I should add a separate metafield for each sub type, right? And then filter the segments based on it... 

[paul_n]

If there is a small number of subscription orders per customer, then that might work. You could potentially use a single metafield but make it a list. Or a list of metaobjects if you need more than 1 field.