Is there is SQL I could put in to change all listings from weight: 1 to 0.5 ?
Is there is SQL I could put in to change all listings from weight: 1 to 0.5 ?
For all active product:
Backup the database before executing. Above is written to consider being used in admin->tools->Install SQL PatchesmCode:UPDATE products SET products_weight = '0.5' WHERE products_weight = '1' AND products_status = 1;
If using phpmyadmin, consider the use of the DB_PREFIX with the table name of products found just after the word "UPDATE".
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Beautiful, thank you... I scheduled a full backup with my host.
Bookmarks