How to add attribute to ALL attribute sets

Posted Date: January 25, 2010

Most of the time I face a problem to add a attribute to all attribute sets…Which is very time consuming job.

So, I wrote a little script which can help you a lot to add a attribute to all attribute sets immediately, just run the following sql command and you are done


INSERT INTO `eav_entity_attribute` (
entity_type_id,attribute_set_id,
attribute_group_id,attribute_id
)
(SELECT '10' as
entity_type_id,
`attribute_set_id` ,
`attribute_group_id`,
`attribute_id`
FROM `eav_attribute_group`,
`eav_attribute`
where
`attribute_group_name`='General'
and
`attribute_code`='test'
)