I have a client who wants to lower prices in mass. I don't see where to do this. Any help appreciated, thanks much.
The simplest way to do this is with an SQL query on the database (eg. phpMyAdmin)
UPDATE product SET price = ROUND(price * 0.95, 2)
Will reduce all prices by 5% and round it to the nearest cent/penny.
Obviously, you can apply and rounding you want, for example:
UPDATE product SET price = (ROUND(price * 0.925, 1) + 0.09)
Would reduce all prices by 7.5%, round it to the nearest 10 cents/pence and add on 9 cents/pence to make it always end in 9.
(You will need to add a table name pre-fix if you use one, eg UPDATE oc_product)
UPDATE product SET price = ROUND(price * 0.95, 2)
Will reduce all prices by 5% and round it to the nearest cent/penny.
Obviously, you can apply and rounding you want, for example:
UPDATE product SET price = (ROUND(price * 0.925, 1) + 0.09)
Would reduce all prices by 7.5%, round it to the nearest 10 cents/pence and add on 9 cents/pence to make it always end in 9.
(You will need to add a table name pre-fix if you use one, eg UPDATE oc_product)
Free v1.4.9 Extensions: Default Specials | Improved Search | Customer Activity Report | Customer Groups | Royal Mail With Handling | Improved Product Page | Random Products | Stock Report | All Products
Who is online
Users browsing this forum: No registered users and 126 guests