Upsell flow when specific product is purchased

Shopify Plus

Topic summary

Goal: Build a Shopify Flow automation to upsell Product C two weeks after purchase if the order included Product A or B, excluded Product C, and the customer consented to marketing emails.

Issue: Uncertainty about how to check order contents (e.g., SKU or product details) within Flow conditions.

Guidance: Use conditions on order > line items > sku to detect products in the order. Flow condition fields come from the trigger payload and mirror what’s available in the Shopify Admin GraphQL API; lineItems (with sku per item) are in the Order object.

How-to: In Flow, add a condition, click Add criteria, and navigate to Order → Line items → SKU to build inclusion/exclusion checks. Refer to the Flow conditions documentation for details.

Media: Screenshots illustrate where to select the line item SKU field in the Flow UI.

Outcome: The proposed approach was acknowledged as helpful; no further issues raised. Status: resolved.

Summarized with AI on December 29. AI used: gpt-5.
1

Hi there,

We would like to create a Shopify flow that enables the following:

  1. When an order is placed
  2. Check:
    . If Product A or Product B was in the order
    . And that Product C was not in the order
  3. Check If customer signed up to received emails
  4. Wait for 2 weeks
  5. Send promotion email for product C

What we are struggling to find is the condition to check the content of an order (SKU, product description, etc.).

FYI here is the link to our website: www.aktyva.com

Any help would be hugely appreciated!

Thank you,

The Aktyva team

2

Hi,

You could check the order / line items / sku (see the example below)

Screenshot 2024-05-16 at 12.32.44.png
Screenshot 2024-05-16 at 12.32.44.png1695×846 54.4 KB

In general, check the conditions document on how to add conditions. In essence, the variables you can use in the conditions are either passed in by the trigger, or from Shopify API. Anything that is available in the API will be available in Flow. In this case, you can find lineItems in the order API , and sku is available for each line items. You can also get this by clicking on Add criteria and you should be able to explore the available fields as below.

Whether physica shipping is required for the.png
Whether physica shipping is required for the.png711×608 58.7 KB

Hope this helps.

Lily

1 Like
3

Amazing, thank you Lily!