How do I?

[iflyamphib]

I have installed 3 contribs today that are quite valuable to my store:

 

Individual Product Shipping Methods

Individual Product Payment Methods

ABF Freight Shipping Module

 

No problems with these installs, but I have one problem I don't see how to fix - and I believe its in the core code somewhere. In the Products Weight field (in the Catalog/Categories/Products) the field will only accept a max weight of 999.99 Lbs. I have a product that weighs (crated) at 1300 lbs, and if I enter 1300 in the this field and save it, reopen the product, it defaults back to 999.99

 

I have 1400 lbs set in the Config: Shipping / Packaging menu for max weight I'll ship. I've perused the database, but don't see where to modify this value, if that's where it needs to be modded.

 

Thanks for any assistance anyone can offer.

[jhande]

Hey Jim,

 

It is in the database. I had to change mine to except 3 decimal places instead of 2.

 

Look at the products table, products_weight field.

 

I can't remember what the original setting was, maybe something like [Type (decimal 5.2)]?

 

Try changing it to (decimal 6.2).

 

That should give you 4 places before the decimal and 2 places after.

 

BACKUP FIRST!!!

 

[iflyamphib]

Hey thanks Jim! You were right on the money. I saw the 5.2 while poking around, but without knowing what it meant I wasn't touching anything :)

 

And you bet, I back up on everything I do, whether its just copying and modding a file or a whole contrib, on the live site or dev site. Takes a little time, but has saved my butt numerous times. Jim

 

Hey Jim,

 

It is in the database. I had to change mine to except 3 decimal places instead of 2.

 

Look at the products table, products_weight field.

 

I can't remember what the original setting was, maybe something like [Type (decimal 5.2)]?

 

Try changing it to (decimal 6.2).

 

That should give you 4 places before the decimal and 2 places after.

 

BACKUP FIRST!!!

 

[jhande]

You are welcome Jim!

 

I try to always backup first, but there was this one time...