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?
Asked
Active
Viewed 622 times
1 Answers
1
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
Amandeep Singh
- 276
- 2
- 13
-
Yes i know that. I need that single query to append all data automatically. – Pramod Mar 16 '15 at 12:14
-
Thank you very much it's sorted my problem. – Pramod Mar 16 '15 at 12:31
-
How can we write same query for oc_product_reward table their is also point for specific product? because price field is in product table not in this table. Can you help me in this? – Pramod Mar 16 '15 at 16:14
-
To achieve that you have use JOIN & SUB QUERIES – Amandeep Singh Mar 17 '15 at 06:04