Catalog Products – How to Fix Products Not Showing on Website

advanced-searchcatalogproductssearch

Since today, my products have stopped displaying on the website! I don't remember making any changes to .xml, .phtml files. I have already gone through checking the stock, inventory, enabled, visibility, cache, index and so on. But they still won't show up.

I can still navigate to the products with the url-key. Also, noteworthy is that when I search for the products using search or advanced search, it comes up with results, but it just won't display it. Please see the screenshots below to understand the issue.

EDIT: Also, both search and advanced search seem to break the page i.e the footer doesn't show up too.

Case 1

However, when searching for a "hot huez" (name of a product), which matches the title of the product, it returns with what I believe to be the results without the actual product?

enter image description here

Case 2 (advanced search)

The advanced search even acknowledges that there is a product matching the criteria, but still doesn't display it. I'm at my wit's end, does anyone have any idea, what I might be missing?

enter image description here

Any help is greatly appreciated!

Best Answer

So after spending a few hours, I have finally found out the issue. I hope that this will help others facing the same issue and have no clue how to resolve it.

So what is the issue causing search to malfunction an break the HTML Page?

It's...

System > Configuration > Catalog > Use Flat Catalog Product

So, if you have "innocently" changed this setting to "Yes", this is going to break your search! So make sure this is set to "No" (like it is by default) and hopefully things should return to the normal course!

Phew!

Related Topic