[SOLVED] SQL Query for Pricing

[brad-w]

My company is interested in updating pricing across the entire site (over 700 products).

I was wondering if it's possible to write an SQL query that would round all prices up (ideally to the nearest .50 increment above what they are currently at).

For example, $14.08 ---> $14.50
and $14.78 ---> $15.00

I really appreciate any advice you can offer, such a time saver to not do this by hand..

Thanks,

Brad

[rocky]

What version of PrestaShop are you using? In v1.3.1, you can simply go to the Preferences tab and change the "Round mode" to "Superior" to round all prices up.

[brad-w]

I'm using 1.3.1 but I'm not looking to round prices up to a dollar and cents value, I'm looking to round all prices to the nearest half dollar.

[DutchCoding]

Got access to PHPMyAdmin?

[DutchCoding]

Here is a freebie
incase you have another databas prefix change the 'ps_' to the example 'am_product'

Just run this sql query in your PHPMyAdmin and your done

UPDATE `ps_product` SET `price` = (SELECT (CEILING((`price`)*2)/2))

hope this helps

[brad-w]

Thanks a lot, EXACTLY what I was looking for =)