douwei1921
2018-05-07 11:39
浏览 69
已采纳

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?

图片转代码服务由CSDN问答提供 功能建议

我正在使用Magento 2.2.2开发一个在线商店。 我必须从旧网站导入客户。 我面临的问题是,在magento 2.2.2客户网格中是空的,甚至没有显示单个网格标题(截图附件)。

我可以成功添加新客户,但新网站也不会显示。 如果我再次尝试使用相同的电子邮件,那么显示客户已存在

解决方案我试过:

  php bin / magento indexer:reindex 
 
php bin / magento indexer:reindex customer_grid 
 \  nphp bin / magento cache:clean 
 
php bin / magento cache:flush 
   
 
 

任何人都可以帮助我吗? 我错过了什么吗? 有什么方法可以解决这个问题吗?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dongxian7194 2018-05-09 04:23
    已采纳

    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.

    点赞 评论
  • duanquanzhi5560 2018-05-07 12:36

    First of all, check whether customer records exists in main table or not by using select * from customer_entity limit 2;

    Then, check customer grid table if records are available or not, use select * from customer_grid_flat limit 2;

    Before, reindexing it's better to check the state of the indexer by select * from indexer_state;

    Then, update the status of re-index to make it invalid if the customer admin grid index status is valid or in working state by using below query

    update indexer_state set status = 'invalid' where status = 'working'
    

    Now, you have to run php bin/magento indexer:reindex again

    Well, you've to update indexer_state because probably something went wrong during the re-index process, so because of that you need to reset the database entries.

    Re-index doesn't work if the status of the index is not invalid (means re-index ignores the valid and working statuses.

    点赞 评论

相关推荐 更多相似问题