Magento – Two price rules, same priority

catalog-price-rulesprice-rulespromotions

What happens with 2 (or more) (catalog/shopping cart) price rules with the same priority?
Which one will be applied first?

Best Answer

There is no way to determine for sure what is the order of the rules if they have the same priority. In this case the rules are retrieved as MySQL want's it and it may not be always the same order. The order can be different depending even on the MySQL version. See this answer here (and comments). These guys really know what they are talking about. I had the same issue/question before and during tests I got strange results for different items in the cart. I've even got lost in the numbers when I had combinations of rules that were applied on a specific item and on the full cart.
Conclusion Always specify priorities to rules that might affect the same product.

Related Solutions

Magento Price Rules – Which Price or Rule Has Highest Priority?

Magento takes the minimal value (lowest price) from the following calculated price variations

Product Price
Tier Price
Group Price (CE1.7+)
Special Price
Catalog Rule Price

Reference as Marius says above, slide #9 from Ivan Chepurnyi (used to be part of the Magento Core Team so should know the correct answer!)

Magento – Magento Get Shopping Cart and Catalog Price Rules

Try this way:

$catalogrules = Mage::getModel('catalogrule/rule')->getCollection()
        ->addFieldToFilter('is_active', 1)
        ->addAttributeToFilter('description', 'notnull');

$cartrules = Mage::getModel('salesrule/rule')->getCollection()
        ->addFieldToFilter('is_active', 1)
        ->addAttributeToFilter('description', 'notnull');

they will be loaded automatically when you loop them through foreach

Best Answer

Related Solutions

Magento Price Rules – Which Price or Rule Has Highest Priority?

Magento – Magento Get Shopping Cart and Catalog Price Rules

Related Topic