Clone attributes without overwriting existing ones?

[jeremyja]

Anyone know how to clone attributes from one product to another without overwriting existing ones?

[jeremyja]

If someone else need this...

 

In contribution Attribute Sort with Attribute Clone 1_8_3

change

// BOE: Attribute Sort with Clone Tool
  case 'clone_attributes':
	$multi_clone_products_id_to=$HTTP_POST_VARS['clone_products_id_to'];
	for ($i=0;$i<sizeof($multi_clone_products_id_to);$i++) {
	  $clone_product_id_from = $HTTP_POST_VARS['clone_products_id_from'];
	  $clone_product_id_to = $multi_clone_products_id_to[$i];
	  tep_db_query("delete from ".TABLE_PRODUCTS_ATTRIBUTES." WHERE products_id='".$clone_product_id_to."'");
	  $attributes = tep_db_query("select products_id, options_id, options_values_id, options_values_price, price_prefix, attribute_sort from " . TABLE_PRODUCTS_ATTRIBUTES ." where products_id='".$clone_product_id_from."'");
	  while($attributes_values = tep_db_fetch_array($attributes)) {
		tep_db_query("INSERT INTO " . TABLE_PRODUCTS_ATTRIBUTES . " ( products_id, options_id, options_values_id, options_values_price, price_prefix, attribute_sort) VALUES (".$clone_product_id_to.", ".$attributes_values['options_id'].", ".$attributes_values['options_values_id'].", ".$attributes_values['options_values_price'].", '".$attributes_values['price_prefix']."' , ".$attributes_values['attribute_sort'].")");
	  }
	}
	tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
	break;
// EOE: Attribute Sort with Clone Tool

 

to

 

// BOE: Attribute Sort with Clone Tool
  case 'clone_attributes':
 $multi_clone_products_id_to=$HTTP_POST_VARS['clone_products_id_to'];
 for ($i=0;$i<sizeof($multi_clone_products_id_to);$i++) {
$clone_product_id_from = $HTTP_POST_VARS['clone_products_id_from'];
$clone_product_id_to = $multi_clone_products_id_to[$i];
 // (do not overwrite, please)  tep_db_query("delete from ".TABLE_PRODUCTS_ATTRIBUTES." WHERE products_id='".$clone_product_id_to."'");
$attributes = tep_db_query("select products_id, options_id, options_values_id, options_values_price, price_prefix, attribute_sort from " . TABLE_PRODUCTS_ATTRIBUTES ." where products_id='".$clone_product_id_from."'");
while($attributes_values = tep_db_fetch_array($attributes)) {
		tep_db_query("INSERT INTO " . TABLE_PRODUCTS_ATTRIBUTES . " ( products_id, options_id, options_values_id, options_values_price, price_prefix, attribute_sort) VALUES (".$clone_product_id_to.", ".$attributes_values['options_id'].", ".$attributes_values['options_values_id'].", ".$attributes_values['options_values_price'].", '".$attributes_values['price_prefix']."' , ".$attributes_values['attribute_sort'].")");
}
 }
 tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));
 break;
// EOE: Attribute Sort with Clone Tool

 

Or contribution Attributes Copier do the same...