[Critical] Price calculation fails in Woo Sale Report

  • Resolved Bravevn

    (@bravevn)


    3 years, 3 months ago

    I’m using Woo Discount Rules 2.3.9 with WooCommerce 5.9.0

    In the plugin setting, section Cart, I set “Apply cart discount as Fee“. I understand that this config will calculate the discount against the cart total only (and the price of each product in the cart will be intact).

    Everything went smooth on Black Friday, my customers are happy. However, when I checked WooCommerce’s Product Sales Report to see my stats, it showed weird numbers. The problem is stats are bigger than my real earnings.

    After a few investigations, I found that WooCommerce did not take the discounted amount into report calculation. For example, a cart has 2 products with the total is $200:

    • Software #1: $100
    • Software #2: $100
    • —————————
    • Subtotal: $200
    • Discount 30%: -$60
    • Total: $140

    The client paid $140 and I received $140. However, the report shows $200 which is the price before discount.

    I can change the setting to “Apply cart discount as Coupon” which will calculate the discount price directly in each product’s price and correct the WooCommerce report. However, it only affects future orders.

    The questions are:

    • Do you have an option or setting that subtract the discount directly into product’s price (the same mechanism as “Coupon”)
    • How can I get the correct numbers for my completed orders?</strong

    PS: I have a lot of new orders during BF and I don’t want to use excel to manually calculate the sale for each one

    • This topic was modified 3 years, 3 months ago by Bravevn. Reason: highlight some information
Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi

    Thanks for reaching out.

    We would like to clarify that our plugin does not update the prices in the backend (Sale price for discounts).

    Our plugin applies discounts on the fly dynamically while adding the product to the cart. However, it doesn’t change the price in the back-end. So, In such cases, it might not be possible to show the discount amount in woocommerce reports.

    Our plugin has a separate report system under the Report tab of the Discount rules plugin which shows the discount rules applied and also the order amount.
    ?The value in the report section indicates the discounted amount obtained from the active rules.

    ?Woocommerce reports will not take the discount applied through our plugin.

    We are so sorry that this might be the only possibility.

    ?Please do refer to the reports tab to check on the same.

    Thanks
    Team Flycart

    Thread Starter Bravevn

    (@bravevn)

    Thank you for your response.

    I did try but the default report of Discount Rules does not have enough basic data for the accounting.

    I hope that you guys will add this feature in the future updates, free or paid version doesn’t matter but the report is important.

    Hi

    Yes, we understand your concern.

    Thank you for your valuable feedback. We shall pass this information to the dev team to consider implementing the same in future releases.

    Feel free to reach out in case of any further queries.

    Thanks
    Team Flycart

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Critical] Price calculation fails in Woo Sale Report’ is closed to new replies.