Shopify Flow is an ecommerce automation platform that enables you to automate tasks and processes within your store and across your apps.
I am looking to write a query or shopify flow that gets me unfulfilled or partially fulfilled orders that are older than 3 days on a scheduler.
This is working fine.
created_at:<='{{ scheduledAt | date_minus: "3 days" }}' AND
(fulfillment_status:unfulfilled OR fulfillment_status:partially_fulfilled) AND
NOT status:archived AND NOT status:cancelled
I am looking to add to this query to only get orders that contain the tags 'Amazon Status - Planning' and exclude orders that contain the tag 'Amazon Status - Complete'
I've tried the below query, but it does not run (although I dont get errors in the query snytax).
created_at:<='{{ scheduledAt | date_minus: "3 days" }}' AND
(fulfillment_status:unfulfilled OR fulfillment_status:partially_fulfilled) AND
NOT status:archived AND NOT status:cancelled AND tags:'Amazon Status - Planning' AND NOT tags:'Amazon Status - Complete'
Is there a different query or another approach I should be taking? The use case is I have orders that get stuck in 'Amazon Status - Planning' and dont end up getting fulfilled.
With tags, I think you need to use tag_not instead of NOT tags. Also it's "tag" not "tags".
2m ago Learn the essential skills to navigate the Shopify admin with confidence. T...
By Shopify Feb 12, 2025Learn how to expand your operations internationally with Shopify Academy’s learning path...
By Shopify Feb 4, 2025Hey Community, happy February! Looking back to January, we kicked off the year with 8....
By JasonH Feb 3, 2025