How to Filter Out Archived Orders in Shopify Flow?
Hi everyone,
I’m new to Shopify Flows and am trying to set up a flow that sends email notifications to our customer care team about orders that haven’t been fulfilled after 3 days so they can follow up with our warehouse on any issues.
However, I need to exclude archived orders as well from these notifications.
My Current Setup, based on a template:
Trigger: Scheduled (Daily)
- Get Order Data query:
created_at:<='{{ scheduledAt | date_minus: "3 days" }}' AND fulfillment_status:unfulfilled AND NOT status:cancelled
I tried adding simply “AND NOT status: archived” here after cancelled, but that did not work as the auto email still included archived orders.
- Count:
Count items in getOrderData - Sum:
Calculate the sum of getOrderData-currentTotalPriceSet-shopMoney.amount - Condition:
Count is greater than 0 - Send internal email
What I’ve Tried:
Reached out to Shopify Plus Support and got the below answer, but it does not help me as I unfortunately don’t understand how to incorporate this in my flow and the valid values does not contain “Archived”.
”I have it checked with our dedicated team and I was advised that archived is apparently one of the supported queries by the orders query, following the guide here:
• orders
In this case, they recommended to try filtering them out by chaining a condition step that checks if the order is archived, provided:”
status
string
Filter by the order's status to manage workflows or analyze the order lifecycle.
Valid values:
open
closed
cancelled
not_closed
Example:
status:open
My Question:
How do I filter out archived orders from this flow?
Any help would be greatly appreciated! Thanks in advance!