Wednesday 14 October 2015

Unable to apply Rules in magento

Store has thousands of Products and Catalog Price Rules. The rules weren't being applied, and after debugging cron and other things that have been a problem in the past, I took a look at the catalogrule_product_price table to see what was there. I saw a single entry:

Notice the value for rule_product_price_id -- Indeed, the max value for an INT(10) field. Reset your auto-increment and you should be good.

you change data type int(10) to bigint(15)

No comments:

Post a Comment