Why are my Magento products not showing up?!

July 14, 2010

This is a just a quickie – got caught out with a weird issue yesterday where the Magento products in a particular category just disappeared – they still existed if you navigated directly to their URL, but they would not show in their categories (though the Manage Categories screen in the Magento admin still showed those products in their correct category).

These things always happen at inopportune times, I was right about to start a pre-go-live review of a site, and was left with one category completely devoid of products, thanks for making me look like an egg, Magento!

It prompted me to begin a sequence of steps I have found myself often taking to diagnose why products do not appear on the Magento frontend like I expect them to. I thought it might be worth documenting those steps I take and things I check to find out what is preventing a product to show up. Ironically yesterday, I got to the end of my usual list and the products still didn’t show up! So I now have one other thing to suggest you try when products appear to inexplicably stop displaying.

Here we go with my top things to check for when your products don’t show up:

Are the products In Stock?
I know it sounds obvious but when you’re adding a quick test product, it’s easy to miss this field, trust me. Make sure it’s set to In Stock as shown below:

Product in stock

You can also set up the inventory configuration to Display out of stock products, which sort of negates this one if it is set to Yes:

Confugure inventory to show out of stock

Are the products Enabled?

Again another easy one to miss when adding a product manually, not so easy to stuff up if you use bulk product imports though. Interestingly the fix I eventually found below involved this attribute.

Enabled status

Are the products Visible?

In some merchandising situations you want your simple products to be invisible and only show the parent products. However if you do want your product to be visible make sure you set it where applicable in this field.

Check the visibility

Are any associated products in stock?

If you have a complex product like a bundled or configurable product, at least one of the simple products that comprise it must be in stock and enabled (almost a bit of a recursion on this list, eh?!). A well behaved configurable will have an associated products tab that looks a bit like this:

Check Associated Products

Are the products in the expected category?

More of a sanity check than anything, but the individual product should be reporting it belongs to the correct category like this:

Expected Category

Are your Caches and Indexes out of date?
It never hurts to clear/reindex these when you’re scratching your head, it’s getting pretty desperate if you’re still with me to here!

Access these options in the System -> Cache Management and System -> Index Management menus.

Clear your Cache

Reindex

Have you run out of other things to try?
And lastly – the weird situation I had yesterday where the products were visible when navigating directly, but not when looking at their category page (and oddly it only affected one category). I suspect this must be to do with an index table not being correct, or a cache, but I tried re-indexing and refreshing the cache to no avail, so I can’t pin it on this for sure.

Anyway, all it took to have the products re-associate with their category was to bulk disable them and then bulk re-enable them. Strange eh? I had tested a bulk attribute change earlier and that didn’t fix them, so it wasn’t just any attribute change, but particularly the status. I just wish I knew why that fixed them – but I didn’t have time to investigate further, or even try to replicate the issue. So for now It’s a ‘solar flare’ problem…

Got through all of these and still no luck? Let me know. Also I’d appreciate any feedback on other tips or suggestions people may have on this, always good to add another possible fix to my list.

Ashley

Posts

Hi! I'm Ashley Schroder, a Software Engineer from New Zealand - this is a collection of notes on my experiences with Ecommerce Web Development, particularly Magento Development.

Are Your Customers Getting The Magento Emails You Send?

MageSend Magento Email sending with Amazon SES

I have made a premium Magento Extension called MageSend. MageSend makes it simple and easy to send using Amazon's highly reliable SES email service.

The extension is $99, and comes with a complete money back guarantee, please check it out, I am confident it will resolve any email sending problems with your Magento store.

