i selected the query “Created in the last week” (about customers) and it made me some code customer_date:<=‘{{ scheduledAt }}’ AND customer_date:>‘{{ scheduledAt | date_minus: “1 week” }}’ but then an error pops up that says “scheduledAt” is invalid. Replace this variable. i searched on the inte…

Click the “Add a variable” action in the edit query UI. If scheduledAt is not in that list, then there is no schedule data available to that part of your flow. If the Scheduled time trigger is directly connected to what has this issue, probably try and hard reload the shopify flow url; and test in…

As it says when you select that query, you need to use it with a schedule time trigger. What are you trying to do?

I have same issue because I try to “fix” the welcome marketing block that is not triggering anymore when a customer subscribe. Before I was selecting 100 customer but as SQL in your backend is done randomly I was try to improve it. sot please, what I should change here to make it work(select the s…

I don’t know what you are trying to say there about SQL and the welcome marketing block. Or what “sot” means. Why are you using so many brackets in your liquid? customer_date:<=‘{{{{customer.createdAt}}}} }}’ This is more valid but you also may not need it (since it may be effectively saying “get…

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 sat…

That code should not be inserting into your UI. I double-checked and do not see any action that inserts that. Welcome automation should be working, but I haven’t seen anything above suggesting otherwise. It seems like language may be a problem here, so you might have better luck reaching out direct…

That code is generated at marketing automation block within Shopify admin API. The welcome automation I set, did worked last time Saturday, then as I was running some ads and have organic visit, and signed people it should have worked, but nothing. I then tested with an email, subscribed and “surf…

Hi, have you tried using the “Welcome new subscriber” automation template?

Shopify synthax query code not working helppp

Shopify Plus

CarmineT April 17, 2024, 6:05pm 10

yes that one, it stopped to work recently for no reason

Topic		Replies	Views
ShopifyQL returns response but wrong data Graphql Basics And Troubleshooting Setting-Up	5	83	March 30, 2023
Correct formatting for Shopify Flow GetData graphQL query Shopify Discussion troubleshooting	1	35	July 31, 2024
Shopify flowのget customer dataのクエリについて Shopify アプリ	5	97	February 3, 2023
ShopifyQL Query Stopped Working, throwing a syntax error Graphql Basics And Troubleshooting	1	220	October 7, 2022
ShopifyQL Query Stopped Working, sales is no longer a valid FROM source Shopify Apis And Technology Setting-Up	27	482	May 15, 2024

Shopify synthax query code not working helppp

Related topics