In the second step of the template (which I have changed from 2 days to 3), I want to only return orders that are unfulfilled, paid, not a test, not closed, not archived and not cancelled (i.e. truly active orders). Currently, I have only been able to get it to return unfulfilled and paid orders. Ho…

Hi Scamby, Maybe try something like this: created_at:<='{{ scheduledAt }}' AND created_at:>'{{ scheduledAt | date_minus: "3 days" }}' AND financial_status:paid AND fulfillment_status:unfulfilled AND test:0 AND closed:0 AND cancelled:0 This query field uses the the Shopify Search API Syntax in cas…

Question about "Send email summary with all unfulfilled orders older than 2 days" template

Shopify Plus

paul_n February 27, 2024, 8:52pm 10

You just change the operator on the date and remove the other created_at filter

created_at:<='{{ scheduledAt | date_minus: "3 days" }}'

Topic		Replies	Views
Shopify Flow internal emails have no order data Shopify Plus flow	5	24	October 16, 2024
How can I set up a daily auto email for unfulfilled orders excluding refunds? Shopify Plus flow	0	103	April 12, 2023
How can I set up a daily auto email for unfulfilled orders excluding refunded ones? Shopify Apps shopify-apps	2	19	April 6, 2023
Querying the Orders API endpoint Customers Discounts And Orders	2	189	November 21, 2019
Filtern nach "Bestellungen heute fullfilled" möglich? Shopify-Diskussionen	3	21	May 2, 2020

Question about "Send email summary with all unfulfilled orders older than 2 days" template

Related topics