Tag based on the quantity of products with a certain SKU in the order

This criteria allows you to highlight orders that contain a certain quantity of a particular SKU code. It is often used to highlight when similar SKU's have been ordered so that the pick and pack process can be more efficient (similar SKUs are often located within close proximity of one another).

When this criteria is run against an order, the quantity of all matching line items will be added together and then tested against the quantity value/condition that you specify, to see if the criteria has been matched.

How to use the criteria

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

1-create-new-workflow-button.jpg

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

4-order-created-trigger.jpg

Click the Add criteria to my workflow button:

2-workflow-criteria-section-button.jpg

The Quantity of products with a certain SKU in the order criteria can be found within the Product category in the Select criteria pop-up window:

quantity-of-sku-criteria.jpg

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

You will then be presented with a number of criteria options to configure:

criteria-options.jpg

Criteria Options

There are two values that can be configured within this criteria.  One is the SKU and the other is the Quantity. Both values contain conditions that will allow for either an exact match, or broad match.

SKU code

The SKU code option has a variety of conditions to select from:

options-1.jpg

Here is a brief overview of what each of those conditions does:

is: Does the SKU code exactly match the string you have specified?

is NOT: Does the SKU code NOT match the exact string you have specified?

contains: Does the SKU code contain the string you have specified anywhere in the value?

does NOT contain: Does the SKU cod e NOT contain the string you have specified anywhere in the value?

in: Does the SKU code match exactly any of the provided comma separated list of values?

Select the condition most suited to what you are trying to identify in your SKU code value.

SKU quantity conditions

The SKU quantity conditions specify how the value that you enter should be evaluated against the total quantity of matching line items. The options are:

  • Greater than
  • Greater than or equal to
  • Less than
  • Less than or equal to
  • Equal to

Note: When using Greater than or equal to and the value is 0, every order will be tagged, since the provided SKU has a quantity of 0, when the SKU isn't part of the order. Use Greater than 0 for those cases.

options-2.jpg

Select the condition and enter the quantity required for this criteria to match an order.

Hit Save and that's it!

Backdating

This criteria will work if you choose to Backdate your orders.

Dynamic Tagging

It is not possible to apply this criteria using Dynamic Tags.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us