Kroggers Posted September 4, 2008 Posted September 4, 2008 We have a need to do a blanket price update on all products in our database periodically due to exchange rate changes. As I do not know SQL, I was hoping someone here could help. I am not looking for something complex, or a cool contribution. i am happy to use the phpMyAdmin interface to run the SQL statement manually. All it has to do is update all prices by a given amount or reduce all prices by a given amount ie - update all prices by +0.25 or by -0.25 Any help is really appreciated :)
♥FWR Media Posted September 4, 2008 Posted September 4, 2008 I hate the "easy help" line when asking for help. It's not easy for you or you'd do it. UPDATE `products` SET products_price = products_price + 0.25 Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
Kroggers Posted September 4, 2008 Author Posted September 4, 2008 Thank you very much. I probably should have chosen my words better. It is hard for me with no SQL experience, but I assumed it to be easy for someone who knows hat they are doing - like you...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.