A "Sale Price" field would be very useful - and maybe a corresponding Sale Price Modifier field to go with it, would be very useful.
If these could be tied-in with some new Sale Start Date and Sale Expiry Date fields... even better.
Then the original standard price fields don't have to be touched... and a Sale promo can be set to run automatically without further intervention.