Not sure if this is any help but, I regularly add attributes to multiple products in phpmyadmin. Perhaps you could insert new attributes rather than copy existing.
I use:
Code:
INSERT INTO `products_attributes`(`products_id`, `options_id`, `options_values_id`, `options_values_price`,`products_options_sort_order`, `product_attribute_is_free`,`attributes_discounted`) SELECT products_id,'32','162','8.49','4000','0','0' FROM `products`
WHERE `products_model` LIKE '123456'
AND `master_categories_id`
IN (
1462,1465,1414,1470,1473,1468,1464,1463,1469,1466,1387,1386,1370,1389,1373,1396,1392,1391,1376,1393,1377,1398,1385,1374,1371,1390,1375,1372,1320,1384,1395,1394,1397,1361,1416,1378,1421,1354,1380,1457,1400,1417,1422,1379,1418,1363,1792,1381,1399,1419,1312,1420,1423,1424,1427,1426,1428,1415,1401,1403,1450,1333,1405,1402,1407,1410,1412,1409,1408,1413,1325,1538,1458,1429,1330,1309,1425,1327,1328,1334,1329,1369,1332,1337,1336,1326,1331,1324,1323,1313,1311,1310,1314,1338,1319,1315,1322,1321,1316,1318,1317,1339,1356,1358,1355,1357,1353,1359,1362,1365,1366,1367,1360,1340,1349,1341,1346,1345,1350,1343,1347,1348,1511,1507,1505,1503,1491,1504,1508,1516,1506,1513,1514,1517,1485,1490,1411,1368,1352,1510,1489,1515,1351,1492,1509,1493,1502,1501,1499,1467,1494,1519,1498,1495,1497,1518,1496,1512,1500,1520,1541,1548,1546,1536,1539,1534,1537,1540,1544,1542,1547,1545,1521,1522,1523,1525,1526,1364,1342,1476,1483,1448,1453,1527,1449,1524,1530,1447,1532,1446,1535,1528,1451,1486,1335,1406,1344,1533,1543,1529,1452,1488,1455,1531,1382,1454,1439,1444,1440,1430,1432,1445,1431,1435,1437,1434,1436,1433,1456,1438,1442,1441,1461,1471,1472,1443,1459,1460,1481,1475,1477,1480,1478,1479,1482,1404,1484,1487,1474);
this adds attributes to multiple products with the same model number in a number of categories, but I wonder if omitting the model number and substituting master_categories_id for products_id would work, like:
Code:
INSERT INTO `products_attributes`(`products_id`, `options_id`, `options_values_id`, `options_values_price`,`products_options_sort_order`, `product_attribute_is_free`,`attributes_discounted`) SELECT products_id,'32','162','8.49','4000','0','0' FROM `products`
WHERE `products_id'
IN (
1462,1465,1414,1470,1473,1468,1464,1463,1469,1466,1387,1386,1370,1389,1373,1396,1392,1391,1376,1393,1377,1398,1385,1374,1371,1390,1375,1372,1320,1384,1395,1394,1397,1361,1416,1378,1421,1354,1380,1457,1400,1417,1422,1379,1418,1363,1792,1381,1399,1419,1312,1420,1423,1424,1427,1426,1428,1415,1401,1403,1450,1333,1405,1402,1407,1410,1412,1409,1408,1413,1325,1538,1458,1429,1330,1309,1425,1327,1328,1334,1329,1369,1332,1337,1336,1326,1331,1324,1323,1313,1311,1310,1314,1338,1319,1315,1322,1321,1316,1318,1317,1339,1356,1358,1355,1357,1353,1359,1362,1365,1366,1367,1360,1340,1349,1341,1346,1345,1350,1343,1347,1348,1511,1507,1505,1503,1491,1504,1508,1516,1506,1513,1514,1517,1485,1490,1411,1368,1352,1510,1489,1515,1351,1492,1509,1493,1502,1501,1499,1467,1494,1519,1498,1495,1497,1518,1496,1512,1500,1520,1541,1548,1546,1536,1539,1534,1537,1540,1544,1542,1547,1545,1521,1522,1523,1525,1526,1364,1342,1476,1483,1448,1453,1527,1449,1524,1530,1447,1532,1446,1535,1528,1451,1486,1335,1406,1344,1533,1543,1529,1452,1488,1455,1531,1382,1454,1439,1444,1440,1430,1432,1445,1431,1435,1437,1434,1436,1433,1456,1438,1442,1441,1461,1471,1472,1443,1459,1460,1481,1475,1477,1480,1478,1479,1482,1404,1484,1487,1474);
the comma separated values in the latter would obviously be product ids and you wouldn't need to add all the attributes I did.
(some of the apostrophe's may have got corrupted in my copy and pasting)
Bookmarks