Mass product weight update

[sports guy]

I have over 400 products in my store. All have a weight of 0.375 for the product weight. I would like all products to have a 0.02 weight. Can I do this in bulk? Maybe PHP? If someone knows how to do this it would save me lots of time.

[mc12345678]

I have over 400 products in my store. All have a weight of 0.375 for the product weight. I would like all products to have a 0.02 weight. Can I do this in bulk? Maybe PHP? If someone knows how to do this it would save me lots of time.

I think the field is product_weight in the products table, so the below should do what is desired if placed in the install sql patches window of the admin.

update products set product_weight=.02 where product_weight=.375

Or just leave off the where section at the end if you are sure everything is to be set to 0.02.

[dbltoe]

BACKUP, BACKUP, BACKUP

[sports guy]

The actual weight is set at: 0.0375 and I want to change all to zero.

I tried both of these:

update products set product_weight=.00 where product_weight=.0375
update products set products_weight=.00 where products_weight=.0375

Reason: When I looked in my database (php MyAdmin) the product weight was called: products_weight. Niether one above worked, I got a failed message error in my SQL Query Executor window.

[dbltoe]

When you looked at the database, did each table have a prefix? Was products something like zen_products?

[mc12345678]

The actual weight is set at: 0.0375 and I want to change all to zero.

I tried both of these:

update products set product_weight=.00 where product_weight=.0375
update products set products_weight=.00 where products_weight=.0375

Reason: When I looked in my database (php MyAdmin) the product weight was called: products_weight. Niether one above worked, I got a failed message error in my SQL Query Executor window.

When you looked at the database, did each table have a prefix? Was products something like zen_products?

As dbltoe is hinting at, try the revised sql that has the field products_weight (extra s that I missed) and use it from the ZC admin install sql patch window as I first suggested. This will eliminate the discussion and search for the infamous DB_PREFIX. At least for now.

Remember zc addresses the database prefix whereas phpmyadmin doesn't know a thing about it and must be manually added.

[DrByte]

The actual weight is set at: 0.0375 and I want to change all to zero.

How about:

update products set products_weight = 0 where products_weight >= 0.0375 and products_weight <= 0.0376;

[sports guy]

How about:

update products set products_weight = 0 where products_weight >= 0.0375 and products_weight <= 0.0376;

That was the ticket, it worked perfectly. All products are now at zero weight. So I suppose I needed to add the semicolon at the end of the command line for one. Plus it seems as if you added spaces after the = sign. Thank you all for your help.

[DrByte]

No, it's neither the spaces nor the semicolon, although those make for better syntax.
The field is a data-type of "float", and a direct "equals" comparison doesn't always work as an exact match, hence the suggestion of giving it a range of "greater than or equal to 0.0375 AND less than or equal to 0.0376".