View weight of all items at once?

[bodini]

Is it possible to see the weight of all the items at one time (or at least on the categories page in admin)?

For example, there are 20 items in a category in my store. I want to make sure they are all set to the same weight... but i dont want to edit each one individualy just to check.

thanks,

Nick

[Ajeh]

Do all of the products have the same master_categories_id in the products table?

If so, you could update the products_weight field to the same value where the master_categories_id = XX ...

[iguana7]

and how do u do that?

[Ajeh]

UPDATE products SET products_weight = XXX WHERE master_categories_id = YY; 

But you need to know if the products are in the same master_categories_id ...