Global price change?

Backup your database and you can use:

UPDATE products SET products_price = 46.00 WHERE products_price= 45.00;

This will change the Product Price from $45.00 to $46.00 where the current price is $45.00 ...

I tried using it but it didn't change any prices. Here's the text I got for one of my result

Query Results:
UPDATE zen_products SET products_price = 28.98 WHERE products_price= 28.00;

In phpMyAdmin run the command:
SELECT * from zen_products WHERE products_price= 28.00;

How many come up?

0

However I did discover the problem. I'm from Australia so I'm used to working on prices after tax has been included. So the reason it didn't work is that I was working of the final price...not the pre-taxed price.

Once I readjusted back to the pre tax price they all changed. Thankyou for your help.

Ajeh:

Backup your database and you can use:

UPDATE products SET products_price = 46.00 WHERE products_price= 45.00;

> 
> This will change the Product Price from $45.00 to $46.00 where the current price is $45.00 ...

This is SO close to what I need, but not quite there :dontgetit
I need: *update product set price 1.99 where price 1.95 **by attribute*** - all products that are priced by attribute have the same price (1.95) for attribute A, or (3.85) for attribute B. I want to add 4p to each of the cheaper ones.

If all of these are based on Priced by Attribute, then the Price is in the Attributes table:
products_attributes

Browse the products_attributes table and see if what you are wanting is to change the options_values_price to 1.99 where it is currently set to 1.95 ...

If so, you want to backup your database and you can then use:

UPDATE products_attributes SET options_values_price = 1.99 WHERE options_values_price = 1.95;

And, when done, you would want to go to the Tools ... Store Manager and run the:

Update ALL Products Price Sorter
to be able to sort by displayed prices:

That was exactly it! Many thanks, saved a laborious manual update of dozens of items :laugh:

Thanks for the update that this worked for you ... remember us when you are rich and famous ... :cool:

i used ```php
UPDATE products SET products_price = products_price * 1.11

:cry:

Hi

After reading posts this seems to b right place for this..

OK I need to change prices from trade price which are uploaded via easy populate but the price structure (increase) needs to be for example ..£0.00-£10.00 100% £11.00-50.00 40 % £51.00-£100.00 35% etc ..... Please point me in right direction lol for an sql patch ? or exel/open office calc formula

I will continue to read open office help files while i wait lol :no:

Backup first!
You will probably need to go in reverse order to prevent moving a lower priced item into a medium price and then upping it when increasing the medium.
In other words, start with the higher and work down to the <=10GBP. Doing a 9 to start would move it to 18 which would again be changed when you did the 11-50.

Try using this (NOT TESTED)> UPDATE products

SET products_price = products_price * 1.35
WHERE products_price => "51" AND products_price <= "100"Next, you'd go to the 11-50 prices and lastly, the 0-10 items.

My turn...my apologies if this has been asked and answered.

My client gave me the wrong price list and after doing over 550 attributes that are for items priced by attributes, he gave me the correct price list.

So...I too need to do a price increase of 7% on items priced by attributes. The issue is 90% of my products are priced by attributes. Is it possible to do a percentage increase. I saw Ajeh's post on changing the dollar amount, will the same idea work for a percentage? While I am at it, for future reference, is it possible to do the same but base it on a specific category as well?

Thank you in advance for any help.

Kelly

Hi All,

So im assuming

UPDATE zen_products SET products_price=products_price+7.50 adds £/$7.50 to all my product range and

UPDATE products SET products_price = products_price * 1.25;

does 25% accross the range

so heres the question, can i do a global decrease as in

UPDATE products SET products_price = products_price -* 1.25;

and

UPDATE zen_products SET products_price=products_price-7.50