phpopencartopencart2.x

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

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