Magento fix catalog price rules promotion

Posted by Damodar Bashyal on May 06, 2014


One of the magento based website had strange issue. All rules in the admin > Promtions > Catalog Price Rules were inactive. But still some products were displaying as sale items. So ran mysql code listed below to find out what was happening.


Save (output) MySQL query results into a text file

Posted by Damodar Bashyal on April 15, 2014


Today because of magento bug when I saved payment info on client's site, it replaced all payment info on database with encrypted values.