pavlinpsl Posted September 7, 2021 Share Posted September 7, 2021 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 Link to comment Share on other sites More sharing options...
Knowband Plugins Posted September 10, 2021 Share Posted September 10, 2021 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 Link to comment Share on other sites More sharing options...
pavlinpsl Posted September 10, 2021 Author Share Posted September 10, 2021 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 Link to comment Share on other sites More sharing options...
Knowband Plugins Posted September 23, 2021 Share Posted September 23, 2021 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now