Code: Select all
DELETE FROM `weight_class`;
INSERT INTO `weight_class` (`weight_class_id`, `value`) VALUES
(1, 1.00000000),
(2, 1000.00000000),
(5, 2.20460000),
(6, 35.27400000);
DELETE FROM `weight_class_description`;
INSERT INTO `weight_class_description` (`weight_class_id`, `language_id`, `title`, `unit`) VALUES
(1, 1, 'Kilograms', 'kg'),
(2, 1, 'Grams', 'g'),
(5, 1, 'Pound ', 'lb'),
(6, 1, 'Ounce', 'oz');
You may also need to update any shipping services like UPS that use these values.
Bottom line, don't delete any weight classes, even if you don't think you need them. They are not meant to be deleted as sometimes conversions need to occur whether you realized it or not.