In post #2, balihr suggests using products_price in the sql statement. You would need to use products_price_sorter in order to have the price in the right spot.
Code:
UPDATE products set products_price_sorter = products_price * 1.05 WHERE manufacturers_id = '123';
Still that would leave the red lettering and confusing Save -5% off that you show in the image of post #4
There are special CSS stylesheets that could be used to control that extra verbiage for either a manufacturer or category but, IMHO all the proceeding steps are just troublesome.
I would create a new category called Temporary Surcharged Items. I would copy the effected items from their other locations into the new category while making sure that I copy any attributes.
Using the Description for the Temporary Surcharged Items, you could explain to the customer that these charges are temporary and will be removed by.......
Then you could use
Code:
UPDATE products set products_price = products_price * 1.05 WHERE master_categories_id = '123';
where 123 is the category id of the Temporary Surcharged Items category you created.
If you used manufacturers_id is this MySQL it would change prices in both places and you don't want that.
The last thing is to disable the original items, categories, etc so that only the Temp Category is seen by the customer. They will see what looks like a standard checkout with no confusing red special text.
When the surcharge is lifted, simply disable the Temp category and turn the original items, categories, etc back on.
Hopefully, that explains it a little better.
Bookmarks