Configurable Product not showing in Category

[raymagedev]

Hi all,

I've encounter issue in my Magento 1.9.1 where Configurable products not showing in Category.

The FF already checked multiple times

- qty

- visibility (Catalog,Search for Parent, Not Visible indi for Associated Product)

- category

- website

- status

- cache

- reindex

- same attribute set for parent and associated product

- Parent product has associated product listed in Associated Tab

I tried to dissect the query on Category page and saw that my configurable products doesn't have entry in catalog_product_index_price. I tried to reindex multiple times but no luck.

Note: I tried to search on this forum before posting this but cant find solution for catalog_product_index_price.

Thank you in advance,

Ray

[Damian Culotta]

Hi @raymagedev,

Maybe your product is out of stock and you are hidding products without stock?

[raymagedev]

Hi Damian,

The Configurable product qty is 0 because its the parent and there's no way to add qty to the parent. The associated product has qty and In-Stock. Parent product also set to stock. I'm just wondering my the configurable product doesnt have entry in catalog_product_index_price but the associated products to it has entry to the said table.

Below is the part of the query that prevents configurable product for showing. This is not my custom query, its the query generated from ProductCollection->getSelect(); in category page.

INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id

[raymagedev]

So I decided to download a fresh magento 1.9 copy and install it on my local. No third party modules no products as in from scratch

Steps I've done.

- Create store view

- Create  Category

- Create Size Attribute

- Create Attribute Set

- Added the Size to my new Attribute Set

- Create Configurable Product (status, visibility, website, category set)

- Create Associated Product (status, visibility, qty, weight set after saving I edit the child product and added website, category)

- Clear Cache, Reindex

- Upon viewing frontend I saw my newly created Category without products so I decided to print the query and saw same query from my live website. The query is looking to catalog_product_index_price.

- so I decided to check catalog_product_index_price and surprised that only my child product has entry into the said table (entity_id 2 my associated simple product, my configurable product which is the parents is entity_id = 1 ). Meaning the behavior is the same to my Live Magento. Does it mean Configurable product wont really be able to view in Category page? or I need to update some settings? or this is a bug?

[Gendos_ua]

For those who stumble upon this question. 

Most likely the problem is with configurable attribute's "backend_type" field, it must be always of type "int", and not "varchar" or whatever. 

Source: https://magento.stackexchange.com/a/97328/47383

[JayalakshmiK]

Hi team,

I am also got same error on  configurable products are not showing in category products.Did u got any solution for this issue?

[albert_jason]

Did you use the Organic Internet extension which is the SimpleCOnfigurableProducts? If so, the simplest fix will be to make changes on this file app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php From:

$select->columns(array( 'entity_id' => new Zend_Db_Expr('e.entity_id'), 'customer_group_id' => new Zend_Db_Expr('pi.customer_group_id'), 'website_id' => new Zend_Db_Expr('cw.website_id'), 'tax_class_id' => new Zend_Db_Expr('pi.tax_class_id'), 'orig_price' => new Zend_Db_Expr('pi.price'), 'price' => new Zend_Db_Expr('pi.final_price'), 'min_price' => new Zend_Db_Expr('pi.final_price'), 'max_price' => new Zend_Db_Expr('pi.final_price'), 'tier_price' => new Zend_Db_Expr('pi.tier_price'), 'base_tier' => new Zend_Db_Expr('pi.tier_price') )); To: $select->columns(array( 'entity_id' => new Zend_Db_Expr('e.entity_id'), 'customer_group_id' => new Zend_Db_Expr('pi.customer_group_id'), 'website_id' => new Zend_Db_Expr('cw.website_id'), 'tax_class_id' => new Zend_Db_Expr('pi.tax_class_id'), 'orig_price' => new Zend_Db_Expr('pi.price'), 'price' => new Zend_Db_Expr('pi.final_price'), 'min_price' => new Zend_Db_Expr('pi.final_price'), 'max_price' => new Zend_Db_Expr('pi.final_price'), 'tier_price' => new Zend_Db_Expr('pi.tier_price'), 'base_tier' => new Zend_Db_Expr('pi.tier_price'), 'group_price' => new Zend_Db_Expr('pi.group_price'), 'base_group_price' => new Zend_Db_Expr('pi.group_price') )); And... From: $outerSelect->columns(array( 'customer_group_id', 'website_id', 'tax_class_id', 'orig_price', 'price', 'min_price', 'max_price' => new Zend_Db_Expr('MAX(inner.max_price)'), 'tier_price', 'base_tier', #'child_entity_id' )); To: $outerSelect->columns(array( 'customer_group_id', 'website_id', 'tax_class_id', 'orig_price', 'price', 'min_price', 'max_price' => new Zend_Db_Expr('MAX(inner.max_price)'), 'tier_price', 'base_tier', 'group_price', 'base_group_price' #'child_entity_id' ));

Hope that helps.

if you can't understand 

click below link :

https://magento.stackexchange.com/questions/235660/configurable-product-isnt-displaying-in-categorie...

https://www.5staressays.com/blog/persuasive-essay-topics

https://stackoverflow.com/questions/14848405/magento-configurable-product-are-not-showing-in-the-cat...

[gypsy1739g74c8]

Computerized Teletext will be undeniably more complex than current content administrations and have the look and feel of the web. It will be anything but difficult to peruse and use, with more noteworthy access to data and better illustrations. It gives a solid, helpful and fast educational assistance. Music Choice gives 44 channels of computerized quality music 24 hours every day. This is a definitive help for the music-sweetheart - no DJ's, no publicizing and extra data readily available. Disc and specialists' subtleties are shown on screen whenever mentioned. real estate pakistan SkyDigital offers countless new channels from British and International program producers with quality that Sky accepts will be magnificent. This incorporates two new games channels - MUTV, the new Manchester United Football Club channel, and Sky Sports News; new non-membership channels from the BBC, including the fresh out of the box new BBC Choice - the BBC's first new amusement divert in more than 30 years; and new music video channels from MTV - M2 - and 44 sound channels of advanced quality music.

[rashidqu708f94]

Automated Teletext will be irrefutably more perplexing than current substance organizations and have the look and feel of the web. It will be anything besides hard to scrutinize and use, with progressively important access to information and better delineations. It gives a strong, accommodating and quick instructive help. Music Choice gives 44 channels of mechanized quality music 24 hours consistently. This is an authoritative assistance for the music-darling - no DJ's, no publicizing and additional information promptly accessible. Plate and masters' nuances are appeared on screen at whatever point referenced. ZemBuilders is a Real Estate and Construction Company is Islamabad. You can also Buy New and Luxurious Homes, Apartments, Flats, and Commercial Areas. Just Visit website and get appointment.

[yimtiaz35g6311]

Automated Teletext will be much more complex than your current material organization and will have the look and feel of a web. It will be difficult to peruse and use, with more notable access to data and better illustrations. It is powerful, accommodating and provides fast educational help. Music Choice offers 44 channels of computerized quality music 24/7. This is authoritative support for music lovers. DJs, promotions and additional information are not immediately accessible. Whenever the subtleties of discs and experts are mentioned, they are displayed on the screen. Red is a lahore real estate network, You can also buy new and luxurious homes, apartments, flats and commercial areas.