Increase price on all products universally?

[genesis@genesissyste]

Hello guys

I need to increase 35% to all my products in zen_products

Can you help with the script to used in mysql


Please help..........

[Ajeh]

This is two step ...

Backup your database before doing this ...

In the Tools ... Insert SQL Patch ... you can run the command:

PHP Code:

UPDATE products SET products_price = products_price * 1.35; 


Then go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

NOTE: If you have attributes you have to look to see if you can use something similar for them as well ...

NOTE: if you have Specials, you will need to update those as well but it depends on how your specials are made ...

[Marg]

I'll thank you for that one!! Handy little tid-bit!
Marg

[genesis@genesissyste]

Hello AJEH

your MYSQL script work very good.........

thanks

[kitcorsa]

i have a post regarding inflation etc and it goes into a little more detail. if you search for inflation you should find it.

[coucho]

Originally Posted by Ajeh

This is two step ...

Backup your database before doing this ...

In the Tools ... Insert SQL Patch ... you can run the command:

PHP Code:

UPDATE products SET products_price = products_price * 1.35; 


Then go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

NOTE: If you have attributes you have to look to see if you can use something similar for them as well ...

NOTE: if you have Specials, you will need to update those as well but it depends on how your specials are made ...

If I need to decrease prices by 5% do I change the 1.35 referenced in the quote to 0.95?

[raimond]

Don't forget the products_price_sorter either with this

UPDATE products SET products_price_sorter = products_price_sorter * 1.35;  

[Ajeh]

Wait ... don't do the Products Price Sorter in that method ...

You want to use the updater in the Tools ... Store Manager ... as I mentioned above to do the fix on the products_price_sorter ...

That price is not always the same as the products_price and updates to it need to be processed ...

While a percentage change to both fields may "appear" to work, this is not always the case and will result in displays in price order to become jumbled ...

It can work under "some" circumstances, however, the safe and sure way to update that field is to use the Update in the Store Manager and do it the right way ...

[miles]

If I want to increase the price to 4%, is this the right setting?

PHP Code:

UPDATE products SET products_price = products_price * 0.04; 


[data_digger]

No, this is:

UPDATE products SET products_price = products_price * 1.04;