You may then need to also edit the products to update them to one of the corresponding weight classes
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.