Shopify synthax query code not working helppp

Shopify Plus
,

Topic summary

Main issue: A customer query using “Created in the last week” fails because the variable scheduledAt is reported as invalid. scheduledAt only exists when the Scheduled time trigger is used; without that trigger, the query cannot resolve the variable.

Suggested fixes:

  • In the query editor, use “Add a variable” to insert scheduledAt. If it’s not available, hard-reload Flow, try another browser, and ensure a Scheduled time trigger feeds the customer query.
  • An example Flow JSON was provided showing: scheduled_time → fetch customers with query customer_date <= {{ scheduledAt }} AND > {{ scheduledAt | date_minus: “1 week” }}. This code snippet is central to reproducing the setup.

Clarifications:

  • Over-bracketed Liquid like {{{{customer.createdAt}}}} is invalid and likely unnecessary. A simpler {{ customer.createdAt }} may effectively mean “before now.” One participant says Shopify generated the extra braces; another says no action inserts that.

Separate report: The Marketing Automations “Welcome new subscriber” stopped triggering recently despite tests; using the template did not help. Recommendation is to contact support with clear reproduction details.

Status: Flow query issue has a likely path to fix; marketing automation problem remains unresolved.

Summarized with AI on December 31. AI used: gpt-5.
6

Hi Paul_n

I try to explain myself better.

This code generate by shopify itself:

customer_date:<=‘{{{{customer.createdAt}}}} }}’

so if you ask, then ask internally at shopify ;).

About the SQL, nevermind, what i mean is I used a get customer block that as long I know, it query data data that satisfied .

As any query language usually the order is not guaranteed but probably this is another topic.

The point is, why the welcome automation marketing flow(not flow app, but marketing automation) is not working, anymore is a mistery.

No error whatsoever.

Bear in mind I tried with a never used test email, with no lack.

Hope to have some good insights.

If you have any chance please let know your managers that as a shopify avocate and Partner, I am starting to have concern regarding the quelity of feature and further develop at Shopify.

Lot of things not working anymore or stopped to work.

Support closing chat or not answering etc

Maybe your stackholder really do believe everything will be run by AI, wondering who do they will sell if merchants

won’t be there anymore.