Global price change?

[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 ...

[Tannie]

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;

[Ajeh]

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

How many come up?

[Tannie]

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.

[travellers]

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
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.

[Ajeh]

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:

[travellers]

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

[Ajeh]

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

[xeontranq]

i used

UPDATE products SET products_price = products_price * 1.11 

to update all items in my shop buy 11% , seems to work :)

[CastleComputers]

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