Zen Follower
- Join Date:
- Aug 2009
- Posts:
- 128
- Plugin Contributions:
- 0
SQL code to populate a wholesale column as a percentage of the product price.
Hi,
I have installed the addon "Dual Pricing" so now my table "products" as two columns:
- "products_price"
- "products_price_w"
The column "products_price_w" is empty. for new products I'll set manually from the product admin the wholesale price, but I'd like to populate the "products_price_w" column for all the thousands of products I already have listed with a value calculated as 90% of the "products_price" (so all wholesale prices are discounted by 10%).
Could you please tell me the SQL Query to populate the "products_price_w" as 90% value of "products_price"?
It is an one time operation.
Thank you very much.