Need to Mass Update Weight field from 0 to 1 in

[top64]

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

[♥geoffreywalton]

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

[spax]

Backup your database first, then try this in phpMyAdmin:

 

UPDATE `products` SET `products_weight` = '0.01' WHERE `products`.`products_weight` ='0.00';

[top64]

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

[top64]

Backup your database first, then try this in phpMyAdmin:

 

UPDATE `products` SET `products_weight` = '0.01' WHERE `products`.`products_weight` ='0.00';

[top64]

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