Unanswered: Alter many cols in table with 1 command (and some maths)
so i currently have a table with products in it. Each product contains 12 units. The prices i have in my db include some tax at 21%. As a special offer i want to sell a product item(12 units) at the price of 11 units.
So is there some way i can query the db and tell it to calculate the price of 1 unit and then 11 and then VAT for that 11 and update all prices.
I would do it on a checkout page but the catalog is db driven so i would like prices to be changed there also.