Treat Sale as Discount (Show "Regular price – Sale price = Discount" in checkout and order data)
Say we have a $100 item.
If you have a 10% off coupon for this item, in the order export data you will see that the Order Total = $100, Order Subtotal = $90, and Order Discount = $10
However, if I have the same item on sale for 10% off you will get the following in the report.
Order Total = $90, Order Subtotal = $90, Order Discount = $0
This leads to confusion in the order export data, as it is not correctly showing products on sale as being discounted.
The Sale is nothing but a discount offered on the product and hence, it must be shown as a discount on the checkout and in the order data.
This is working as intended.
Fahad Sheikh commented
This is absolutely necessary