I have 60 Millions products in my Magento 2 Store. But when i run bin/magento indexer:reindex command. It is struck on Category Product Index. enter image description here When i check on backend it is stuck here.

[![enter image description here][2]][2] How to solve this error.Any help is appreciated.

  • Btw how many effective SKUs do you have: products * customer groups * websites? select count(*) from catalog_product_index_price? Is it Magento CE or EE? Do you have installed Inventory? Commented Dec 21, 2020 at 18:24
  • @transversus Thanks for your response how to check how many products are effective means how much more time it will take to complete is there a way to check this ?
    – Prits
    Commented Dec 21, 2020 at 18:37
  • Indexation time depends on number of effective skus (eSKUs). Websites and customer groups are multipliers for products. If you have 60 million products, but for example 10 customer groups and 10 websites, then real eSKUs are 60 millions * 10 * 10 = 6 billion. With 6 billion eSKUs it will take much longer than with 60 million products with 1 website and 1 customer group. Besides, what Magento editions do you have: open source or commerce? Do you have Inventory Management installed? Commented Dec 21, 2020 at 19:06
  • Thanks for your response I have 60 million product 4 customer groups and 1 website Magento Open source and version = 2.3.5-p1. Do you give any idea about time it will really helpfull what's this Do you have Inventory Management installed?
    – Prits
    Commented Dec 21, 2020 at 20:09

1 Answer 1


I guess with such amount of products it can take couple of hours for category product index to complete.

If your indexer is stuck in some status you can invalidate the status of your Category Products indexer by running bin/magento indexer:reset catalog_category_product command.

Magento does not recommend to keep your indexers in Update on Save mode, especially if you have about 60 million products. Please, set your indexers to Update by Schedule mode and run your indexers by cron or manually by bin/magento indexer:reindex command: https://docs.magento.com/user-guide/system/index-management.html#best-practices-for-reindexing

If you want to check for sure if indexation is still running or not, you can run show processlist command in your database. If there is only 1 process and it's show processlist, then indexation is most likely not running, and you can invalidate your stuck in processing indexer by bin/magento indexer:reset command: https://devdocs.magento.com/guides/v2.4/config-guide/cli/config-cli-subcommands-index.html


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.