Monday, June 18, 2018
Opencart mass update price by percentage change class id and so on Simple Sql queries
Opencart mass update price by percentage change class id and so on Simple Sql queries
Opencart disable products with price zero
Sometimes there are products with price zero, or other specific column/value, that need to be disabled.
Its quite easy to update all your products with this sql UPDATE.
update oc_product set status = 0 where price = 0.0000;
Mass Update the prices of the products in opencart
lowering the price with -22% - For example when youve imported prices including taxes and you want to add a tax class
update oc_product set price = (price / 1.22);
rising the price with +22% (ex. iva italiana)
update oc_product set price = (price * 1.22);
Mass Update the tax class of the products in opencart
update oc_product set tax_class_id = 1;
if you want to remove the class id from all the products
update oc_product set tax_class_id = 0;
