http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=2897 Posted: 2008-08-24 14:14:48
Category: Product
Version: 1.1.3
Priority: urgent
Status: closed
Reported By: Scott_TriState

The table - catalog_product_entity_varchar is where the search function is looking for it?s keywords in the value column. (probably not the only table, but stick with me.)

In this table I see an attribute ID column - One of the ids is 444 which is the attribute ID for my Models attribute. The corresponding value for that record is set to 6,5,3 which are the option ids of the attribute options and not their actual varchar values from table eav_attribute_option_value.

If I do a simple search for 6 or 5 or 3 in the search function, my desired results occur which tells me that the search function is working correctly. This issue is happening at the time of the attribute being created.

My attribute is a multiple select attribute.

This issue is preventing users from searching by product attribute. I've also posted in the forums.

---

]]> #1 / Comment by Scott_TriState

This appears to be limited to multiple select attributes and dropdowns where the dropdown is not set to configurable products.]]> #2 / Comment by Scott_TriState

It's the simple search from the front end that behaves this way. If I go to advanced search and search by model, the appropriate products appear in the results.

Now if I could just get the customers to memorize the database ID for every attribute... :-)]]> #3 / Comment by Magento Team

Hello Scott_TriState,

This issue was fixed and the changes will be available in Magento 1.1.5

Thank you.]]>