Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Please help with shipping issue...?


Guest

Recommended Posts

Posted

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.

Posted

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.

Posted
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!

  • 3 years later...
Posted

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

Archived

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

×
×
  • Create New...