Search code examples
phpmagentomagento2

Customer grid is empty in magento 2

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). enter image description here

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?

Solution

  • 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.