Quick Weights Change in Database

[pynchon]

I have a shop of some 1600 products ... I need to give all the products a set weight (they are all the same) ... is there a quick way of doing this.

I can't give them all a null value as it is important for shipping weights that they are given their correct value of 0.5kg

 

Is there a way of doing this via phpMyAdmin or by running some sort of table update ??

 

many thanks in advance

 

John K

[pynchon]

I have a shop of some 1600 products ... I need to give all the products a set weight (they are all the same) ... is there a quick way of doing this.

I can't give them all a null value as it is important for shipping weights that they are given their correct value of 0.5kg

 

Is there a way of doing this via phpMyAdmin or by running some sort of table update ??

 

many thanks in advance

 

John K

 

any suggestions at all ?????

 

please :blush:

[natewlew]

Log into phpmyadmin and click on sql and run this query.

update products set products_weight = 0.5;

If you get an error tell me what it is.