Price Rule with Multiple SKUs

A single price rule can be applied to multiple SKUs, which makes it possible to create a variety of promotions based on a product, brand, or category. When creating this rule, you want to set conditions to match any products of selected SKUs. When building the rule, you can easily browse and select SKUs without needing to know all of your product SKUs from memory.

Step 1. Verify Storefront Properties of Attribute

Before you begin, make sure that the Storefront Properties of the SKU attribute are set to Use in Promo Rules.

  1. On the Admin sidebar, go to Stores > Attributes > Product.

  2. In the search filter at the top of the Attribute Column, enter sku and click Search.

  3. Click to open the attribute in edit mode.

  4. In the left panel, choose Storefront Properties. Then, make sure that Use for Promo Rule Conditions is set to Yes.

  5. If you changed the value of the property, click Save Attribute.

Step 2. Apply a Price Rule to Multiple SKUs

  1. On the Admin sidebar, click Marketing. > Promotions > Cart Price Rules.

  2. Do one of the following:

    • Follow the instructions to create a new cart price rule.
    • Open an existing cart price rule.
  3. Expand Expansion selector the Conditions section, and do the following:

    • In the first line, set the first parameter to ANY.

      Cart price rule condition - ANY If ANY of these conditions are TRUE

    • Click Add (Add icon) at the beginning of the next line. Then, in the list under Product Attribute, choose SKU.

      Cart price rule condition - SKU is one of SKU is one of …

    • For the comparison, you have options. If you want to locate at least one from a list of SKUs, select is one of. If you want to locate a group of SKUs that all must be found to apply, select is. We recommend selecting is one of.

    • To complete the condition, click the () more link. Then, click the Chooser (List icon) icon for the list of available products.

      Cart price rule condition - multiple SKUs Choose Each SKU

    • Browse, filter, or search to find the SKUs you want to add. In the list, select the checkbox of each product that is to be included. Then, click Save and Apply to add the SKUs to the condition.

      Cart price rule condition - multiple SKUs Multiple SKUs Added to Condition

  4. Complete the rule, including any Actions to be taken when the conditions are met.

  5. When your rule is complete, click Save.

Price rules are automatically processed with other system rules. Processing frequency depends on your installation’s cron configuration. When you create a new price rule, allow enough time for it to get into the system. Then, test the rule to make sure that it works correctly.