magento 2中的客户网格为空

Question

I am developing a online store with Magento 2.2.2. I have to import customer from old site. The problem i am facing, in magento 2.2.2 customer grid is empty, even not a single grid title is showing (screenshot attached).

I can add new customer successfully but new one also not showing in grid. If i try again with same email then showing customer already exists.

Solution I tried:

php bin/magento indexer:reindex

php bin/magento indexer:reindex customer_grid

php bin/magento cache:clean

php bin/magento cache:flush

Any one can help me? Did I miss anything? Is there any way that I can solve this problem?

Answer 1

After caching, re-indexing and trying few others things still i was unable to see customer in customer grid.

Then I have decided to drop following tables and import from fresh magento.

• store
• store_group
• store_website

I had a fresh magento 2.2.2 installed and i export above 3 tables and import in my dev version and It works for me. I can see all existing customer in customer grid.

I dont know what was the issue, i had no clue but after spending 2 days at last customer are back and that is enough for me now.