Can prices be added globally to a range of products or only one product at a time?

[SteveB2009]

Rod,

Your detailed description and examples saved me a lot of time. Thanks for taking the time to post that info here. Being a newbie everything takes a lot of time.
cheers. SB

[RodG]

Rod,

Your detailed description and examples saved me a lot of time. Thanks for taking the time to post that info here. Being a newbie everything takes a lot of time.
cheers. SB

I'm glad you found the info useful. It is the reason why I prefer questions to be asked in the forum rather than PM, because the responses do often help others as well as the original poster.

Cheers
Rod

[l371juk]

The best/easiest way to do this would be via SQL commands. (if experienced)

The 'difficult' part will be figuring out what query string to use to select any given 'range'.

Zencart itself has no inbuilt functionality to perform global price changes, however you may find the following module useful.

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=101

Cheers
Rod

Hi Rod,
I would like to change some prices for just one manufacturer and have installed that quick updates patch, but I don't seem to see anything diferent. Where am i going wrong? Being able to globally change prices for a supplier would be very handy.
Thanks,
Andrew

[caesartrading]

Hi Rod,

I was reffered to this thread from one I posted just now. Here's what I wrote:

I want to increase a lot of my prices by £1, but am loathe to go to every single one and add £1 to each price.
Also, I only want to increase the price of products that are currently below £6.

I can imagine there's an easy bit of SQL code to use, but I'm not to familiar with it myself.

So, I just need to work out what SQL I need to run in order to do this.
Would something like this work?

update `zen_products` increase  `products_price` + 1.00 WHERE `products_price` < 6.00

Not entirely sure that's correct, but that's just using my newly found (albeit vague) knowledge of programming (currently in the process of Python for a different project)

Any help would be appreciated

Cheers

[RodG]

So, I just need to work out what SQL I need to run in order to do this.
Would something like this work?

update `zen_products` increase  `products_price` + 1.00 WHERE `products_price` < 6.00

Not entirely sure that's correct, but that's just using my newly found (albeit vague) knowledge of programming (currently in the process of Python for a different project)

For PHP it is more like:

update `zen_products` set  `products_price` = `products_price` + 1.00 WHERE `products_price` < 6.00 ;

WARNING: This is just off the top of my head. Don't be too surprised if its not correct. I can never remember when/where quotes are needed or whether they need to be single or double.

Cheers
Rod