cancel
Showing results for 
Search instead for 
Did you mean: 

Why new products don't show until reindex?

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Why new products don't show until reindex?

Hi to everyone. I'm experiencing a weired issue, that is, when I add new products (manually via backend, or import via csv file) that these products don't show up, until I go to command line and run

php-7.0.15 bin/magento indexer:reindex

That is strange, because I have my cron jobs setup correctly and they do execute every minute, I can confirm that by checking my /var/log/cron.log

Apr 22 10:05:01 websrv4 CRON[33215]: (magento) CMD (php-7.0.15 /var/www/mywebpage.com/html/bin/magento setup:cron:run >> /var/www/mywebpage.com/html/var/log/setup.cron.log)
Apr 22 10:06:01 websrv4 CRON[33225]: (magento) CMD (php-7.0.15 /var/www/mywebpage.com/html/update/cron.php >> /var/www/mywebpage.com/html/var/log/update.cron.log)
Apr 22 10:06:01 websrv4 CRON[33226]: (magento) CMD (php-7.0.15 /var/www/mywebpage.com/html/bin/magento cron:run | grep -v "Ran jobs by schedule" >> /var/www/mywebpage.com/html/var/log/magento.cron.log)
Apr 22 10:06:01 websrv4 CRON[33227]: (magento) CMD (php-7.0.15 /var/www/mywebpage.com/html/bin/magento setup:cron:run >> /var/www/mywebpage.com/html/var/log/setup.cron.log)

Ok, I thougt it is some issue with cron, so I went to command line and executed this command manually, but still no effect. I have also checked the status of indexer and they look like the fire as supposed, but don't do the work they should.

Design Config Grid:                                Update by Schedule
Customer Grid:                                     Update by Schedule
Category Products:                                 Update by Schedule
Product Categories:                                Update by Schedule
Product Price:                                     Update by Schedule
Product EAV:                                       Update by Schedule
Stock:                                             Update by Schedule
Catalog Rule Product:                              Update by Schedule
Catalog Product Rule:                              Update by Schedule
Catalog Search:                                    Update by Schedule
Design Config Grid:                                Ready
Customer Grid:                                     Ready
Category Products:                                 Ready
Product Categories:                                Ready
Product Price:                                     Ready
Product EAV:                                       Ready
Stock:                                             Ready
Catalog Rule Product:                              Ready
Catalog Product Rule:                              Ready
Catalog Search:                                    Ready

magent_indexers.png

I'm running this on CE 2.1.6, php 7. Any idea?

4 REPLIES 4

Re: Why new products don't show until reindex?

Hi @tofi

 

Quickest way to fix this issue is to change indexers to 'Update on Save' so whenever there is a change in the system, Magento will reindex. 

Magento Certified Solution Specialist | Lead Magento developer
If this response was helpful to you, consider giving kudos to this post

Re: Why new products don't show until reindex?

Thanks, but when does that "Update on Save" fire? I mean, if I add/chage/delete product, it is ok to fire it. But will it fire also when I change some static block, adding text and pictures, something that is not directly related to products. In the later case I don't like to fire it for performance reasons.

 

On the other side, what if I import new products from CSV, will it fire or not? Well I can give it a try to see how it works, thanks.

Re: Why new products don't show until reindex?

@tofi

 

it only fires whenever CRUD operations are done on the catalogue. It has nothing to do with static content/blocks. 

 

Regarding the CSV, yes, it should update. I imported catalogue via csv and it worked absolutely fine. You might wanna give it a go too. 

 

I hope I was able to help Smiley Happy 

Magento Certified Solution Specialist | Lead Magento developer
If this response was helpful to you, consider giving kudos to this post

Re: Why new products don't show until reindex?

Ok, thanks, will give it a try and report back.