CODEWITHSUNDEEP
magentomagento-1.7magmi
Satyendra Mishra
Satyendra Mishra

Reputation: 533

Change Magento product's attribute set.

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.

Upvotes: 6

Views: 32975

Answers (6)

mtwde
mtwde

Reputation: 289

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.

EDIT: The module is no longer available on the Magento Marketplace website. See the GitHub page: https://github.com/flagbit/Magento-ChangeAttributeSet

Upvotes: 12

Pedro Amaro
Pedro Amaro

Reputation: 1

You can add to your data patch apply function something like this:

public function apply(): self
{
    $this->moduleDataSetup->getConnection()->startSetup();
    /** @var EavSetup $eavSetup */
    $eavSetup = $this->eavSetupFactory->create(['setup' => $this->moduleDataSetup]);


    $eavSetup->addAttributeToSet(
        Product::ENTITY,
        'Default',
        'General',
        CustomAttributesInterface::ATTRIBUTE_CODE_MANUFACTURER
    );
    
    $this->moduleDataSetup->getConnection()->endSetup();

    return $this;
}

This changes the manufacturer products attribute to the Default attribute set. (By default this attribute has no attribute set.) Hope it helps :)

Upvotes: 0

Kazim Noorani
Kazim Noorani

Reputation: 323

Yes. We can change product attribute set programmatically. I prefer to create massaction in catalog product grid to multiselect product and then select massaction for the products.

Creating massaction in grid.php

$sets = Mage::getResourceModel('eav/entity_attribute_set_collection')
                ->setEntityTypeFilter(Mage::getModel('catalog/product')->getResource()->getTypeId())
                ->load()
                ->toOptionHash();

$this->getMassactionBlock()->addItem('changeattributeset', array(
                'label'=> Mage::helper('catalog')->__('Change attribute set'),
                'url'  => $block->getUrl('*/*/changeattributeset', array('_current'=>true)),
                'additional' => array(
                    'visibility' => array(
                        'name' => 'attribute_set',
                        'type' => 'select',
                        'class' => 'required-entry',
                        'label' => Mage::helper('catalog')->__('Attribute Set'),
                        'values' => $sets
                    )
                )
            ));

Creating controller action for change attribute sets of the selected products.

public function changeattributesetAction()
{
    $productIds = $this->getRequest()->getParam('product');
    $storeId = (int)$this->getRequest()->getParam('store', 0);
    if (!is_array($productIds)) {
        $this->_getSession()->addError($this->__('Please select product(s)'));
    } else {
        try {
            foreach ($productIds as $productId) {
                $product = Mage::getSingleton('catalog/product')
                        ->unsetData()
                        ->setStoreId($storeId)
                        ->load($productId)
                        ->setAttributeSetId($this->getRequest()->getParam('attribute_set'))
                        ->setIsMassupdate(true)
                        ->save();
            }
            Mage::dispatchEvent('catalog_product_massupdate_after', array('products'=>$productIds));
            $this->_getSession()->addSuccess(
                    $this->__('Total of %d record(s) were successfully updated', count($productIds))
                );
            }
            catch (Exception $e) {
                $this->_getSession()->addException($e, $e->getMessage());
            }
    }
    $this->_redirect('adminhtml/catalog_product/index/', array());
}

Upvotes: 0

dmaij
dmaij

Reputation: 1007

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.

Upvotes: 5

darrylxxx
darrylxxx

Reputation: 21

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.

Upvotes: 2

Arul Manickam
Arul Manickam

Reputation: 31

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.

Upvotes: 1

Related Questions