maximum weight set to 999.99?

[PvC]

I have set up a shop to sell my cd's and albums. I hardly ever sell anything over 1 kg, so I never noticed that if I set a product weight higher than 1 kg, it is automatically stored as 999.99.

Recently, there was a problem for a box set of 2.6 kg. Resulting in a remarkable difference in shipping cost from Holland to Australia.

Based on the 999.99 (1 kg) weight, the shipping cost was calculated to $24,10, when in fact it should have been $45,70!

That's a bit tough to explain to a customer... :-(

 

Why is it that the weight is capped at 999.99 grams and is there an option where I can change that?

The maximum package weight is set to 10.000, so that can't be the problem

 

Hope anyone can help me with this.

I'm running OSCommerce O.M. 2.3.3

 

Thanks in advance,

Peter

[MrPhil]

Is the maximum package weight 10.000 or 10-thousand grams? I'm wondering if somewhere someone entered 10-thousand as 10.000 in a server configured US/UK-style where . is the decimal separator and not the thousands separator? Thus, the value would be 10 grams, not 10 kg. Just something to verify before looking deeply into the code.

[PvC]

The value is entered without separator: 10000 (grams), so that cannot be the problem. Package weight is also entered without separator, like 2500. After saving it is transformed to 999.99

[Chris H]

Using phpMyAdmin to look at the structure of the products table, we find that the products_weight column is of datatype

 

decimal(5,3)

 

Maybe change it to

 

int(6)

 

if you are using grams instead of kilograms. Put a tick in the checkbox that is alongside 'products_weight', and then click on 'Change'.

[zefeena]

Thank you - this worked for me! I generally sell very low weight items so I needed to work in grammes, unfortunately when I added a 5kg mystery bag it defaulted to 999g. The customer checked out and chose special delivery paying a 1/3 of what it would cost me to post! Another issue I came across is that maximum quantity in basket is set to 99, this, however is easily changed in admin panel - configuration/maximum values/items in basket (right at the bottom). Just be aware of it, if you sell little things n large quantities!

[♥14steve14]

I always understood that the weight was either Kg or Lbs. One KG would be enteed as 1.00. So anything smaller would be entered as 0.01, which would be 10 grammes.

 

I sell thousands of very light products so altered the weight database entry from 5.2 to 5.3 and now enter the weight in grammes. One gramme will be 0.001. This also seems to work correctly for all the installed shipping modules.

[zefeena]

Yes, setting it up that way certainly makes it easier for the shipping prices. But I prefer to enter values without decimals as I list all the time, where I only change shipping prices once per year. So I set my weight up as an integer and use whole numbers only. This does mean you have to set your postal prices correctly, if they are in kilos so you simply change them to allow for the fact you sell in grams, i.e the price for 0.5 (kg) is simply changed to 500 (g) etc

[Magica]

Hi

 

I have had my store for several years but have never found this problem until now. Its very frustrating since i dont understand what i can do to fix this. I have a clock that is 3.2 kg, and how am i suppose to write it in the "Products Weight" box when i have already sat hundreds of already products like this:

 

660.00= 660 grams?

 

my clock should then be 3200.00 but it just change it to 999.99.

 

I have searchet the net and cant find anything in my own language (Norwegian) so i hope anyone can explain this to me simple lol, so i understand. I would really really love to have a guy that could fix stuff like this for me in the shop, because it takes alot of time away from the real job for me running the store, but how can i find people that work with this stuff, anyone know where to look on the net?

 

Or anyone know about people that can teach me oscommerce i would be happy to learn :)

 

Kind regards

Magica

[♥14steve14]

@@Magica

 

See my other post above.

[Magica]

I have read your post but i didnt understand it, and i dont see that this is helping me, since i have products that have the weight of 976.00 (this is gram) and the shipping cost is correct of all hundreds of products, So that means i have it in kg. How am i suppose to write 3.2 kg?

I cant write 3.2. because that would be like 3.2 grams, so that is not correct. It should be 3200.00 bc it will always add ".00" Im lost.

 

It cant be that i have to change hundreds of products?

[♥kymation]

Read Post #4 in this thread and follow those instructions.

 

Regards

Jim

[burt]

I would really really love to have a guy that could fix stuff like this for me in the shop, because it takes alot of time away from the real job for me running the store, but how can i find people that work with this stuff, anyone know where to look on the net?a

 

The best commercially experienced coders are found at http://www.oscommerce.com/forums/forum/79-commercial-support-enquiries/

[burt]

Decimal Datatype:

http://dev.mysql.com/doc/refman/5.1/en/precision-math-decimal-changes.html

 

The declaration syntax for a DECIMAL column is DECIMAL(M,D). The ranges of values for the arguments in MySQL 5.1 are as follows:

 

M is the maximum number of digits (the precision). It has a range of 1 to 65. (Older versions of MySQL permitted a range of 1 to 254.)

 

D is the number of digits to the right of the decimal point (the scale). It has a range of 0 to 30 and must be no larger than M.

 

So, in english:

 

decimal(5,3) means you can have 5 number of which 3 can be after the decimal point, eg: 99.999 or 1.234

 

To enable larger weights change the datatype as pointed out by @@Chris H to an INT or (in my opinion more useful) change to a different sized decimal, eg decimal(10,3). A decimal 10,3 would mean you can have 10 numbers of which 3 are after the decimal point, eg: 9999999.999 - and if anythig weighs that much, it is unlikely the postal carrier would carry it.

 

Maybe the core code needs a different sized datatype for this, easy enough.