Skip to main content
2 of 4
Fixed the error
elfling
  • 797
  • 4
  • 18

Experiencing this problem on a store. Prices are excluding tax and the store was upgraded from 1.7.

How I fixed this was.

update `catalog_product_index_price` set `final_price` = round(`final_price`,2);
update `catalog_product_index_price` set `price` = round(`price`,2); 
update `catalog_product_index_price` set `min_price` = round(`min_price`,2); 
update `catalog_product_index_price` set `max_price` = round(`max_price`,2); 

Reindex Product Prices to rebuild catalog_product_index_price

elfling
  • 797
  • 4
  • 18