Price Rule with Multiple SKUs

A single catalog 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 that match the selected SKUs. When building the rule, you can easily browse and select SKUs from the grid.

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 Code column, enter sku and click Search.

  3. Click to open the sku attribute in edit mode.

  4. In the left panel, click 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, go to Marketing > Promotions > Catalog Price Rules.

  2. Do one of the following:

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

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

      Catalog 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, click SKU.

      Catalog price rule condition - SKU is one of Condition based on SKU

    • 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.

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

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

      Catalog 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.

      Catalog 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.