Changing Weight on multiple items

[iguana7]

Hello,

I have about 500+ items that were entered into my store without a weight. Many of them have the same weight. Is there any way I can change the weight on multiple items at one time, rather than having to go in one by one... to add the weight for each of them?

Any information will help!

THANKS!!!!!

[Ajeh]

Is there a criteria for which 500+ items need to have the weight changed?

Things like same master_categories_id or something along that line?

[dni]

i am having the same issue
it is all the items in a category that all need to be 1 lb....

[Ajeh]

If all of the Products use the same master_categories_id then you can do this using:

UPDATE products SET products_weight = 1 WHERE master_categories_id = XXX; 

Replace the XXX with the master_categories_id you want to change ...

This can be run from your Zen Cart Admin via the Tools ... Install SQL Patches ...

NOTE: backing up your database is always a good idea prior to making changes like this ...

[dni]

THANK YOU!
as usual, you are the best!