top64 Posted September 4, 2008 Share Posted September 4, 2008 Hi , does anyone know how I can do a mass update to the wieght field in my products , as my supplier doesn't use weight on all his products , and I have some other products that have no weight and therefore free. So what I need is to change any 0.00 weight in my database to 0.01 , as I have a flat fee for freight anything but a 0.00 would be fine. thanks Bruce Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted September 4, 2008 Share Posted September 4, 2008 Use phpmyadmin to run some sql to update the wt. Needs a little research but you will be able to set the wt field to any value you want http://www.w3schools.com/sql/sql_update.asp Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
spax Posted September 4, 2008 Share Posted September 4, 2008 Backup your database first, then try this in phpMyAdmin: UPDATE `products` SET `products_weight` = '0.01' WHERE `products`.`products_weight` ='0.00'; Quote Link to comment Share on other sites More sharing options...
top64 Posted September 8, 2008 Author Share Posted September 8, 2008 Use phpmyadmin to run some sql to update the wt. Needs a little research but you will be able to set the wt field to any value you want http://www.w3schools.com/sql/sql_update.asp thanks , you learn something every day Quote Link to comment Share on other sites More sharing options...
top64 Posted September 8, 2008 Author Share Posted September 8, 2008 Backup your database first, then try this in phpMyAdmin: UPDATE `products` SET `products_weight` = '0.01' WHERE `products`.`products_weight` ='0.00'; Quote Link to comment Share on other sites More sharing options...
top64 Posted September 8, 2008 Author Share Posted September 8, 2008 Backup your database first, then try this in phpMyAdmin: UPDATE `products` SET `products_weight` = '0.01' WHERE `products`.`products_weight` ='0.00'; worked a treat thanks Peter Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.