Increasing the prices across the board...

Is there a way that I can increase the prices of all products in my zencart installation across the board by a certain percentage?

For example, if I have 300 products, instead of going in and changing the prices of each product, I'd like to increase the price of every product by 5%.

Thanks!!!

you could write a sql and increase it by what ever percent you want.

nomad

nomadrw:

you could write a sql and increase it by what ever percent you want.

nomad

That's not a bad solution - but isn't there a solution from the admin panel? I mean, what if I had a whole heckuvalot of products (say thousands), and my overhead caused me to have to increase all my pricing by 5% or 10% to cover this new overhead? Would I really have to go in and either manually (one by one) increase the pricing, or write a SQL statement to increase the pricing from the database side?

It just seems like there must be a way to accomplish this in a simple way... but maybe I'm wrong...? :blink:

There's no way I know of to do this from the admin. Writing a mySQL statement is probably the fastest way to do it, but unless you know what you're doing, it could be tricky. Make certain you have a current backup of your database before attempting anything like this.

Yikes! Seriously, no doubt. I'm not a fan of throwing SQL directly at databases. Maybe this would be a good idea for a plugin...?

afo:

There's no way I know of to do this from the admin. Writing a mySQL statement is probably the fastest way to do it, but unless you know what you're doing, it could be tricky. Make certain you have a current backup of your database before attempting anything like this.

Changing the value of a dollar (or whatever your base currency is) from Localization /Currency to a value other than 1.00000000 does change all the prices. I'm not sure what other problems this will cause but shipping does come to mind. Just kinda thinking out loud here so be sure to watch out for the salt.

I wouldn't do that. I'd be afraid it would cause problems with other currencies or other parts of Zen Cart.

I could write the mySQL statement, but I'm a bit afraid to go there. :blink:

would that affect the other Currences if one is using auto updates on the other Currencies?

nomad

I never said it was a good idea, just easy :P

senattor, check your PMs. I sent you a mySQL statement to do this. I tested it, but use it at your own risk.

Could you also send me an SQL statement to increase prices by 5%?

Thanks in advance.

Coucho

https://www.internationalcoffeeandbeverage.com

I would need one to. With 10%.
Cant anyone post the query in the forum?

/Jagge

I'd have to work it out again. It's not something I'd post to the forum since it's really not recommended.

Similar post with details of how to by ajeh
at
http://www.zen-cart.com/forum/showthread.php?t=79927

Thanks, Misty. I didn't realize Ajeh had posted that. That's exactly the mySQL statement necessary. If you want to raise the prices by 5%, change 1.35 to 1.05. To raise them by 10%, change the 1.35 to 1.10.

You can either run that in the admin under tools-> insert SQL patch or using phpMyAdmin from your webmaster panel which will provide you with a box to run the statement.

No problem afo..
Just as matter of interest, if
wanted to DECREASE by 5%, what would sql
statement be then please?

misty:

No problem afo..
Just as matter of interest, if
wanted to DECREASE by 5%, what would sql
statement be then please?

To decrease prices by 5%, change the 1.35 to .95.

Thanks very much afo..
:smile: