Magento 2 – Fixing Customers Not Showing in Backend Grid

magento-2.0.2magento2reindex

There are customers imported from Magento 1.9.1.0 which are in customer eav customer_entity and related tables. But admin customer grid shows no records. I have also tested adding new customer from the backend, they are added. Those imported customers can login in the frontend. Customer Index Management always shows processing.

enter image description here

I have tried to manually reindex bin/magento indexer:reindex customer_grid.

It doesn't seem to do anything. I don't think setting up cron will help either. However, it is my localhost.

Customer Grid index has been rebuilt successfully in 00:00:00

Your suggestions are highly appreciated.

Thank you in advance

Best Answer

Looks like some error happened in the process of re-index and index status left processing. You need to reset it DB.

For example by query:

update indexer_state set status = 'invalid' where status != 'valid';

Then run:

php -f bin/magento indexer:reindex
Related Topic