Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can't change weight to >9999.99


NewBudda

Recommended Posts

I am going crazy! I can't change the weight of my products to 10000.00. On saving it keeps changing back to 9999.99. I dont get it, my "Enter the Maximum Package Weight you will ship" is set to 90000.

 

Because of this my customers get charged to little postage and I have to pay on top.

 

Do I need to change to a flat rate postage?

Open Source Newsletter: PhPList

Open Source Questionnaire: Lime Survey

Link to comment
Share on other sites

I am going crazy! I can't change the weight of my products to 10000.00. On saving it keeps changing back to 9999.99. I dont get it, my "Enter the Maximum Package Weight you will ship" is set to 90000.

 

the database defines this as:

products_weight decimal(5,2) NOT NULL,

 

you've probably already changed this since you're showing six digits instead of five, but it looks like you need more now. you can do this in phpmyadmin.

Link to comment
Share on other sites

the database defines this as:

products_weight decimal(5,2) NOT NULL,

 

you've probably already changed this since you're showing six digits instead of five, but it looks like you need more now. you can do this in phpmyadmin.

 

Thank you that helped! I put it to 7,2 and now I can have 10000.00.

However my shipping table seems till wrong:

 

"2000:4.99,5000:7.99,10000:11.99,20000:23.98, 100000:31.97" as a Table doesnt work, it stays at 4.99 after 5kg (5000) are reached...

Open Source Newsletter: PhPList

Open Source Questionnaire: Lime Survey

Link to comment
Share on other sites

This happened, because before you changed this setting in the database the maximum weight stored there was 9999.99, and so you first have to edit all weights again and put in the correct values....

Link to comment
Share on other sites

Thank you dave!

 

This happened, because before you changed this setting in the database the maximum weight stored there was 9999.99, and so you first have to edit all weights again and put in the correct values....

I checked all those and only the weights above 10kg were affected. So, in theory, I must have had the problems with the shipping tables before that...

Open Source Newsletter: PhPList

Open Source Questionnaire: Lime Survey

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...