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.
-
Anonymous commented
Please re-open this suggestion, the haphazard way WooCommerce handles discounting needs to be fixed with all the new order table work happening in 2022.
-
Federico commented
absolutely necessary, re open this topic pls!
-
Stefan commented
To quote Warren "This is working as intended.", maybe as you intended not the way people need it. In some countries the accounting system regulates that if you have a product on sale (NOT CUPONS), on the invoice you need to show the discount for the product, and there is no way to calculate that, because Woocommerce order gets the _price value. When you have a sale for that product _price = _sale_price.
-
Enzo commented
@admin we are having the same accounting issue, as the sale is not been reflected, 1000% sure this is NOT working as intended. Our Woocommerce version is the 3.7.0
-
Anonymous commented
+ Vote, would be helpful to know what discount (ie sale/ saving on the RRP/regular price) a customer has had, plus any discounts, @admin does not work as we admins want. (maybe as you intend?)
Shipping: £18.00
Tax: £10.67
Total: £82.00
/\ no discount or savings on regular price in the breakdowns or at line items -
Fahad Sheikh commented
This is not working as it should. When we do an audit after 6 months our entire inventory is out of sync. There is no way we could find out if a 6 months old order was sold on a sale price. Our entire audit is out of sync.
We're sold a product on a lesser amount but no one knows why
-
JustA commented
We really need this!!!
Yes, is absolutely necessary! -
Jenn commented
How do I revert this and remove the weird jumbling of assorted sale price differences in a random "Discount" line item away from the products? I'd prefer if the sale price was attributed to the item rather than the default non-sale price on the transaction. A sale price is not a coupon!
-
Fahad Sheikh commented
This is absolutely necessary