Prestashop: Product Showing wrong price in Category page but right in the product page
This type of questions are asked many time. I'm asking again because all the questions and answers are old and I've tried all and none of them are working. Recently I upgraded my PrestaShop from 1.5.5.0 to 1.5.6.2. Everything seems good since the upgrade but today I came across one problem.
The price of the products are showing ok in the product page but in the category listing or search it shows wrong.
Applied some solutions but non of them working. 1. Deactivated/activated the manufacturer block 2. Used default theme but same result. 3. Cleared the smarty cache. 4. Checked the default language and currency. 5. Checked with Logging out/in. Can anybody help me by suggesting why it's not showing the correct price ? You can simply view the problem here First go here and view the price then click on the product and view the price. Please help.
Some Screen Shots:-
Answer
Not sure it this help with above issue, but when some of product prices were zero, those queries solved it. They fixed the issue when prices were 0 in one of the shops in multistore configuration (Prestashop 1.6.0.6):
UPDATE ps_product SET cache_default_attribute = 0;
UPDATE ps_product_shop SET cache_default_attribute = 0;