Basically the subject.
I have a simple product created with a particular attribute set. Is there a way to change the attribute set associated with this product without having to create a new one?
Add a comment
|
1 Answer
The attribute set reference is a column in the catalog_product_entity table. Changing that should change the attribute set.
So if you want to do it by code:
$product->setAttributeSetId(12)->save();
If you want to do it from an admin interface you can give this extension a try. Even if it says it's compatible with CE 1.6.1, I used it with success on EE 1.12 (that is equivalent to CE 1.7).
-
2Let me add, that it is no good idea to change the attributeset, if you don't know what you are doing. There are data left in the database which might make problems. Jun 25, 2013 at 16:52
-
1
-
2
-
2@Fabien: you should elaborate on the "if you don't know what you are doing" part. As far as I can tell from looking at the DB, attribute set ID is linked only to the EAV attribute set table. After doing what Marius has suggested, the only issues I foresee are orphaned values in the catalog EAV tables as explained here, under the "technical background": magentocommerce.com/magento-connect/…. It would personally bother me to have those extra rows abandoned in the tables, so that coule be a "problem." :)– laketunaAug 23, 2013 at 15:53
-
1Flagbit extentinon just sets new attribute set ID to product and saves it. It doesn't do anything special.– vsushkovOct 28, 2015 at 8:55