Magento products will not show in category

Question

I've recently been tasked with the build and deployment of a large Ecommerce site. In the past we've had to use the clients legacy X-cart installation for redevelopment (too far integrated with their existing work flow).

We'd heard good things about Magento, so I've set up a test install to get to grips with it. After a couple of initial issues, there is a live development site which displays categories on the default theme. The problem we've hit now is that products don't display..!

After a lot more in-depth research into this, all I've been able to discover is that quite a number of developers endorse using other solutions entirely, with the other 50% saying after the steep learning curve the platform is as wonderful as we'd initially been led to believe.

Now, my test category is showing, so I know this is configured properly. I've set up three test products and associated them with this (all done following the Magento user guide), checked double checked and thrice checked the products are enabled and visible individually, yet still the front end says the category has no products in it. I've cleared the cache repeatedly, reset everything possible many times in index management - no products show up.

I have to make a call tomorrow morning on whether we're going ahead with Magento. If I can't even get it to show products I'm going to have to go with something with a more established track record and more community support available. Can anybody advise what could possibly be wrong here?

Answer 1

The checklist for whether items are in stock follows. Some will seem stupid until the first time you spend an hour trying to figure this problem out:

1. The products must be Visible in Catalog.
2. The products must be Enabled.
3. Product must have a stock Quantity.
4. The product must be set to In Stock.
5. If the product is set not to track stock, it still has to have a stock Quantity and be set to In Stock.
6. The product must be assigned to the target Category.
7. If using multi-website mode (or if you imported the products through Data Flow), the products must be assigned to the target Website.
8. You must refresh your Cache / Indices, just to make sure.

Welcome to Magento. Hope that helps!

Joe

Answer 2

Praxis tip: If all products are missing the price index could be a problem. The price index table catalog_product_index_price will be joined in category product list. Also the category/product index could be corrupt. I first check the price index if all products are missing.

Answer 3

I would also add: make sure for the category under the Display Settings tab, the Display Mode is set to "Products Only" or "Static blocks and products". If this is set to "Static block only", the products will not display for the category.

Answer 4

When uploading to a category our products were unavailable to view in the catalog or search, and none of our categories were showing up.

We had to create the categories as sub categories under the pre-existing 'Default Category'.

Answer 5

Check your product stock management options, in the default config items out of stock are not being displayed.

Answer 6

please Goto Index Management, Here Reindex all listed rows

System >> Index management

It will solve your Issue...

Answer 7

Make sure PHP "GD" graphics module is installed. Magento uses it to create the product image thumbnails, etc. If it's missing you won't get any luck with Magento when it comes to seeing products anywhere. Type in your shell:

php5 -m

See if gd is in the list. If it's not, install it and restart apache by typing this in your shell:

sudo apt-get install php5-gd
sudo apachectl restart

There are more comprehensive instructions at this link.