Upping the prices store wide

[Darntoothysam]

If I want to up the prices on our store by 5-10% how would it happen? I tried exporting the store, to both CSV and XML, and I see the prices but I don't know how to up them all in one lump sum.
Is there a way to do it on the PHP side of things?
It needs to be able to be quick, and cost effective.

Thanks,
Eric

[Tony Barnes]

Use phpmyadmin and run the following SQL statments to put an extra 10% on the price for all your products:

UPDATE `isc_products` SET `prodprice` = (`prodprice` * 1.10);

That should put 10% on top of things

To turn it off, run this:

UPDATE `isc_products` SET `prodprice` = (`prodprice` / 1.10);

Hmm, Martin may want to confirm this will work before you do it!!

[Darntoothysam]

I hope he gets here soon, I'd like to get this done soon!
Thanks Tony, I hope it works

[Darntoothysam]

HUGE thank you to you (Tony) and Martin!

Saved me weeks of work trying to raise 1300+ products. Damn SQL did it in less than 2 seconds. Unreal.
I've decided I need to learn PHP and SQL.

Thanks again!
Eric

[CharlieFoxtrot]

Damn! That's awesome! -- I haven't tried it yet, but I can see a time in the near future when this will come in VERY HANDY! Thank you!

Here's a question... for sellers who want to all of their product prices to consistently end in ".95", this math formula will result in many variations of the "cents" portion of the product price.

Is it possible to increase prices by 10%, and then round-up (or down) to the nearest 95-cents?

[Martin]

Here's a question... for sellers who want to all of their product prices to consistently end in ".95", this math formula will result in many variations of the "cents" portion of the product price.

Is it possible to increase prices by 10%, and then round-up (or down) to the nearest 95-cents?

Should be although I think you would need to write a small php script to handle it rather than a straight SQL statement.

[Tony Barnes]

lol - how come I'm in brackets?!?1

[Tony Barnes]

Could you just use Round like this:

UPDATE `isc_products` SET `prodprice` = ROUND((`prodprice` * 1.10),0) - 0.05

????

(lol, back to you Martin!)