Import Manufacturers
Sometime when you need to deal with import of thousands of Manufacturers, then manual data entry is really a overhead and tedious.
In such case you can follow the following simple steps for the import of manufacturers (Quick & Dirty way):
Steps |
Follow the following steps:
1> Create a file in the root of magento dir: manufacturer_import.php
2> Write the following code there:
- <?php
- require_once 'app/Mage.php';
- umask(0);
- Mage::app('default');
- $_manufacturers = file('manufacturers.txt');
- $_attribute = Mage::getModel('eav/entity_attribute')->loadByCode('catalog_product', 'manufacturer');
- $manufacturers = array('value' => array(), 'order' => array(), 'delete' => array());
- $i = 0;
- foreach($_manufacturers as $_manufacturer){
- $i++;
- $manufacturers['value']['option_' . $i] = array($_manufacturer);
- }
- $_attribute->setOption($manufacturers);
- try{
- $_attribute->save();
- echo 'Manufacturer successfully imported';
- }catch(Exception $e){
- echo 'Import Error::'.$e->getMessage();
- }
3> Note i have used manufacturers.txt in the root dir with the values of manufacturers in newline format. For example:
Dell Toshiba Sony Fujitsu ... and so on
You can also use array instead. But above techniques comes into handy when you have hundreds of manufacturers.
4> Simply run from browser:
http://my-magento-store/import_manufacturer.php
5> You are done.
Note: Don’t repeat 4 unless you delete those values from backend manually.
Todo: Skip the import for existing values.
Conclusion |
You can use above snippet for any attribute with dropdown options like manufacturer:
- $_attribute = Mage::getModel('eav/entity_attribute')->loadByCode('catalog_product', 'any-attribute-with-option-value');
Cheers!!
— MagePsycho 2011/03/16 05:04
New version for cli via Mage Shell (/shell/);
This one also checks for duplicates!!!
