[FIXED] How to add reward point to all products at once in opencart

Issue

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?

Solution

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

Answered By - Amandeep Singh

Answer Checked By - Terry (PHPFixing Volunteer)