[SOLVED] query for updating price of all products through SQL

Quote

Post by ideep13 » Wed Oct 12, 2022 4:11 pm

Hi guys, I swear there was a topic about updating prices of all products through sql database. I can not seeem to find it.

How would the query be if I want to update the prices by 10%
Last edited by ideep13 on Thu Oct 13, 2022 5:05 pm, edited 1 time in total.
User avatar
ideep13
Active Member
Posts
288
Joined
Mon Jun 18, 2012 2:47 am
Top

Re: query for updating price of all products through SQL

Quote

Post by pprmkr » Wed Oct 12, 2022 4:27 pm

Code: Select all

UPDATE `oc_product` SET price = (price * 1.1)
User avatar
pprmkr
Active Member
Posts
1701
Joined
Sat Jan 08, 2011 11:05 pm
Location - Netherlands
Top

Re: query for updating price of all products through SQL

Quote

Post by ideep13 » Wed Oct 12, 2022 8:53 pm

THANK YOU :)
User avatar
ideep13
Active Member
Posts
288
Joined
Mon Jun 18, 2012 2:47 am
Top

Re: query for updating price of all products through SQL

Quote

Post by straightlight » Thu Oct 13, 2022 9:45 am

Now that the issue has been solved, please add: [SOLVED] at the beginning of the subject line on your first post.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22525
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: Bing [Bot] and 14 guests