Products don't show in search results or categories after data reset

Question

I recently needed to clear my test data, so I ran through the steps in this post: Clearing Magento after testing

Ever since then any products I add don't show up in categories (I've confirmed they're assigned to a category) or in search results (autocomplete looks like there should be results). The thing that makes it weird is that if I pull the slug for a product from the admin I can navigate directly to the product page. So the products are visible on the front end, they're just not showing up, almost like there's a broken association somewhere.

I've gone through re-index, I've cleared cache, I've tried manually adding a new product with various inventory settings. Nothing seems to get a product to show up in category nav or search results.

I'll provide anything I can, I'm just not sure what is relevant here.

Answer 1

You might have a indexing issue.

Kindly run following command and then check again.

php bin/magento indexer:reset
php bin/magento indexer:reindex 
php bin/magento c:f

If this helps you then hit like and accept as answer.

Meanwhile, enjoy your coding !!! :)

Thank you,
Hiren Patel

Answer 2

In my experience this is an issue with the Category Products index so make sure you are indexing that specific one.

Another thing can be the Websites configuration of each of your products. If you edit a product there is a Websites tab. Ensure that your products have a website selected. Also check the catalog_product_website table to check the current associations. You might have to reassign everything if this information is missing and the reindex everything.

Another, last resort, thing you can try is modifying the source code for app/code/core/Mage/CatalogSearch/Model/Layer.php temporarily more specifically the prepareProductCollection method.

You should comment the following lines

Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection);

If the products appear the for sure you have an indexing problem.