I think that it is very illogical and unnecessarily difficult to change the sales prices.
Instead of a compare price logic, there should just be a sales price column, so that the original price does not have to change.
Right now you have to copy the original price into the compare price column, and put the new price into the price column. It is just an extra unnecessary step instead of just being able to put in a sales price.
Please change it!