Change the attribute set of a product
This article is provided at your own responsibility. We do not provide support for these solutions.
Since the attribute set of each product is fixed in Magento, changing the set is not supported. If the attribute set of a product should be changed anyway, there are two ways to do so.
Important advice: Create a backup of the store in advance before making the changes!
Solution A: local copy
Make a local copy of your products with cobby, delete the affected products and add the products again with the local copy of the data:
-
Load your products in cobby.
-
Make a copy with the table headers of the old attribute set and paste them into a new sheet (use "Paste values").
-
Now again create a copy of the entire rows of all affected products below (use "Paste values" again).
-
The created sheet must be saved in a local workbook.
-
Delete the product key of all products in the sheet.
-
Now the Magento admin panel must be opened and all affected products must be deleted. Otherwise, another SKU must be used in the other attribute group. The new SKU must also be set for Up-Selling, Cross-Selling, and Associated Products.
-
Close Excel and open the Excel sheet that was saved in step 3.
-
Set the template in cobby to "Standard" and then load the products.
-
Navigate to the attribute set where you want to store the products.
-
Then copy and paste the product data block by block at the end of the table. Meanwhile, keep an eye on the table headers, as the order of the table headers will probably differ from the old attribute set.
-
Finally, the process must be saved.
Solution B: extension installation
Install an extension that removes this limitation from Magento: Github- ChangeAttributeSet
On the positive side, this is probably the faster way. However, there are some risks:
- Any product that is moved this way will contain orphaned attribute data.
- Data integrity may suffer from having values that are not expected.