Add weight to product attributes Cap of 100Lbs

[cthakkar]

I added the UPSXML_v_1_3_5OSCOMM module followed by

add-weight-to-product-attributes v0.2, to be able to add different weights depending on product attribute

and then UPS_xml_and_attributes_with_weights_fix_1 to add the product attribute weights to the final shipping weight

 

I am running into a little problem where the product_attributes page under the admin panel will default to 100Lbs if I add any value > 100Lbs.. Any ideas as to why this is happening?

At first I thought it was the limit imposed by UPS on the UPS Package option but I checked the UPS package weight limit and it is 150Lbs.

I also increase the Max Package Weight under admin->configuration->shipping to 200Lbs but the problem still remains..

 

Any help would be much appreciated..

 

Thanks

[cthakkar]

I figured it out.. apparently the query to alter products_attribute table adds a weight value in decimal(5,3) format making the max value added for the weight to be 99.000, changing this to decimal(6,3) fixed the problem