UPDATE aaa_prezzi SET prezzo = REPLACE(prezzo_import, ',', '.');
update aaa_prezzi a INNER JOIN ps_product p ON a.codice = p.ean13 set id = id_product WHERE ean13 IS NOT NULL AND ean13 != '';


SELECT count(*) AS tot, ean13, codice FROM `aaa_prezzi` a left join ps_product p on p.ean13 = a.codice WHERE ean13 IS NOT NULL AND ean13 != '' GROUP BY ean13 HAVING tot > 1


update ps_product_shop p inner join aaa_prezzi a ON p.id_product = a.id set p.wholesale_price = a.prezzo where wholesale_price = 0;