Upping the prices store wide

For Articles relating to more than one ISC version
Post Reply
Darntoothysam
Confirmed
Confirmed
Posts: 33
Joined: Wed Jun 17, 2009 8:47 pm

Upping the prices store wide

Post by 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
Posts: 744
Joined: Thu Jun 18, 2009 8:59 am

Re: Upping the prices store wide

Post by 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
Confirmed
Confirmed
Posts: 33
Joined: Wed Jun 17, 2009 8:47 pm

Re: Upping the prices store wide

Post by Darntoothysam »

I hope he gets here soon, I'd like to get this done soon!
Thanks Tony, I hope it works :)
Darntoothysam
Confirmed
Confirmed
Posts: 33
Joined: Wed Jun 17, 2009 8:47 pm

Re: Upping the prices store wide

Post by 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
Confirmed
Confirmed
Posts: 413
Joined: Sun Aug 09, 2009 1:23 pm

Re: Upping the prices store wide

Post by 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?
ISC 4.0.7

"... and let's be honest that whole "by design" thing is getting old too."
Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

Re: Upping the prices store wide

Post by Martin »

CharlieFoxtrot wrote: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
Posts: 744
Joined: Thu Jun 18, 2009 8:59 am

Re: Upping the prices store wide

Post by Tony Barnes »

lol - how come I'm in brackets?!?1 :evil: :D
Tony Barnes
Posts: 744
Joined: Thu Jun 18, 2009 8:59 am

Re: Upping the prices store wide

Post by 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!)
Post Reply