Mrthdrb

Did US corporations pay demonstrators in the German demonstrations against article 13?

Longest common substring in linear time

Will adding a BY-SA image to a blog post make the entire post BY-SA?

Could the E-bike drivetrain wear down till needing replacement after 400 km?

anything or something to eat

Proving a function is onto where f(x)=|x|.

Did arcade monitors have same pixel aspect ratio as TV sets?

Journal losing indexing services

Has Darkwing Duck ever met Scrooge McDuck?

Create all possible words using a set or letters

Bob has never been a M before

Can a Necromancer reuse the corpses left behind from slain undead?

How should I respond when I lied about my education and the company finds out through background check?

Indicating multiple different modes of speech (fantasy language or telepathy)

How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?

How will losing mobility of one hand affect my career as a programmer?

How can "mimic phobia" be cured or prevented?

Is it possible to use .desktop files to open local pdf files on specific pages with a browser?

Does the Mind Blank spell prevent the target from being frightened?

Customize circled numbers

Diode in opposite direction?

What is the gram­mat­i­cal term for “‑ed” words like these?

Flux received by a negative charge

Greco-Roman egalitarianism

Magento 2: New Customers display issue in Admin Customer Grid

Handling many customers in the “Manage Customers” admin pageAdd Company column to Customers Admin Grid with ObserverShow customers last login in customer gridcustomer grid not showing list when added new customer using APIAdd Company Name to customers gridDisplay number of orders in customer gridCustomer admin grid new customer add where form customer attribute get in ui grid in magento2?Filter customers by custom attribute in admin gridExtend customer grid using customer_listing.xml issuedelete columns from grid customers

3

In Magento 2.1.8, Customer Grid is populating from table customer_grid_flat rather than customer_entity. This is for fastest retrieval of data. But the problem is customer_grid_flat never gets populate until I manually reindex the grid using SSH.

For a quick hack I have changed the code in blow file

Line 37: vendor/magento/module-customer/Model/ResourceModel/Grid

Old Code

$mainTable = 'customer_grid_flat',

New Code

$mainTable = 'customer_entity', //'customer_grid_flat',

Now some columns are not showing data like Name, Phone, Country etc. because of missing joins with relevant tables. Can anyone please suggest any better solution.

magento2 customer-grid

share|improve this question

asked yesterday

Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar

312

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  run this command php bin/magento indexer:reindex customer_grid after check it check your indexer settings and crontab setup!
  
  – Rakesh Donga
  yesterday
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RakeshDonga I mentioned that I can manually reindex the grid using command you mentioned. But I want automated process. Crons are working. Index status is 'valid' always. Crontab setup is correct.
  
  – Zulqarnain Abdul Jabbar
  yesterday
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @ZulqarnainAbdulJabbar have you tried Update on Save mode in admin for the cutomer grid?
  
  – Knight017
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you have raised a good point. +1 for that
  
  – Shoaib Munir
  19 hours ago
  

  
  
  
  

add a comment | 

3

In Magento 2.1.8, Customer Grid is populating from table customer_grid_flat rather than customer_entity. This is for fastest retrieval of data. But the problem is customer_grid_flat never gets populate until I manually reindex the grid using SSH.

For a quick hack I have changed the code in blow file

Line 37: vendor/magento/module-customer/Model/ResourceModel/Grid

Old Code

$mainTable = 'customer_grid_flat',

New Code

$mainTable = 'customer_entity', //'customer_grid_flat',

Now some columns are not showing data like Name, Phone, Country etc. because of missing joins with relevant tables. Can anyone please suggest any better solution.

magento2 customer-grid

share|improve this question

asked yesterday

Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar

312

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  run this command php bin/magento indexer:reindex customer_grid after check it check your indexer settings and crontab setup!
  
  – Rakesh Donga
  yesterday
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RakeshDonga I mentioned that I can manually reindex the grid using command you mentioned. But I want automated process. Crons are working. Index status is 'valid' always. Crontab setup is correct.
  
  – Zulqarnain Abdul Jabbar
  yesterday
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @ZulqarnainAbdulJabbar have you tried Update on Save mode in admin for the cutomer grid?
  
  – Knight017
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you have raised a good point. +1 for that
  
  – Shoaib Munir
  19 hours ago
  

  
  
  
  

add a comment | 

In Magento 2.1.8, Customer Grid is populating from table customer_grid_flat rather than customer_entity. This is for fastest retrieval of data. But the problem is customer_grid_flat never gets populate until I manually reindex the grid using SSH.

For a quick hack I have changed the code in blow file

Line 37: vendor/magento/module-customer/Model/ResourceModel/Grid

Old Code

$mainTable = 'customer_grid_flat',

New Code

$mainTable = 'customer_entity', //'customer_grid_flat',

Now some columns are not showing data like Name, Phone, Country etc. because of missing joins with relevant tables. Can anyone please suggest any better solution.

magento2 customer-grid

share|improve this question

asked yesterday

Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar

312

$mainTable = 'customer_grid_flat',

$mainTable = 'customer_entity', //'customer_grid_flat',

share|improve this question

asked yesterday

Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar

312

share|improve this question

asked yesterday

Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar

312

asked yesterday

Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar

312

asked yesterday

Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar

312

1 Answer
1

active

oldest

votes

0

Step 1: Go to

System -> Index Management

Check if customer data cron is set to "Update on Save", if it is not, then set it.

Step 2: check if cron scheduled properly, if it is not then set it through shell.

* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento cron:run 2>&1 | grep -v "Ran jobs by schedule" >> /var/www/Your_Project/var/log/magent$
* * * * * /usr/bin/php7.1 /var/www/Your_Project/update/cron.php >> /var/www/Your_Project/var/log/update.cron.log
* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento setup:cron:run >> /var/www/Your_Project/var/log/setup.cron.log

