I propose to add a column to the main table that will display the total price of the product when a discount is made on the product.
At the moment this function is performed by the column - SPECIAL.
But in it there is just a tick that there is a special price for the product. And what is the final price of a discounted product you have to look at on the site.