Backup your database and you can use:
This will change the Product Price from $45.00 to $46.00 where the current price is $45.00 ...Code:UPDATE products SET products_price = 46.00 WHERE products_price= 45.00;
Printable View
Backup your database and you can use:
This will change the Product Price from $45.00 to $46.00 where the current price is $45.00 ...Code:UPDATE products SET products_price = 46.00 WHERE products_price= 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.
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:
And, when done, you would want to go to the Tools ... Store Manager and run the:Code:UPDATE products_attributes SET options_values_price = 1.99 WHERE options_values_price = 1.95;
Quote:
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 usedto update all items in my shop buy 11% , seems to work :)PHP Code:
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: