Discount error on Bundled Products – Possibly rounding error

  • Resolved wood1e

    (@wood1e)


    2 years, 3 months ago

    Hi

    We have set up Product bundles with the Bulk Discount plugin but there is an issue on the front end, when the discount is calculated.

    We have two bundled products, and the discount system works, but the calculation is wrong.

    1. https://peters331.sg-host.com/dev/shop/stock-up-bundles/mealpack-stock-up-bundle/

    Discounts in backend: https://www.screencast.com/t/o0gTvqB1

    The Discounts are

    50 – 69 | 5
    70 – 83 | 7
    84 – 111 | 12
    112 – 139 | 18
    140 – 167 | 20
    168+ | 22

    Example1: 110 Products = ￡159.50 with a 12% discount of ￡19.14 which gives a total: 140.36 but if we take the discount on 1 product ￡1.45 – 12% = ￡1.28 which is 110 x ￡1.28 = 140.80 so that is a difference of ￡0.44
    Example2: 71 products = ￡102.95 with a 7% discount of ￡7.21 which gives a total of: ￡95.74 but if we take the discount on 1 product ￡1.45 – 7% = ￡1.35 which is 71 x ￡1.34 = ￡95.85 so that is a difference of ￡0.11

    See here: https://www.screencast.com/t/8wjdbpCbdk

    1. https://peters331.sg-host.com/dev/shop/stock-up-bundles/bar-bundled-product/

    Discounts in back End: https://www.screencast.com/t/ZG6o29VdPv

    The Discounts are

    28 – 49 | 3
    50 – 69 | 5
    70 – 83 | 7
    84 – 99 | 12
    100+ | 18

    This has the same issue.

    I have shorten my examples

    50 x sale bar ￡1.80 (￡1.48) + 50 unsale bar ￡2.12 (￡1.74) had 18% discount applied – Cost in basket was ￡160.72
    50 x 1.48 = ￡74.00 – However cart showed ￡73.80 then 50 x ￡1.74 = ￡87.00 – However cart showed ￡86.92 – Total of amount the payment should be ￡161.00 (diff -28p)

    The amounts that are different is more than just rounding errors, but I cannot see what is the issue and why the discount would be so different?

    Am I missing something?

    PS – I have to post here as WooCommerce state this is nothing to do with Product Bundles plugin

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi there,

    Based on the examples you shared, I can see some issues with your calculations. The plugin works as expected:

    50 x sale bar ￡1.80 (￡1.48) + 50 unsale bar ￡2.12 (￡1.74) had 18% discount applied – Cost in basket was ￡160.72

    Here is how the calculation happens:

    The total Bundle price is 50*1.8 + 50*2.12 = 90 + 106 = ￡196

    On top of that, an 18% discount is applied: 196*0.18 = 35.28 With that, the final price is ￡160.72 exactly.

    The discount is calculated on the total Bundle price, not per product.

    I hope this clarifies things!

    Thread Starter wood1e

    (@wood1e)

    Yes thanks for that… Thanks for the clarification.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Discount error on Bundled Products – Possibly rounding error’ is closed to new replies.