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, 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

Magento Forum

Attributes not updating correctly in catalog_product_entity_varchar table. 
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