Check a customer all orders and send emails to he if not includes one item

Shopify Plus

Topic summary

A Flow user is attempting to create an automated workflow that sends an email to customers who purchased product A but haven’t subsequently purchased products B or C within a specified timeframe.

Current Issue:

  • The workflow’s condition to check if all customer orders exclude products B or C is producing errors
  • Multiple configuration attempts have failed

Identified Problems:

  • The condition is checking line items on the original triggering order rather than querying all customer orders
  • The check is placed after the “For each” loop instead of inside it, rendering the loop ineffective

Suggested Solutions:

  1. Query orders by SKU (if variant SKUs are assigned) to return only orders containing the target products
  2. Alternatively, move the condition inside the “For each” loop and check if each order’s line items contain the specific product IDs

The discussion remains open with the user awaiting implementation guidance.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.
1

I am a new user of FLOW, and I want to make a flow to send an email to someone who bought our product A, but after a while, check all his orders and find that he did not continue to buy B or C.

The start process and wait process work fine, but the check if all orders do not include B or C gives an error. I have tested many combinations and they are all wrong. What should I do? Save me. Thank you!

Tiffany28_3-1740712785796.png
Tiffany28_3-1740712785796.png1865Ă—603 82.6 KB

Tiffany28_2-1740712743072.png
Tiffany28_2-1740712743072.png1705Ă—794 66 KB

2

You are checking the line items on the original order and not the returned order. Also, you put that check after the “For each” loop, so your loop is actually doing nothing in this workflow.

But I’m not sure you even need this condition. You can instead query orders by SKU assuming you have the variant SKU’s assigned. Then your query would only return orders if they also purchased those other SKUs. If that doesn’t work for some reason, you need to put your condition inside the For each loop and check if the order item from that loop has that product ID in it’s line Items.

1 Like