Adding shipping weight

[edgemeister]

Hi,

Is there any way to globally add the (same) weight to all products or do I have to open each product and add the weight individually?

Thanks,

Ed

[Ajeh]

To change all weights to be the same, in the Tools ... Install SQL Patches ...

UPDATE products SET products_weight = XX.XX;

NOTE: Backup your database before making changes like this ...

[edgemeister]

Well, I tried that (after backing the database up) and I got this message:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@achillesstonecrosses.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at achillesstonecrosses.com Port 80

[ronlee67]

Another way might be to set the TARE WEIGHT setting in Admin->Configure->Shipping/Packagine and make sure each product description is set to zero weight.

Ajeh's method is better because when/if the time comes that you have products with different weights it will be much easier to manage.

As for the issue with the SQL statement, I will leave it to Ajeh to answer that.

[edgemeister]

Guys, never mind. I have entered the weight manually to get it over with.

Thanks anyway.

Ed