126 responses to Why are my Magento products not showing up?!

  1. thx, it solved my problem. manage product -> product -> inventory -> Stock Availability -> In Stock

  2. Had the same problem but only the newly added configurable products won’t show, doesn’t matter which attributset they’re using, if they’re copies of existing ones (status set to active, in stock, everything checked).
    Even the bulk re-enable didn’t work, if I go to the url of the configurable product it shows up, the simple products work without a problem…

  3. I am having the same issue – It happens overnight and has happened twice this week. No products show. But then I bulk disable, then enable and they show? Anyone find out why this is happening?

  4. i test the search product, but not showing up, i re index the data, now its showing up. thanks.

  5. Hey Thanks….

    Even my products were not showing up at the front end…but your solution really worked out for me.
    Thanks for such a great explaination:)

  6. Good article, have tried all of the above though, and still not showing. Have had products showing fine for around 7 months now. Performed server move around a week ago, products showing fine yesterday, around 48,000 in total, today we have 0 showing in categories. All of the products are still there, and showing at the specific product url. But all categories are empty. Categories still showing the products within them in backend. Any ideas on how to resolve would be greatly appreciated. The store is http://www.galaxystores.co.uk if you want to view the issue. Thanks.

  7. We have manage stock set to NO and status is enabled, visibility set to catalog/search.

    Product stopped showing after product name was changed. deleted core rewrite data, deleted product key and resaved, reindexed but nothing helps :(

    any help would be appreciated.

  8. Most annoyingly I have fixed my products showing in categories, but broken the products displaying at their rewritten url. Fixed products in categories using the magento database repair tool. I “think” it was down to corrupt indexes in the table that relates to products being stored in set categories. Anyone any ideas on why products might now not be showing? Have refreshed indexes etc, and tried the full list of concepts online in forums for how to get products displaying. Currently just presenting a 404 page on any product url. Categories and CMS pages display fine. Search also working fine. Most puzzling!!

  9. Syed Asghar Abbas February 7, 2013 at 10:42 am

    if the above options are not working add the below code in your home page design

    CMS > Page > home page, and then open the Design option and paste these code and save then refresh the frontend page. your product will be showing..

    enjoye..

    bundlebundle/catalog_product_pricebundle/catalog/product/price.phtml
    bundlebundle/catalog_product_pricebundle/catalog/product/price.phtml
    bundlebundle/catalog_product_pricebundle/catalog/product/price.phtml

    right.reports.product.viewed
    right.reports.product.compared

  10. Syed Asghar Abbas February 7, 2013 at 10:44 am

    bundlebundle/catalog_product_pricebundle/catalog/product/price.phtml
    bundlebundle/catalog_product_pricebundle/catalog/product/price.phtml
    bundlebundle/catalog_product_pricebundle/catalog/product/price.phtml

    right.reports.product.viewed
    right.reports.product.compared

  11. Thanks for your help with this – although none of the ideas here helped me. Im on magento 1.7.0.2. I have recently set up a second website/store running from the same backend.

    My problem was that some of the products seemed to go into the category on the second site without a problem, others would no show up at all either through URL, Category or search. Others would show up in search and URL, but not category.

    As most seasoned magento users would know. If you change from the default store view to another view (under product management) – Usually you will find all text entry boxes and options are greyed out – with a checkbox next to each one allowing you to “use default value / config”. In my case, when switching store views on the offending products, I noticed none of these “use default values” were checked. One would think – “Thats not a problem – the settings are fine” – but in actual fact, it is a problem. After I went through and checked all the “use default value” options – everything started to come back to life. -Products displaying in categories and search without issue.

    Again i must stress – I did this AFTER changing to “Second Website > Second Store > English” – If you know what I mean.

    I have a feeling this will affect every single product which was created BEFORE I created the new secondary store. Changing them all will be a very laborious task. – YAY.

    Hope this helps someone.

  12. In my case category disappearing from product just 2000 products keeping kategory nothing helping

  13. I had same problem and after trying a lot as what went wrong…I finally realized its a minor tab..
    Tried this and my product showed up..
    Catlog> Manage product> website> tick the checkbox
    I had missed that one…

  14. I had same problem and after trying a lot as what went wrong…I finally realized its a minor tab..
    Tried this and my product showed up..
    Catlog> Manage product> website> tick the checkbox > save> cache management> resfresh cache (Blocks HTML output)
    I had missed that one…

  15. thanx so much…

  16. I’ve been banging my head against the wall over this for days!
    I tried all of the above and then came across this stack overflow answer http://stackoverflow.com/questions/10297359/magento-1-5-0-1-configurable-products-attributes-not-showing-in-front-end . I removed the additional jQuery from my js folder, which I’d added a few days ago and BAM! it works but my jQuery stuff didn’t. The offender is Prototype (part of scriptalicious).
    Here’s how to get magento to play with jQuery
    http://css-tricks.com/using-jquery-in-magneto/

  17. Hi Folks, Got the same issue happening to a site we just launched. Mr Google doesn’t return a solution this time and all my efforts to retrace the bug are in vain. apart from knowing the client was editing the category descriptions.

    I will keep you all posted if a solution comes to mind. otherwise for now if anyone knows why some products (configurable + simple products) disappear from a category let me know

    Cheers!
    Steve

  18. I had the same problem for awhile i followed your steps and they didnt seem to work, so i started again this time i noticed that on the home page in cms the layout update xml was commented out and this was a fresh install of magento, soon as i uncommented the code in the layout update xml section the products were showing up as well as recently viewed products

    Hope this will help others with the same problem

  19. Thanks so much, you solved my problem.

  20. Great, it helped me :)

  21. See http://stackoverflow.com/questions/14966117/magento-wont-show-all-products-on-homepage as well. I’ve had this problem, where I used different code that didn’t show all products. This code showed all.

    {{block type=”catalog/product_list” name=”home.catalog.product.list” alias=”products_homepage” template=”catalog/product/list.phtml”}}

  22. Thanks Ashley..scratched my head for 3 hours. finally your post solved this issue. Wish Magento team put such important parameters (Stock) in a highlighted manner in the configuration window to make them more visible

  23. Easy to miss out. haha really, I did misout that part of (Stock Availability) and have been pulling my hair. Smart magento and smart you. thanks

  24. Was doing a first time setup, and not seeing my test product on the home page. The missing step was to select a widget which displays products in the Home CMS page.

  25. Anyone have any idea why the product information isn’t showing on the back end? When we go in to edit to enable/disable, there is no option.

  26. Hi,

    Also, ensure you are not using Custom Layout Updates. I had this problem then realised I was referencing a folder that didn’t exist with the theme I was using.