Flow filter based on Order ID

Question

Hi,I have a situation with a flow I’m trying to resolve. I have a Flow from a CRM taht sends emails for orders made by telephone only.The only trouble is the CRM is also sending all WooCommerce orders to Klaviyo too.I can’t turn off the native WooCommerce orders because the CRM does not display the order information correctly from WooCommerce.In an ideal situation, I would be able to filter within the flow if the Order ID matched what was seen from WooCommerce recently.I think I have Part 1 sussed out by sending a WebHook with the WooCommerce Order IDas a custom property to the profile.Part 2 would be the CRM Flow looking for the WooCommerce Order ID on the profile matching the Order ID in the CRM event and filtering the profile out if they matched, but I’m stuck at this part.Anyone understand my ramblings and have a solution?

Stuart at HIPPO · Accepted Answer

Solved this with the most simplest of solutions after going down the API and Webhook rabbit hole. Could kick myself for the time wasted there.

On teh WooCommerce flow I now have a Custom Property created for Profiles that had made a WooCommerce order. WooOrder = True

In a second flow with the CRM orders being the trigger, I added a delay and conditional filter that looks for WooOrder = True. If True they are filtered to a path that sends no emails, and removes the Custom Property.

This means our CRM can now safely send all orders and any profiles that have made a WooCommerce order do not receive numerous emails, but phone and smartphone app orders receive their order confirmations via Klaviyo.

Byrne C · Answer

Hi ​@Stuart at HIPPO,I do understand your goal! That being said, it’s unfortunately not possible right now for a flow to compare a profile property with another piece of data to see if they match. Flow and trigger filters/splits can check and see if a profile property or event property has a specific value, but that value needs to be static; we can’t check if one value matches another. Apologies for this!I think your best bet would be to work with WooCommerce/your CRM to see if WooCommerce can start collecting the correct order IDs.

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials