Community Add-Ons

this contribution has done better and the location of it has changed.I advice you to use it.
http://www.oscommerce.com/community/contributions,1822
powered by faaliyet and olsonsp4c (Thanks to olsonsp4c for fixing the bugs) .

-no file attached

bug.

The following error occurs:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1

INSERT INTO products_attributes ( products_id, options_id, options_values_id, options_values_price, price_prefixt) VALUES (184, 10, 29, 0.0000, ')

[TEP STOP]



to solve change:

price_prefixt to price_prefix
and
.")"); to ."')");

I was frustrated that it seems no tool existed to clone all attributes from one product to multiple others, so I came up with the attached solution

FIND at line 27:
************
case 'clone_attributes':
$clone_product_id_from = $HTTP_POST_VARS['clone_products_id_from'];
$clone_product_id_to = $HTTP_POST_VARS['clone_products_id_to'];
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 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 ) VALUES (".$clone_product_id_to.", ".$attributes_values['options_id'].", ".$attributes_values['options_values_id'].", ".$attributes_values['options_values_price'].", '".$attributes_values['price_prefix']."')");

}
break;
************


REPLACE WITH:
************
// BOF Multiple Product Attributes Clone
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 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_prefixt) VALUES (".$clone_product_id_to.", ".$attributes_values['options_id'].", ".$attributes_values['options_values_id'].", ".$attributes_values['options_values_price'].", '".$attributes_values['price_prefix'].")");
}
}
break;
// EOF Multiple Product Attributes Clone
************




FIND at line 781:
************
<select name="clone_products_id_to">
************



REPLACE WITH:
************
<select name="clone_products_id_to[]" multiple size="20">
************


Hope that helps someone...

I realized, the error found in "products_attributes.php" file for "Product Attributes Clone tool" was occured because of some missing section that I did.
Because the file that I used was prepared by "Product Attributes - Option Type Feature" (http://www.oscommerce.com/community/contributions,160), was giving error as;

1054 - Unknown column 'products_options_type' in 'field list'

insert into products_options (products_options_id, products_options_name, language_id, products_options_type, products_options_length,
products_options_comment) values ('9', 'text 1', '1', '1', '', '')

[TEP STOP]

The cause of this as I said before is because of "Product Attributes - Option Type Feature" contribution not to be used.
To correct this situation, it is enough to allow to work sql file that I added, with phpMyadmin.

It will work extremly good even if you don't use contribution "Product Attributes - Option Type Feature".
PS: Sql file for sql query and one screenshot from advanced search (OTF) page are added.

new catalog/admin/products_attributes.php file for "oscommmerce-2.2rc2a".

(just replace with old log/admin/products_attributes.php file with new log/admin/products_attributes.php file)

products_attributes.php file included.
Workng perfect...

This is the file updated for guys that have options type enable contribution. just replace the file in admin products_attributes.php for the one included here.
Nice contribution, all credits to FuzzyBubblewrap.

I updated this version to clear out all the old attributes before appling the new ones. Cheers!

I know it's not the prettest thing in the world, but it gets the job done. This is my first contribution, this probally won't be my last. What this does is allow for you to take an already existing product and clone it's attributes so you don't have to select every attribute. Maybe something like this exists, I couldn't find it.