I need some help I have added new products in the Backend and they are showing in the DB but not showing on the front page. Also, previously out of stock products are not showing as well after enabling them to be back in stock. I flushed cache and reindex as well without any success.

Has this got something to do with the Cron Job? If yes can someone guide me in the right direction on how to set up multiple cron jobs in cPanel?

I've one cron job running already isn't that enough?

10 Answers 10


At magento , after every products upload,you need a re-index required.

At,Magento2 For run the Reindex,you should setup cron job.

If you want reindex immediate then you should run php bin/magento indexer:reindex command from Terminal

  1. Check product enable or not
  2. Assign product to websites
  3. Assign product to categories
  4. Change product stock status to in stock
  5. Check product visibility config
  6. Reindex and flush cache

Also check the Store View level.


Showing products is not related to cron. Please open your admin panel > Manage product grid and pick any one id from Id column. For example id is 2. Now go to frontend of your site. after your site url just write: catalog/product/view/id/2 and it will show you the product with id 2 and may be you can get what exact error you are having.


There are various configuration options for showing products that are out of stock.

By default with Magento 2.2.2, new products indicated as being 'in stock' but having a quantity of zero will not appear in search results.

To disable inventory for your product if that's the issue, click 'Advanced Inventory' then underneath the 'Manage Stock' dropdown uncheck the 'Use Config Settings' checkbox and then set it to 'No'.

After one more re-index your product should now show up in the site search results.


check out https://github.com/Itonomy/magento2-product-visibillitygrid. It will show all "conditions" for a product to show and a function to reindex it, when needed. Good luck!


You need reindex data after add new product


You can use the CLI command to reset the status:

bin/magento indexer:reset

Or run this SQL command:

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

Then use this:

alias mage="php -d memory_limit=-1 -f bin/magento"
mage cache:flush &&
mage indexer:reindex;
  • bin/magento indexer:reset would probably be better than updating the SQL database directly – Barry Nov 1 '19 at 14:13

caused by index not right for this product.

Solution: run following commands:

php bin/magento indexer:reset
php bin/magento indexer:info
php bin/magento indexer:status
php bin/magento indexer:reindex

Run following commands:

-php bin/magento ca:cl

-php bin/magento ca:fl

-php bin/magento indexer:reindex

-php bin/magento se:up && chmod -R 777 var/ pub/ generated/

If it did not solve the issue check the product view widget capacity and increase it.


As the product informations are stored in multiple tables in Magento, When you add a new product or do some major changes in product configurations. You have to do the following steps : php bin/magento indexer:reindex php bin/magento cache:flush

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.