update price globally

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.

luothree

Total Posts: 101
Karma: 541
Joined: 1/24/2011
Location: United States

Posted: 12 years ago

Hi

I have many products in my database. Is this a way that I can update the price (like rising to 10% of all prices) globally, without going to each manually changing its price.

Thanks

a.m.

Team Member

Total Posts: 16639
Karma: 156220
Joined: 10/22/2008
Location: Armenia

Posted: 12 years ago

You can do it on bulk edit page. Or connect to your database and execute the following SQL command:

UPDATE [ProductVariant]
SET [Price]=[Price]*1.10
GO

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.

Still have questions or need help?

. Premium support services . Get dedicated support from the nopCommerce team with a guaranteed response within 24 hours.

. Online course for developers . Get the practical and technical skills you need to run and customize nopCommerce websites.