Guest Posted March 15, 2007 Posted March 15, 2007 Hi there, i have an online shop setup using oscommerce, where all products in my shop have been given weight values in grams, eg, 150, 600, etc. i have a slight problem in that weights over 9999.99 do not seem to show up as entered. As an example, if i set a product weight at 24000 (grams), i.e., 24Kg, having saved the changes, and viewed the product, the weight shows up as 9999.99, instead of the value i entered of 24000. I can only assume that this is to do with the way in which the software determines the weight and would like to know how to change the unit of weight to Kg. What unit of weight is the shop setup in by default. Please see the following url for an example (i have enabled the weight column): http://www.autopot.co.uk/onlineshop/index.php?cPath=29 The product titled "24Pot Kit (Using 16mm pipe)" should have a weight of 24000g or 24Kg, however, this shows as 9999.99. Any assistance would be much appreciated. Thanks in advance, Anthony Verma.
vasttech Posted March 15, 2007 Posted March 15, 2007 First you can't enter characters in the weight field (i.e. g or Kg). Second, and most importantly, you have to change the table configuration for the products table. A base install of osCommerce only allows a total of 5 digits including 2 to the right of the decimal place. You would need to change the products_weight field from decimal(5,2) to decimal(7,2) to fix your problem. If you have numbers greater then 99999.99 you would need to change the 7 accordingly. You can do this through phpMyAdmin. osCommerce Knowledge Base osCommerce Documentation Contributions
Guest Posted March 15, 2007 Posted March 15, 2007 First you can't enter characters in the weight field (i.e. g or Kg). Second, and most importantly, you have to change the table configuration for the products table. A base install of osCommerce only allows a total of 5 digits including 2 to the right of the decimal place. You would need to change the products_weight field from decimal(5,2) to decimal(7,2) to fix your problem. If you have numbers greater then 99999.99 you would need to change the 7 accordingly. You can do this through phpMyAdmin. Problem solved, thanks for your help! Much appreciated!
shoppy Posted July 3, 2010 Posted July 3, 2010 First you can't enter characters in the weight field (i.e. g or Kg). Second, and most importantly, you have to change the table configuration for the products table. A base install of osCommerce only allows a total of 5 digits including 2 to the right of the decimal place. You would need to change the products_weight field from decimal(5,2) to decimal(7,2) to fix your problem. If you have numbers greater then 99999.99 you would need to change the 7 accordingly. You can do this through phpMyAdmin. Thanks for me also, great help! John
Recommended Posts
Archived
This topic is now archived and is closed to further replies.