Email not sending after doerer/purchase

[VicBrew1]

I have this workflow where I want to send a customer and email to book time with me on candidly. The problem is that I am not receiving an email even if the person is subscribed. I checked to make sure the workflow is active and running. Any suggestions? Any help would be greatly appreciated. 

Store: https://qtupb6-n1.myshopify.com/

[paul_n]

Do you have a valid query in your "Get order data" action? Can you show the run detail page for one of the runs? Does it show that it found orders?

[VicBrew1]

UPDATE: It is sending the emails at 12am for each order now but unfortunetly once each day instead of just once per order. Any ideas on how to fix this? 

I think my problem is here where it's grabbing the customer ID and not the Order ID. That's only half the battle as I have to figure out how to make it only emil once per order ever. 

[paul_n]

You are getting orders created in the last day. So it's going to send the email for each of those orders. It may not send for all of them, if there are more than 100, or if the Marketing Email blocks sending for some reason to the same customer. 

[VicBrew1]

but why does it send multiple times. If it's the last day, it should grab those orders once and snd then the next day, if there are no orders it shouldn't send an email. Right now it is sending an email for every order ever made. 

[paul_n]

That suggests something in the query is off. The Admin API can return "All orders" when the query is invalid. 

I'd recommend taking the email out of this for now and use replace it with "log output" so that you don't spam people. You can also use log output to show the query string that you are using (since there are variables it's interpreting).  

What query are you using now? It's changed twice above, so I'm not sure what you are using

[VicBrew1]

I'll try log output. Thank you! Right now, this is what I have:

I found some code in Shopify's documentation here: https://shopify.dev/docs/api/admin-graphql/2024-10/queries/customers , https://shopify.dev/docs/api/admin-graphql/2024-10/queries/orders

[paul_n]

There's your issue. You enter the query string only there. Flow handles paging, fetching fields, etc. 

[VicBrew1]

Ahhhh okay. Thank you very much!!!!