Catalog rules with same priority for different customer groups do not apply correctly

Preconditions and environment

• Magento version: 2.4.9-sep-2026
• Ensure the store contains a configurable product, standalone simple product and a simple product assigned to the configurable.

Steps to reproduce

1. Create 2 Catalog Price Rules in the Admin panel:
   • Ensure both rules have different discount percentages
   • Ensure both rules have the same Priority
   • Ensure both rules are assigned to different customer groups
2. Reindex the catalog price rules
3. Check the catalogrule_product table:
   • Only the rule with the highest ID is applied to all products
   • The rule with the lowest ID is only assigned to the standalone simple product

For validation:

1. Change the rules to have different Priority values
2. Reindex again
3. Check the catalogrule_product table again and observe that the rules are now applied to all simple products correctly for both customer groups

Expected result

Catalog rules with the same priority but different customer groups apply to all matching products

Actual result

Catalog rules with the same priority but different customer groups apply to all standalone simple products and only apply the catalog price rule with the highest ID to configurable variant simple products.

Additional information

Changing the priority for the rules can be used as a workaround but this might not be applicable to every production environment if there are many different rules and customer groups being used.

Release note

No response

Triage and priority

• Severity: S0 - Affects critical data or functionality and leaves users without workaround.
• Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
• Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
• Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
• Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.