Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Dropdown not showing in layered navigation
 
icvu
Jr. Member
 
Total Posts:  10
Joined:  2009-01-25
 

Does anyone has the issue with dropdown values not showing up in layered navigation even though “Filterable(with results)” is selected for “Use In Layered Navigation” and there are products with this attribute populated?

I have dropdown attributes with values in them but they are not showing up in the layered navigation in version 1.4.0.0.

They were showing up in version 1.3.2.4. I use the same script to do the setup and uploading of attributes, attribute sets, and products.

It seems “multiselect” attributes are showing up in layered navigation in version 1.4.0.0 with no issue.

Here is how I made it work manually, but I rather have the script does it.

I use a script to load all the attributes, attribute sets, and products. But the dropdown values do not show on the layer navigation as they should.

However, it seems if I let the script create the attributes and attribute sets. Then manually go into the admin panel, pull up the dropdown attribute and just simply click “save”. Now, if I use the same script that I used to add products, then any product added with that attribute will show up in the layered navigation.

So, this does not work

Run script adding attributes
Run script adding products

This works.

Run script adding attributes
Manually go into admin panel, open up the dropdown attribute and click “save”
Run script add adding products

What’s special about having me go into the admin panel and “save” the attribute again that make it work, but automating the process does not work?

If someone would give a hint I would really appreciated it.

Attach is a screenshot of the attribute setup.

Image Attachments
brand_name.jpgbrand_name.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
SolsWebdesign
Jr. Member
 
Total Posts:  18
Joined:  2010-01-06
Moergestel, the Netherlands
 

Hi, we had the same problem so I had a look in the database and found that in 1.4 there is a new tabel called catalog_product_relation.
Our scripts from 1.3 do not account for that.
So make sure that your product_id of your configurable is added to this new tabel “catalog_product_relation” as parent_id. And that the simples belonging to that configurable are added as child_id to the parent_id. You may find that this solves your problem.

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagentoBackups
Jr. Member
 
Total Posts:  16
Joined:  2010-02-02
Los Angeles
 

@Isolde: Thanks a million for your posting - this was the missing piece to my layered navigation nightmare!!!

Here’s how i fixed it:

INSERT INTO catalog_product_relation (parent_idchild_id)
  
SELECT catalog_product_link.product_idcatalog_product_link.linked_product_id
  FROM catalog_product_link

Here’s some other tips I picked up along the way:
* Make sure your attributes with multiple select, drop downs, and yes/no are not searchable (a.k.a quick search).
* The only ones which should be searchable (a.k.a quick search) are text area and text field.
* Make sure your configurable products do not require a “Unique Value” in Attribute Properties
* Manually delete all cache stored in var/cache
* After making changes to tables, go Admin > Index Mgmt > rebuild “Product Attributes” than rebuild “Catalog Search Index”.

Tables that handle parent/child info:
catalog_product_link
catalog_product_link_attribute_int
catalog_product_link_attribute_decimal
catalog_product_relation

Yee-haw!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top