Add/Update Attribute Option Values Programmatically in Magento

23
Adding/Updating the attribute option values programmatically in Magento can be tedious sometimes. Adding attribute options through custom codes is not big deal but updating the values for already added attribute options is tricky enough.
Problem:Lets understand this by an example. Suppose we have a product attribute ‘manufacturer’. It is of type select/dropdown. And we have few options added in it like Mac, Google, Android etc. Now at some point in our Magento application we want to update these options with Apple, Nexus, HTC etc without using the admin panel, then it is a problem.

Solution:To update the option values programmatically, I came up with a simple solution which is as follows. For this, you need to find the ‘option_id’ of the attribute options in the ‘eav_attribute_option_value’ table.

Then create an option array and save it in the appropriate model.

Updating Attribute options

//Get the eav attribute model
$attr_model = Mage::getModel('catalog/resource_eav_attribute');

//Load the particular attribute by id
//Here 73 is the id of 'manufacturer' attribute
$attr_model->load(73);

//Create an array to store the attribute data
$data = array();

//Create options array
$values = array(
 //15 is the option_id of the option in 'eav_attribute_option_value' table
 15 => array(
   0 => 'Apple' //0 is current store id, Apple is the new label for the option
  ),
 19 => array(
   0 => 'Nexus'
  ),
 12 => array(
   0 => 'HTC'
  ),
);

//Add the option values to the data
$data['option']['value'] = $values;

//Add data to our attribute model
$attr_model->addData($data);

//Save the updated model
try {
 $attr_model->save();
 $session = Mage::getSingleton('adminhtml/session');
 $session->addSuccess(
  Mage::helper('catalog')->__('The product attribute has been saved.'));

 /**
  * Clear translation cache because attribute labels are stored in translation
  */
 Mage::app()->cleanCache(array(Mage_Core_Model_Translate::CACHE_TAG));
 $session->setAttributeData(false);
 return;
} catch (Exception $e) {
 $session->addError($e->getMessage());
 $session->setAttributeData($data);
 return;
}

This is all and you are done.

Adding new Attribute option

$arg_attribute = 'manufacturer';
$arg_value = 'value to be added';

$attr_model = Mage::getModel('catalog/resource_eav_attribute');
$attr = $attr_model->loadByCode('catalog_product', $arg_attribute);
$attr_id = $attr->getAttributeId();

$option['attribute_id'] = $attr_id;
$option['value']['any_option_name'][0] = $arg_value;

$setup = new Mage_Eav_Model_Entity_Setup('core_setup');
$setup->addAttributeOption($option);

Written by Arvind Bhardwaj

Arvind is a certified Magento 2 expert with more than 10 years of industry-wide experience.

Website: http://www.webspeaks.in/

Related Posts

How to Hide Select All From Magento 2 Admin Grids

How to Hide Select All From Magento 2 Admin Grids

Age Verification Extension for Magento 2

Age Verification Extension for Magento 2

Add Color Picker in Magento 2 Admin Configuration Options

Add Color Picker in Magento 2 Admin Configuration Options

23 thoughts on “Add/Update Attribute Option Values Programmatically in Magento”

  1. I am little bit confused! I just want to make sure, did you mean update old value (attribute which is manufacturer ) with new one? If that so, what will happen ordered item attribute values?

  3. @Oğuz Çelikdemir
    I am not updating the attribute itself. In fact I am updating the ‘options’ for that attribute. Suppose you want to change the name of a manufacturer from ‘A’ to ‘X’ through your code, then this article is for you.

  12. This is actually really useful and pointed me in the right direction. Not sure why its so hard to dig this information out of the magento website…

  18. how can we remove attribute ‘Size’ we can not delete dubble labels (Like more Than ‘M’). After save labels are still shown (means not delete it’s show again)

  19. what is "any_option_name" in the following line
    $option['value']['any_option_name'][0] = $arg_value;

    1. 'any_option_name' would be a manufacturer_name (ex: nexus)
      arg_value would be it's integer optionId afaik. The thing that would also need to be acquired first, is what the next unused optionId is. To be used for this new attribute option.

  21. Pingback: php – Add new values to a attribute option in magento-ThrowExceptions – ThrowExceptions

Comments are closed.