Post by Qphoria » Thu Dec 12, 2013 10:45 pm

If you did something stupid like delete the default weight classes in OpenCart, You can run this in phpmyadmin

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

Donate!|OpenCart Basics|GeoZones

User avatar


Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 1 guest