Guest Posted July 3, 2009 Share Posted July 3, 2009 Hi Got a site ready to go live but am having problems with one small very niggly issue on product weight. Have a product that I want to enter a weight of 2001 for, but once saved it defaults back to 999.99. I've checked all the settings I can but can't find any way to change options on this. Essential I get it fixed as it relates to shipping rates for this particular product. Thanks Helen Link to comment Share on other sites More sharing options...
♥ecartz Posted July 3, 2009 Share Posted July 3, 2009 It's in the database, products_weight is defined as a decimal(5,2), which means five digits, two after the decimal. You can change this in phpMyAdmin or similar database management system. If you have to use direct SQL, it will look something like ALTER TABLE `products` CHANGE `products_weight` `products_weight` DECIMAL( 6, 2 ) NOT NULL Backup the database before making any changes. Always back up before making changes. Link to comment Share on other sites More sharing options...
Guest Posted July 3, 2009 Share Posted July 3, 2009 It's in the database, products_weight is defined as a decimal(5,2), which means five digits, two after the decimal. You can change this in phpMyAdmin or similar database management system. If you have to use direct SQL, it will look something like ALTER TABLE `products` CHANGE `products_weight` `products_weight` DECIMAL( 6, 2 ) NOT NULL Backup the database before making any changes. Thanks! Tearing my hair out here & will give it a go now. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.