Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can't change weight to >9999.99


NewBudda

Recommended Posts

Posted

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

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

Posted
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

Posted
However my shipping table seems till wrong:

 

i don't know about that. hopefully someone else can point you in the right direction.

Posted

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....

Posted

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

Posted

What file can i find this line in? or can you tell me how to change it? been looking for it for way to long

 

can be reached at

admin at barrygooman.co.uk

Posted
What file can i find this line in? or can you tell me how to change it? been looking for it for way to long

 

can be reached at

admin at barrygooman.co.uk

 

 

never mind sorted it

Archived

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

×
×
  • Create New...