Hi, We’re battling customers trying to get around our sale limits of 1 per SKU by placing multiple orders. I’m trying to use Flow to automatically cancel an order if they place a second order within 24 hours containing the same SKU. i.e. Order 1 SKU ABC x1 goes through Order 2 SKU BDC x1 goes t…

Hello @Chegism I am assuming you want your customer to buy 1 unique SKU per order, but they can order multiple different SKU per order, am I right?

Correct. They can also place multiple different orders - but we want to auto-cancel if the order the same SKU a second time.

Where are you trying to do that count? I’m assuming your workflow looks like: Order created Get order data (customer:{{order.customer.legacyResourceId}} sku:the_sku) Count (Get order data) If count > 1 Cancel current order

Order Created Get Order Data: created_at:>‘{{ “now” | date_minus: “24 hours” }}’ AND customer_id {{order.customer.legacyResourceID}} AND sku: ABC But it isn’t counting the SKU I’m adding at all, it’s being ignored (i.e. placing a new order for a completely different SKU is still triggering it)

Are you using lowercase sku? It works ok in my store: [06-27-twdoq-nmfs0.png]

No, I was using uppercase as that’s what was listed for the SKU back on the product page. Does only lowercase work, and does it need to be wrapped in “”?

FYI, you also appear to be missing a colon and using the wrong variable for customer (customer_id and ResourceID both wrong). Try: customer:{{order.customer.legacyResourceId}} Full query: created_at:>'{{ "now" | date_minus: "24 hours" }}' AND customer:{{order.customer.legacyResourceId}} AND sku:ABC…

It is usually safe to wrap and helpful when it can have spaces. The doc for what query variables are available is here: https://shopify.dev/docs/api/admin-graphql/2024-01/objects/QueryRoot#connection-orders (you’ll have to expand it a couple of times)

I have this now. Order Created Get Order Data (this code, changing customer_id to customer) Count items in getOrderData Check if Count is greater than or equal to 2 It’s firing on every single order that comes in, even customers with 1 order for a different SKU.

By firing, I’m assuming you mean that runs for every order, which is how Order created works. If you want that logic to only execute for when the SKU is present in the current order, add a condition before the “Get order data” to check the current sku. (if at least one of order/lineItems/sku == YOU…

How to automatically cancel duplicate orders with same SKU within 24 hours?

Shopify Plus

paul_n March 6, 2024, 6:42pm 15

Looks right. You might need to share the link of the workflow so we can look closer. You can either go through support to share that or DM me here.

Topic		Replies	Views
Shopify Flow - Duplicate SKUs on an order Shopify Plus flow	1	87	May 5, 2025
Shopify Flowで特定商品の2回目以降の注文を自動キャンセルしたい技術的なQ＆A javascript , html	2	45	September 13, 2024
Get a notification when any order includes 2 or more same items / SKUs Shopify Plus flow	4	75	June 21, 2024
Shopify Flowによる複数回の注文を制限する方法について総合的なディスカッション	3	128	June 5, 2024
Customers ordering more than once in 48 hours Shopify Plus flow	2	72	September 15, 2023

How to automatically cancel duplicate orders with same SKU within 24 hours?

Related topics