Advanced Query Help

Shopify Plus

Topic summary

A user sought to tag customers as “Abandoned” if they haven’t ordered in 120 days, working around Shopify Flow’s 90-day wait limit.

Initial Problem:

  • Created a scheduled daily Flow to query customers with no orders in 120+ days and without the “Abandoned” tag
  • The query returned no results despite qualifying customers existing
  • Three screenshots showed the Flow configuration and query setup

Solutions Provided:

  • tim_1 suggested using the “Customer joined a segment” trigger with a custom segment definition (included screenshot)
  • Original poster continued testing and successfully resolved the issue with modified query code

Resolution:

  • The user shared working code/configuration in a final screenshot for others facing similar challenges
  • Both the segment-based approach and the refined query method were validated as viable workarounds
Summarized with AI on October 29. AI used: claude-sonnet-4-5-20250929.
1

Hello,

Since there is a 90 day limitation on the wait function in Flow, I’m trying to find a work around to tag customers as “Abandoned” if they haven’t placed an order in 120 days.

My idea is to create a scheduled flow that runs daily and pulls customer data for customers with no order in the last 120 days and are not already tagged “Abandoned”. However, when I test this its not pulling any data. Which it should, because we definitely have customers who haven’t ordered in the last 120 days and no customers were manually tagged Abandoned.

See below screenshots:

caretucker_0-1745009395849.png
caretucker_0-1745009395849.png1373×645 48.7 KB

caretucker_1-1745009438182.png
caretucker_1-1745009438182.png1603×587 58.2 KB

caretucker_2-1745009463183.png
caretucker_2-1745009463183.png642×800 43.9 KB

TIA!

2

Consider trigger “Customer joined a segment” and create a segment

Screenshot 2025-04-19 at 2.43.18 PM.png
Screenshot 2025-04-19 at 2.43.18 PM.png568×344 20.1 KB

3

Thanks for the suggestion!

4

I kept playing with it and got it to work. Below is the working coding in case anyone else is having similar issues.

caretucker_0-1745259450050.png
caretucker_0-1745259450050.png652×777 44.7 KB

@tim_1 offered a great workaround as well

1 Like