I have 60 million product in my Magento 2 Store.

On running sudo php bin/magento indexer:reindex it will run successfull for only 2 the don't know why it doesn't show any error.

enter image description here

enter image description here

Any it will not validate further so my product are not visible on froentend

Any help is appreciated.

  • Probably 60m products need time to reindex. Open another terminal tab and check the indexers status by running php bin/magento indexer:status
    – Nikolas
    Commented Dec 20, 2020 at 15:14
  • @Nikolas Thanks for your response. catalog_category_product | Category Products | Processing it will show processing from last 1.5 days any idea about when it will complete or any error which will log.
    – Prits
    Commented Dec 20, 2020 at 15:23
  • magento version ??? Commented Dec 21, 2020 at 6:28
  • @RkRathod Magento version = 2.3.5-p1
    – Prits
    Commented Dec 21, 2020 at 6:52
  • can you add screen shot of bin/magento indexer:status Commented Dec 21, 2020 at 9:21

2 Answers 2


go to your root Magento directory run the below commands to reset index for category products

php bin/magento indexer:reset catalog_category_product
  • after that run indexer again Commented Dec 21, 2020 at 10:49
  • Thanks for your response i have tried that but still it will show in processing from around 15 min.
    – Prits
    Commented Dec 21, 2020 at 11:19

can you reindex one by one instead of reindexing all at a time

php bin/magento indexer:reindex catalog_category_product 
php bin/magento indexer:reindex catalog_product_category
  • Thanks for your response I have done that also but it is still in working from around 3 days.
    – Prits
    Commented Jan 13, 2021 at 14:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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