Change Additional Shipping Cost on multiple products

[pavlinpsl]

Hello , i have the following situation . I 've about 2000 products , which i want to change additional shipping cost -from 4.17 to 5.42 on all products . Which is the easiest method ? Does anyone know  way to do it with some mysql script or something ?   I will be very grateful

P.S : PrestaShop 1.6 here

[Knowband Plugins]

You can execute below-mentioned SQL queries in order to update the Additional Shipping Cost values for all the products.

UPDATE `ps_product_shop` SET `additional_shipping_cost`= 5.42 WHERE 1
UPDATE `ps_product` SET `additional_shipping_cost`= 5.42 WHERE 1

[pavlinpsl]

1 hour ago, Knowband Plugins said:

You can execute below-mentioned SQL queries in order to update the Additional Shipping Cost values for all the products.

UPDATE `ps_product_shop` SET `additional_shipping_cost`= 5.42 WHERE 1
UPDATE `ps_product` SET `additional_shipping_cost`= 5.42 WHERE 1

Thank you for the answer ! I did not asked correctly Sorry . Is it possible  to update only products that have Additional Shipping Cost specific value ? As example (as i mentioned earlier) All products with current Additional Shipping Cost value 4.17 to become 5.42

[Knowband Plugins]

You can use below SQL queries that can fulfill your requirement:
UPDATE `ps_product` SET `additional_shipping_cost`= 5.42 WHERE `additional_shipping_cost` = 4.17
UPDATE `ps_product_shop` SET `additional_shipping_cost`= 5.42 WHERE `additional_shipping_cost` = 4.17