SQL to update prices

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
4 years ago
Hello, my website is currently using nopcommerce 4.10 and I need to bulk increase sale price by 15% on all products via SQL and was wondering how to do so. Thanks.
0
4 years ago
Hello,

I think you should fire below query.

update product
set
price = price + ( price *15/100)

Also, you want to increase attribute than you have to execute same script with relavent table.

This query I didn't checked yet with SQL.

Please try and let me know.
+1 If answare is helpful to you.

I am passionate about new ideas and new way of thinking :-)

Cheers,
Smiten Kalathiya
0
4 years ago
AJ_Step1 wrote:
Hello, my website is currently using nopcommerce 4.10 and I need to bulk increase sale price by 15% on all products via SQL and was wondering how to do so. Thanks.


Try this:

update product set price = price * 1.15
Please vote UP the answer if it helps you!

https://www.nop-world.com - World's best plugins for nopCommerce
----------------------------------------------------------------------------------------------------
plugins, widgets, customizations, improvements, SEO, performance & more!
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.