How to add reward point to all products at once in opencart

Question

How to add reward point to all products at once instead of adding manually to each product? This is time consuming to add point to each product manually instead I want to add 2% of product price to reward point. How can i do this?

Answer

You can easily perform sql querys in phpmyadmin to update points.

Assuming your table name oc_product and point column name points

UPDATE oc_product SET points = price * 0.02 WHERE price > 0

take backup of your OC database before performing queries

Accepted Answer

You can easily perform sql querys in phpmyadmin to update points. Assuming your table name oc_product and point column name points UPDATE oc_product SET points = price * 0.02 WHERE price > 0 take backup of your OC database before performing queries

Advertisement

Answer