SQL code to populate a wholesale column as a percentage of the product price.

[ilmarchez]

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.

[mc12345678]

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.

Backup database before performing. Use tools->install SQL patches from the admin panel.

UPDATE products SET products_price_w = (0.9 * products_price);

[ilmarchez]

Backup database before performing. Use tools->install SQL patches from the admin panel.

UPDATE products SET products_price_w = (0.9 * products_price);

Perfect, thank you!

[mc12345678]

Perfect, thank you!

Glad to get some code right today... :) Glad it worked for you too.. :) Good luck!