Post by seniorx » Wed Aug 27, 2014 4:25 am

Hello, I'm having a serious issue, I need to update (set them to 0) the prices of every product with price is more than x.
The reason that my business is of importations and the exchange rate went up really bad, so for expensive products I just can't sell them on their current prices.
So if I'm right the best way to do it is with a sql sentence, but I'm afraid of doing things wrong because I don't know about sql. I just know that I should use update and if commands...

I need to set those prices to ' 0 because I have a module that when prices are 0 it doesn't show the price and you can ask for a quote instead of buying, so that is going to solve my problem.

Hope someone can help me with this.... Last time I made something on phpmyadmin it went bad... So I hope you understand.

Thanks

New member

Posts

Joined
Mon Aug 15, 2011 2:07 am

Post by MarketInSG » Thu Aug 28, 2014 4:42 pm

Code: Select all

UPDATE oc_product SET price = 0 WHERE price >= '99.99'
change accordingly


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by seniorx » Mon Sep 01, 2014 2:24 am

Thanks very much!

New member

Posts

Joined
Mon Aug 15, 2011 2:07 am

User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore
Who is online

Users browsing this forum: Majestic-12 [Bot] and 18 guests