CODEWITHSUNDEEP
phpopencartopencart2.x
Pramod
Pramod

Reputation: 716

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?

Upvotes: 0

Views: 638

Answers (1)

Amandeep Singh
Amandeep Singh

Reputation: 274

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

Upvotes: 1

Related Questions