My magento version is Today I try to clean my database. And I accidently truncate catalog_product_index_price and catalog_product_index_eav tables. I always have backup but only in this database backup broken. Now in backend I can see all products but no price,no name,no attributes.

  • did you solve this issue?
    – Aboodred1
    May 17, 2018 at 17:44

1 Answer 1


Those index tables could be regenerated again once you reindex magento.

Go to the admin section -> System -> Index Management -> Reindex All

Or you could use magerun command line instead.

Go to your root project folder and type the following:

./n98-magerun.phar index:reindex:all

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.