Customer Grid is showing empty or blank in magento 2:
Some times customer grid will show empty or blank in magento2 admin section when you redirect to customer grid. This is because of re-indexing. By default magento customer grid is coming under the re-indexing module. When you do the re-indexing using terminal we may come to know the customer grid re-indexing .This option is not in magento1.x. In case if your re-indexing is not properly complete then we may get this issue. Other re-index will work perfect but only customer grid get stopped or not re-indexing fully)Your data will be available in DB but your customer data won't be available on Customer Grid table (empty) in that scenario grid will show empty. Resolve: 1. Using below mysql query we come to know customer record is available on DB main tables or not. (If here its empty then you loose your customer records) select * from customer_entity limit 10; 2. Using below query we come to know customer record is available on customer grid table or not. If empty with table then your customer grid will blank or empty. select * from customer_grid_flat limit 10; 3. Using below query check to your reindexing table status. select * from indexer_state; 4.Update your re-index status (Check in case if customer admin grid re-index status is working or valid update indexer_state set status='invalid' where status ='working' 5. Run once again re-indexing. php bin/magento indexer:reindex 6. Now you will get admin customer grid Some times when you do re-index you may get memory issue. Then use below command and change memory size (based on your server) & run php -d memory_limit=1024M bin/magento indexer:reindex (or) php -d memory_limit=2084M bin/magento indexer:reindex
CORNER OF BLOG: