I feel like I have a pretty unique problem. I created a post purchase review flow from the Klaviyo template.
My payment provider on Shopify works in a way that when someone orders a product, it creates a separate Shopify order for the shipping. Our store offers free shipping starting from an order of 45€, so all orders below 45€, Shopify will create 2 orders for that customer (1 for the product itself and another for the shipping, which is up to 3.60€).
So my problem is, if someone orders something below 45€, it will count as 2 orders for that customer and Klaviyo will send 2 product review emails to that customer, one of which will be broken as it’s not a real order.
Here is a screenshot of how the preview of the shipping cost product review email:
How can I make it so that Klaviyo will ignore the separate shipping cost order and only send the actual product order. I don’t want it to send 2 emails where 1 is broken anyway.
I tried changing the trigger filters, for example where the value of the fulfilled item is at least 45€, but it still shows under the “waiting” tab, that customers who ordered below 45€ will get two product review emails.
Here is a screenshot of the actual flow filter (mind you that Klaviyo is displaying the currency as $, but it’s actually €):
How can I make the filter work correctly?
Best answer by alex.hong
Glad I could help! Your solution looks great and is definitely a way to get around the problem. You are correct in the sense that it would be Fulfilled Order and not Placed. So in turn, your flow filter would be: fulfilled order where item contains (two shipping items), zero times in last (X) - this would just need to be a smaller time frame like 4 hours or something. I am unsure what the doesn’t equal 1 relates to, but it is not needed for the flow to work.
Another, more streamlined solution would be to create a trigger filter, follow our documentation so that this flow filter and exclusion part is not needed; this would also evaluate it on triggering event itself.
Hope this helped!