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.


It's 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 you've 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;