Guest Posted November 4, 2005 Share Posted November 4, 2005 how do you change weight to metric units? I need to have my products weight to be measured in grams instead of Lbs Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted November 4, 2005 Share Posted November 4, 2005 Its in Admin -> General Settings Quote Link to comment Share on other sites More sharing options...
Guest Posted November 4, 2005 Share Posted November 4, 2005 sorry, I figured it out right as I saw your response. Thanks ! Quote Link to comment Share on other sites More sharing options...
Guest pgowling Posted November 4, 2005 Share Posted November 4, 2005 Please note that when dealing in Kgs that the database field 'CubeCart_inventory.prodWeight' is to 2 decimal places rather than 3 and therefore grams are not fully supported at present (at least this is definitely the case in V3.0.4). A bug has been raised to cover this. Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted November 4, 2005 Share Posted November 4, 2005 Oh wow, i never noticed that before. Thanks for pointing it out! Its important for me because I sell jewellery findings, some of which weight only a gram or too. But its an easy fix. This SQL command can be run in phpMyAdmin and will modify the field to allow three decimal places (all existing weights will be preserved): ALTER TABLE `CubeCart_inventory` MODIFY prodWeight decimal(10, 3) DEFAULT NULL Quote Link to comment Share on other sites More sharing options...
Guest pgowling Posted November 4, 2005 Share Posted November 4, 2005 Spot on that's the temporary fix I applied ;) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.