Weight configuration - When I put 1300, it shows 999.99

[Guest]

Hi all,

 

 

I discovered a problem in my osCommerce. When I add a new product and put an weight upper to 1000 grams by adm area, on it's product's description it shows 999.99.

 

Which file may I configure to solve this problem.

Thanks in advance.

[Guest]

Please someone...

[Guest]

After a final battle I've found it!!!

 

On database the table "product" :

 

The original:

`products_weight` decimal(5,2) NOT NULL

 

After change:

`products_weight` decimal(10,0) NOT NULL

 

 

 

Now that's FINE!!!!!!

[Tsuri Japan]

awesome this worked for me and thanks for posting your results. The only downfall to this is after my products that had say 1,300 grams is now 1,000. So you'll have to edit your products to make the correct changes. But I'll take this any day over shipping that's too cheap!!

 

Thanks again!

 

Nigel

[Tsuri Japan]

Now I have an other probelm. I use weights in my attributes and have some that are stuck at 99 grams. I went into mysql "attributes weights" and have this:

 

options_values_weight decicmal 5,3 NOT NULL

 

Should I change it to this:

 

options_values_weight decicmal 10,0 NOT NULL

 

as suggested from the previous message. I just hate editing SQL without not knowing what could or will happen.

 

Regards,

 

Nigel

[Guest]

Hi,

 

 

options_values_weight decicmal 5,3 NOT NULL

 

 

5= numbers before commas (or dot) Ex.: 12345,

3= Numbers after commas Ex.: ,123

 

So, I get this: 12345,123 or 12345.123

 

This is what happens when u edit this.

If you hava a weight 0.35, problably it will have 99 if u are using 10,0. Try using 10,2.

 

Did it help you?

[AndreD]

thanks that helped me too