I work for a dietary supplement company, and we have an online store that’s connected to Klaviyo via the magento2 integration. I want to create a replenishment flow that sends an email reminding someone when their supplements are about to run out so they can order more. However, a few factors complicate what I’m wanting to do and I haven’t been able to find someone who has asked a similar enough question.

I did the calculations to figure out which supplements will run out in the same amount of time and have put them into groups. I thought I could make a flow for each group (for example, one flow for products that take 30 days to consume, 60 days, and so on) that has an “Ordered Product” trigger with a trigger filter that lists all the SKUs of the products in that group. However, our store has 450 products, and I’m not sure if there’s a limit to how many SKUs can be listed, but I really don’t want to go in and add all of them one-by-one. I’m hoping there’s something on the magento website backend or some other attribute I could pull from to make this easier.

Additionally, I want the email to list all the supplements the person has that need to be replenished. It’s ok if this is limited by order, but if someone orders 5 products, and 2 of them will run out in 30 days, I want both of those products to be listed in the email while omitting the rest from the order. 

The last thing that complicates things, perhaps the most, is that we have a recurring orders feature. If someone eventually signs up for recurring orders, I want them to not enter the flow so they won’t get refill reminders for products they have on recurring order. Is there a custom attribute I can build in magento to add this to the flow?

Is this possible? If not, does anyone have any suggestions on a alternate method or service I could use to achieve this? I know a lot of companies that send emails like this.

Thank you