Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Shipping weight - ounces or grams, how do I...


theirishewe

Recommended Posts

Posted

How in the world do I list product weights by ounces or grams instead of pounds for the USPS shipping thingy? Can't figure out the ratio - 16 ounces in one pound, how do I put that into decimal format?

 

Or am I overthinking all of this and should I just set the lowest weight at one pound?

Posted

get a caluclator (or use the one on your pc).

 

divide 1 by 16. Thats your decimal for an ounce. Then multiply by required amount.

 

Hope that helps.

 

Tony B

Posted

the easiest way is to let sql do all of the thinking.

 

Run this in your mysql management tool

 

UPDATE products SET products_weight = products_weight/16 WHERE products_id = products_id;

Posted

which works great on all your existing products, but wont work on new products. Then once you have added more products in, you cant run the statement again without messing up the value on the old ones.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...