theirishewe Posted March 15, 2006 Posted March 15, 2006 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?
Guest Posted March 15, 2006 Posted March 15, 2006 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
theirishewe Posted March 15, 2006 Author Posted March 15, 2006 I figured it out just seconds ago, thank you! Of course I can't get the USPS mod to work, but I'm one step closer!
hurl Posted March 15, 2006 Posted March 15, 2006 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;
Guest Posted March 15, 2006 Posted March 15, 2006 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.