I've got Magento 2.2.5 installed and for some reason my products will not show on the front end of the website.
I've tried the following things in an attempt to fix it, but none of them helped:
Currently I'm at my wit's end... the products are showing up in the count when looking at the Category settings (see below), but the simply just don't show on the front-end. I just get the error that there are no products set for this category.
Bar re-installing and re-doing everything from scratch, is there anything else I can do??
Solved! Go to Solution.
Did you find anything?
I am facing the same issue on my Magento 2.2.4 using Proto theme.
Hi, the link to the solution does not work.
Desperate for an answer, experiencing the same issue with products randomly.
Check out https://github.com/Itonomy/magento2-product-visibillitygrid. It will tell you why products are visible (or not) and gives you a simple way to reindex per product.
Call this a necro post or whatever but this is NOT solved...
Running into the same issue, been at this issue for 8 hours with no luck.
Everything is visible on the back end but I cannot view products via categories or searching.
The reindex hangs and newer items don't show on the main site until days or weeks later
did you try to check the index status, reset and reindex?
php bin/magento indexer:status
to check the status of the indexes
php bin/magento indexer:reset
to reset the index
php bin/magento indexer:reindex
to reindex all
we saw index stuck on some third party extensions and indexer:status will show you more details. This has to be run in ssh under your magento user and "php" may need to have a path to your current php location.
or just ask your host to check this for you
Please check product salable quantity, This issue can come if the salable quantity is zero to fix that please make sure you have a view table inventory_stock_1 in your database.
This issue can come if you have migrated database from one to another so that time you may be missed to migrate view tables.
This solution worked for me. After i run all three commands, my products showed up again. (The solution of Finestshops)