I made a script for updating the price for a product using simple SQL queries, and I - expectedly - missed something, and now I have different price on catalog page and on the actual product page for a product. Price is the same on product page as on the admin product page, but on frontend catalog page, in the listing, for this product, price is different then on the product page and in admin. What tables need to be changed to synchronize these?


"value" column in catalog_product_entity_decimal for the Product Page and "price" column for the catalog_product_index_price for catalog page. Hope it helps

  • @VladimirDespotovic please do mark it as correct answer if you got what you were looking for – Guruprasad Mar 22 '17 at 3:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.