Magento Forum

   
Attributes not updating correctly in catalog_product_entity_varchar table. 
 
Scott_TriState
Member
 
Total Posts:  35
Joined:  2008-06-06
 

I’m having an issue that I hope someone in this forum might be able to help with:

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. Strange behavior indeed.

Now, I can’t seem to find where the insert is happening in the catalog_product_entity_varchar but I have to assume it’s when you create the attribute in the admin area. Anyone with any advice on this would be a hero. Thanks!

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