Post by earthgirlllc » Mon Apr 11, 2011 11:05 am

I have a client who wants to lower prices in mass. I don't see where to do this. Any help appreciated, thanks much. :)

New member

Posts

Joined
Mon Apr 11, 2011 11:02 am

Post by qahar » Mon Apr 11, 2011 12:11 pm

Try to search it on extension, I can see two extensions that will fit your need.

User avatar
Expert Member

Posts

Joined
Tue Jun 29, 2010 10:24 pm
Location - Indonesia

Post by mystifier » Mon Apr 11, 2011 4:51 pm

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)

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


User avatar
Active Member

Posts

Joined
Tue May 18, 2010 5:15 pm

Post by earthgirlllc » Tue Apr 12, 2011 7:22 am

Thank you mystifier - that will work! :)

New member

Posts

Joined
Mon Apr 11, 2011 11:02 am
Who is online

Users browsing this forum: No registered users and 126 guests