Change Magento product's attribute set.

Question

I want to change the attribute set of Magento. I searched through, and everyone suggested to delete the product and re-import it with new attribute set.

I did the same however after importing the data I could not see product reviews and associated blog post with product.

Can anyone tell me is it possible to get product reviews and associated blog post after re-importing the product with new attribute set.

Answer 1

Once set you can't change the attribute set of a product. But it's possible using this module so you don't have to reimport your data https://marketplace.magento.com/flagbit-magento-changeattributeset.html

Answer 2

It's also possible to change the attribute set directly in the database.

• Look up the attribute set ID in table eav_attribute_set
• Change the attribute set ID in catalog_product_entity

Of course, be careful when changing data this way.

Answer 3

It is fiddly to do and a bit messy:

• Make sure new attribute set is set up
• Export the products you want to change
• Delete the products that you are changing on the site
• Change the attribute set on the downloaded file
• Import changed file again
• Open each changed product, set their attribute values, save it

Or do what I do, install this great extension from Amasty http://amasty.com/mass-product-actions.html - it makes changing a breeze and gives many more time saving and enhancing options.

Answer 4

Once you delete the product you can't get the old review.

You don't need to delete the product . You can change the attribute set by editing and use. other wise create a new attribute set and create new product.