Magento CE 1.9.0.1 Catalog Price Rule Calculation Issues – Solutions

catalog-price-rulesce-1.9.0.1

Recently upgraded from 1.7 to the latest version (1.9) of CE.

Having a problem with a catalog price rule – and it's the first rule I've set up since the upgrade.

The rule is set up to be 10% off all products from a particular brand. Very simple. Priority is zero and have it set to stop processing after this rule. There are other rules set as 'active' but they're all expired.

When I make this rule active and apply it, the discount shown on the front end is much larger than 10%, it's more like 30%.

And if I apply a discount of 0%, the items all show a discount of around 10%.

I'm not sure if the rule is getting applied multiple times, or there are deleted rules that are being applied in correctly.

Best Answer

I moved my comments to answer, so this question can be shown as having an answer, as it seems solved.

You need to definitively determine if those old rules are causing the problem.

Are the expired rules active?

If so, set them as inactive. This should help determine if they are still being applied.

Also line items in cart will hold a list of applied rule ids. In the cart output the value of ->getAppliedRuleIds() to see what rules applied to the item

As per your comment above, deleting those rules fixed the problem. All good and well, but if I were you I'd do a new test, to determine if this is just an upgrade issue (old rules not working/compatible to site db/code changes), or if you have an underlying issue with your site.

Create a new rule, marked it as expired - test if it also applies. Mark it as inactive - test if it also applies.

If they do, you need to dig a bit further, as something is not right, and you'd run into issues later (and forget about this issue possible) It could also potentially point to other issues after the upgrade.

Nothing worse than having strange inconsistencies 6 months down the line, and not knowing why....

Related Topic