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