Keith Greer Import Values to Dropdown/Multiple Select Attributes

Sometime when you need to deal with import of lots of values for a multiple select/drop down attribute. Then manual data entry is not very convenient. The code below will allow you to put all your values into a single text file and import in seconds. First you will need to upload the source code below into a new file manufacturer_import.php in the Magento root directory.

<?php
require_once '../app/Mage.php';
umask();Mage::app('default');
$_manufacturers = file('import.txt');
$_attribute =Mage::getModel('eav/entity_attribute')->loadByCode('catalog_product','manufacturer');
$manufacturers = array('value'=> array(),'order'=> array(),'delete'=> array());
$i =;foreach($_manufacturers as $_manufacturer){
    $i++;
    $manufacturers['value']['option_'. $i]= array($_manufacturer);}
$_attribute->setOption($manufacturers);try{
    $_attribute->save();
    echo 'Attribute values successfully imported';}catch(Exception $e){
    echo 'Import Error::'.$e->getMessage();}

The above code will import Manufacturers into the “manufacturer” attribute, but can be used on any drop-down or multiple select attribute configured in Magento, simply change “manufacturer” at the end of line 6 to the code of the attribute you wish to update.

Next step is to prepare and upload your list of manufactures in a simple text file, one value per line. Save the file as “import.txt”, and upload into Magento root directory, beside the above script.

Apple
Banana
Pear
...

Navigate to www.magento.com/manufacturer_import.php and you sould see the import successful message.

Source: http://www.magentocommerce.com/wiki/