How to create a flow to tag order if customer has multiple open orders?

[JaminLeather]

Hello! I am looking to set up a flow to add a tag to orders if a customer has multiple open/unfulfilled orders so my staff knows to combine shipping. My customers often make multiple orders within the same day. How do I go about this? 

[TediaConsulting · Accepted solution]

I have no way to test this, because I don't really have repeat orders, but here is what I would start with, then troubleshoot if it doesn't work:

1. Trigger on Order Created
2. Get Order Data - Select Unfulfilled orders older than 1 day, then adjust the amount of time in the edit query box if you want to make it longer
3. Add Order Tags (set the tag to whatever you want)

Something like this:

[Vonda_Youngkin]

Has anyone tested this?  I need something that will tag multiple orders placed the same day.  It doesn't seem like that solution would work, but I'm new to the flows.

[TediaConsulting]

Hi Vonda, glad to help. Have you tried creating the flow as shown above? Let me know if you get any errors, or unexpected results, and I'll try to see if I can help you further.

[Vonda_Youngkin]

I can't get your suggestion to work. It instantly tags the first order placed. Also, there is no option to select "Unfulfilled orders older than 1 day," only 2 days or more, then a date trigger is required, and have no idea what that is.

I thought this might work, but it also does not.  Step 2 I added advanced of "fulfillment_status:unfulfilled AND NOT status:cancelled"  I think my problem with this one is the Get Order data, I'm not convinced it's pulling for that specific customer...?

[TediaConsulting]

Hi Vonda, it looks like your condition is checking if there are 2 items in the getOrderData object. I think this needs to be done in the query editor of the Get Order Data module. 

[Vonda_Youngkin]

Thank you. Do you have an example?  It's rather hard to wrap my brain around the flows. 

[Vonda_Youngkin]

A Report Pundit report can ID customers with more than one open order.  Now, I just need something to auto tag those ordersas it's a PITA to to go through and do it manually. Why is this so challenging? The data obviously exists.