Tag orders containing a sale product

You may wish to highlight orders that contain a sale product. Setting up a workflow using the  Order contains a sale product criteria will help you to identify those orders.

This criteria will only match if the compare at price for the variant is greater than the line item price.

Please Note:

This criteria is not compatible with Backdating. Please see the Is this workflow compatible with Backdating? section at the bottom of this article for more details on why.

Selecting the criteria

To create a workflow using this criteria, click on the Create New Workflow button from the main Workflows view:

Define the trigger to determine at which point you would like the workflow to run, we recommend selecting the trigger when orders are created.

Click the Add criteria to my workflow button:

The Order contains a sale product criteria can be found within the Order category in the Select criteria pop-up window:

Click the Use in your workflow button on the right to select this criteria.

You will then be presented with the following screen and options:

Customizing the criteria

You can choose if ANY / ALL or a MIX of the products in the order must be on sale for the criteria to match. Just select the radio button that meets your needs.

Excluding products from the criteria

To exclude products from being analyzed if they are part of the order, use the Add products to selection button to select as many products to exclude from the criteria as you need.

Applying a tag to matching orders

Choose the name of the tag you want to see on all orders that match this workflow and enter it into the Add tags when the workflow matches section.

In this example we have used the tag Sale item included:

Saving and naming your workflow

It's worth giving your workflow a name to help you identify it at a later date, so add a workflow name in the New Workflow section, check the summary of your workflow and if happy, either Test your Workflow against an existing order or hit Save Workflow:

Is this workflow compatible with Backdating?

Any workflows which use the Sale products criteria will not be available for backdating. This is due to the dynamic nature of product pricing, where some products go on sale frequently.

A product that was on sale at the time the order was placed might not be on sale at the point when the backdate is run. As Shopify does not record the compare at price of products at the time they were purchased, we don't know if the product was at full price or at a sale price when the order was placed.

Backdating can only look at the price that the product is at now, therefore, as this would return inconsistent results, we have decided to not make this available through our Backdating facility.