Skip to content
Advertisement

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?

Advertisement

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

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement