Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product wieght rounding to 0


Tubbing

Recommended Posts

I've searched the fourms for abit now without success, so finally decided to post my problem. I sell products that weight 0.002kg but everytime i enter this in the osc field it just rounds it to 0.00, unlike for price i cannot find a field anywhere to set the decimal places for weight. Can someone help me with this problem, thank you.

Link to comment
Share on other sites

I've searched the fourms for abit now without success, so finally decided to post my problem. I sell products that weight 0.002kg but everytime i enter this in the osc field it just rounds it to 0.00, unlike for price i cannot find a field anywhere to set the decimal places for weight. Can someone help me with this problem, thank you.

 

You need to alter your database.

Run this sql.

 

ALTER TABLE `products` CHANGE `products_weight` `products_weight` DECIMAL( 5, 4 ) NOT NULL DEFAULT '0.00'

Link to comment
Share on other sites

  • 2 years later...

You need to alter your database.

Run this sql.

 

ALTER TABLE `products` CHANGE `products_weight` `products_weight` DECIMAL( 5, 4 ) NOT NULL DEFAULT '0.00'

 

fantatstic!!... i was looking for this fix for ages!!....tried it and it worked...well done...

 

i have tried this and it worked and am now a very happy bunny!!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...