Forums / Basic Configuration / View weight of all items at once?

View weight of all items at once?

Locked

Results 1 to 4 of 4

This thread is locked. New replies are disabled.

18 Nov 2007, 3:35 PM

bodini

New Zenner

Join Date:: Jul 2007
Posts:: 43
Plugin Contributions:: 0

View weight of all items at once?

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. :wacko:

thanks,

Nick

18 Nov 2007, 4:18 PM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: View weight of all items at once?

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 ...

9 Jun 2008, 10:43 PM

iguana7

New Zenner

Join Date:: Jun 2008
Posts:: 6
Plugin Contributions:: 0

Re: View weight of all items at once?

and how do u do that? :dontgetit

11 Jun 2008, 6:46 PM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: View weight of all items at once?

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 ...