app shop
A customer needed to update the weight of over 500 window decals in their osCommerce store. Originally, the weight was set incorrectly at 0.1 pounds, but it should have been 0.0625 pounds. Instead of manually updating each product, they asked if there was an SQL query or another method to apply the change efficiently.
The support team provided an SQL command to update the product weight in bulk:
UPDATE products SET products_weight = 0.0625 * 0.45359237, weight_cm = 0.0625 * 0.45359237, weight_in = 0.0625;
The customer successfully applied the SQL query, updating all products at once and ensuring accurate weight values for shipping calculations.
You can further discuss it on our Forum