Magento 2: New Customers display issue in Admin Customer GridHandling 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
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 grammatical 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
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
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
run this commandphp 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 triedUpdate 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
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
magento2 customer-grid
asked yesterday
Zulqarnain Abdul JabbarZulqarnain Abdul Jabbar
312
312
run this commandphp 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 triedUpdate 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 |
run this commandphp 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 triedUpdate 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
run this command
php bin/magento indexer:reindex customer_grid
after check it check your indexer settings and crontab setup!– Rakesh Donga
yesterday
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
@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
1
@ZulqarnainAbdulJabbar have you tried
Update on Save
mode in admin for the cutomer grid?– Knight017
yesterday
@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
you have raised a good point. +1 for that
– Shoaib Munir
19 hours ago
add a comment |
1 Answer
1
active
oldest
votes
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
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 tablecron_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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
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 tablecron_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
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 tablecron_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
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
answered 19 hours ago
Shoaib MunirShoaib Munir
2,2231828
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 tablecron_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 |
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 tablecron_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
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
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
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 |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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