Why new products don't show until reindex?

[tofi]

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

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

[ShoaibRehman89]

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. 

[tofi]

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.

[ShoaibRehman89]

@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  

[tofi]

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