Note: You need to set location of your project and php path propely in scheduling

Step 3: Go to:

Store -> Configuration -> Advanced -> System

Expend tab: Cron (Scheduled Task)

Make sure "General Scheduled Every" is set to 1

share|improve this answer

answered 19 hours ago

Shoaib MunirShoaib Munir

2,2231828

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you @Shoaib for your valuable response. 'Update on Save' is not working for me. At least 22 new customers from Yesterday till now but not reflecting in the grid until I reindex the grid via reindex command. Cron setup is correct at my end. If I set customer-grid reindex to 'invalid' then cron picks it and updates the grid. Problem is, reindexer is not setting to 'invalid' after new customer creation in the system. I am thinking to do this link now to invalidate the index after new signup. Link is of Magento 1
  
  – Zulqarnain Abdul Jabbar
  13 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check table cron_schedule it will tell you the error if something happening wrong. I had faced same issue before, and got error from this table
  
  – Shoaib Munir
  10 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267094%2fmagento-2-new-customers-display-issue-in-admin-customer-grid%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Step 1: Go to

System -> Index Management

Check if customer data cron is set to "Update on Save", if it is not, then set it.

Step 2: check if cron scheduled properly, if it is not then set it through shell.

* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento cron:run 2>&1 | grep -v "Ran jobs by schedule" >> /var/www/Your_Project/var/log/magent$
* * * * * /usr/bin/php7.1 /var/www/Your_Project/update/cron.php >> /var/www/Your_Project/var/log/update.cron.log
* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento setup:cron:run >> /var/www/Your_Project/var/log/setup.cron.log

Note: You need to set location of your project and php path propely in scheduling

Step 3: Go to:

Store -> Configuration -> Advanced -> System

Expend tab: Cron (Scheduled Task)

Make sure "General Scheduled Every" is set to 1

share|improve this answer

answered 19 hours ago

Shoaib MunirShoaib Munir

2,2231828

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you @Shoaib for your valuable response. 'Update on Save' is not working for me. At least 22 new customers from Yesterday till now but not reflecting in the grid until I reindex the grid via reindex command. Cron setup is correct at my end. If I set customer-grid reindex to 'invalid' then cron picks it and updates the grid. Problem is, reindexer is not setting to 'invalid' after new customer creation in the system. I am thinking to do this link now to invalidate the index after new signup. Link is of Magento 1
  
  – Zulqarnain Abdul Jabbar
  13 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check table cron_schedule it will tell you the error if something happening wrong. I had faced same issue before, and got error from this table
  
  – Shoaib Munir
  10 hours ago
  

  
  
  
  

add a comment | 

0

Step 1: Go to

System -> Index Management

Check if customer data cron is set to "Update on Save", if it is not, then set it.

Step 2: check if cron scheduled properly, if it is not then set it through shell.

* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento cron:run 2>&1 | grep -v "Ran jobs by schedule" >> /var/www/Your_Project/var/log/magent$
* * * * * /usr/bin/php7.1 /var/www/Your_Project/update/cron.php >> /var/www/Your_Project/var/log/update.cron.log
* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento setup:cron:run >> /var/www/Your_Project/var/log/setup.cron.log

Note: You need to set location of your project and php path propely in scheduling

Step 3: Go to:

Store -> Configuration -> Advanced -> System

Expend tab: Cron (Scheduled Task)

Make sure "General Scheduled Every" is set to 1

share|improve this answer

answered 19 hours ago

Shoaib MunirShoaib Munir

2,2231828

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you @Shoaib for your valuable response. 'Update on Save' is not working for me. At least 22 new customers from Yesterday till now but not reflecting in the grid until I reindex the grid via reindex command. Cron setup is correct at my end. If I set customer-grid reindex to 'invalid' then cron picks it and updates the grid. Problem is, reindexer is not setting to 'invalid' after new customer creation in the system. I am thinking to do this link now to invalidate the index after new signup. Link is of Magento 1
  
  – Zulqarnain Abdul Jabbar
  13 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check table cron_schedule it will tell you the error if something happening wrong. I had faced same issue before, and got error from this table
  
  – Shoaib Munir
  10 hours ago
  

  
  
  
  

add a comment | 

Step 1: Go to

System -> Index Management

Check if customer data cron is set to "Update on Save", if it is not, then set it.

Step 2: check if cron scheduled properly, if it is not then set it through shell.

* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento cron:run 2>&1 | grep -v "Ran jobs by schedule" >> /var/www/Your_Project/var/log/magent$
* * * * * /usr/bin/php7.1 /var/www/Your_Project/update/cron.php >> /var/www/Your_Project/var/log/update.cron.log
* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento setup:cron:run >> /var/www/Your_Project/var/log/setup.cron.log

Note: You need to set location of your project and php path propely in scheduling

Step 3: Go to:

Store -> Configuration -> Advanced -> System

Expend tab: Cron (Scheduled Task)

Make sure "General Scheduled Every" is set to 1

share|improve this answer

answered 19 hours ago

Shoaib MunirShoaib Munir

2,2231828

* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento cron:run 2>&1 | grep -v "Ran jobs by schedule" >> /var/www/Your_Project/var/log/magent$
* * * * * /usr/bin/php7.1 /var/www/Your_Project/update/cron.php >> /var/www/Your_Project/var/log/update.cron.log
* * * * * /usr/bin/php7.1 /var/www/Your_Project/bin/magento setup:cron:run >> /var/www/Your_Project/var/log/setup.cron.log

share|improve this answer

answered 19 hours ago

Shoaib MunirShoaib Munir

2,2231828

answered 19 hours ago

Shoaib MunirShoaib Munir

2,2231828

answered 19 hours ago

Shoaib MunirShoaib Munir

2,2231828