Magento 2: Not showing customers in backend grid

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

Magento 2 not showing customers in backend grid:

Run the below commands for fix

1) php bin/magento indexer:reset customer_grid

2) php bin/magento indexer:reindex customer_grid

Thanks!

Best option is to reset and then reindex via CLI

php bin/magento indexer:reset customer_grid
php bin/magento indexer:reindex customer_grid

Related