Couple things on updates to prices in the products table ...
1 be sure to note that zen_products table is really the products table so check your database table prefix before running the command ...
The better place to run this would be in the Tools ... Install SQL Patches ... and do so without the prefix as this will adjust the UPDATE correctly for your prefixes if you run those as, note semi-colon on the end or each line:
Code:
UPDATE products SET products_price= products_price *1.25;
Code:
UPDATE products SET products_price= products_price +7.50;
2 after changing prices, you should run from the Tools ... Store Manager ... the Update Price Sorter ...
Caution: if you use specials, these specials are not adjusted so be sure to consider the results of price changes ...
WARNING: Before doing any changes like this a Backup is always a good idea ...
Bookmarks