Bulk Copying Product Attributes in Magento

Bulk Copying Product Attributes in Magento

Ron Peled 5:11 pm

Disclaimer: this code was only tested on Magento and we do not guarantee it will or will not work for you. Please use with caution…

This static method can copy attributes between products in Magento very fast and relatively secure. We are bypassing the main Magento architecture and accessing the Database directly, but notice we are using the Zend framework for the db query and we still use DB transactions. It accepts the source product ID (not SKU), destination product ID, the array of attribute codes (‘size’, ‘color’, ‘name’, etc.), and the attribute type (‘varchar’, ‘int’, etc.).
public static function copyOrCreateAttributes( $srcId, $dstId, $arrayOfAttributes, $type='varchar' )
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$table = Mage::getSingleton('core/resource')->getTableName('catalog_product_entity_'.$type);

if (count($arrayOfAttributes)>0)
try {

foreach ($arrayOfAttributes as $a)
$replace = “REPLACE INTO {$table} (entity_type_id,attribute_id,store_id,entity_id,value) “;
$replace.= “SELECT entity_type_id, attribute_id, store_id, “.$dstId.”, value “;
$replace.= “FROM “.$table.” WHERE entity_id=”.$srcId.” “;
$replace.= ” AND attribute_id=(SELECT attribute_id FROM eav_attribute “;
$replace.= “WHERE attribute_code='”.$a.”‘ AND entity_type_id=4)”;


//commit transaction or rollback
} catch (Exception $e) {
$m = “copyAttributes: Error trying to copy attributes:\n”;
$m.= “srcId = $srcId\n”;
$m.= “dstId = $dstId\n”;
$m.= “Error message from exception: “. $e->getMessage() . “\n”;
$m.= $e->getTraceAsString();

Related Posts:

Ron Peled

About Ron Peled

Builder of things. Builder of teams. Passion: eCommerce & Marketplaces. Magento expert. CTO Mentor.