Issue with VAT Calculation for Bundled Products

  • Resolved pixelsee

    (@pixelsee)


    3 months, 3 weeks ago

    I am experiencing an issue with the VAT calculation for bundled products. The problem arises because the VAT is calculated based on the individual prices of the products in the bundle rather than the actual discounted bundle price. This results in an incorrect (higher) VAT amount being charged to customers.

    Steps to Reproduce:

    1. Create a product bundle using WPC Product Bundles.

    2. Set a regular price and a discounted price for the bundle in WooCommerce.

    3. Add products to the bundle, each with their own individual prices and VAT rates.

    4. Apply a total discount at the bundle level (e.g., a fixed discount or a percentage discount).

    5. Add the bundle to the cart and proceed to checkout.

    Observed Behavior:

    ? The VAT is calculated based on the sum of the individual product prices before the discount is applied, leading to a higher VAT amount.

    Expected Behavior:

    ? The VAT should be calculated based on the discounted bundle price to accurately reflect the actual amount charged to the customer.

    Additional Information:

    ? I have multiple bundles with different sets of products, each with different regular and sale prices.

    ? The issue persists regardless of whether the discount is applied as a fixed amount or a percentage.

    ? I have attempted to manually adjust the VAT calculation using WooCommerce hooks but have not been successful in resolving the issue.

    Example:

    ? Bundle Regular Price: €181.90

    ? Bundle Sale Price: €139.99

    ? Products in the Bundle:

    ? Product A: €19.99

    ? Product B: €19.99

    ? Product C: €19.99

    ? (and so on…)

    ? The total discount for the bundle is €41.91.

    ? The VAT should be calculated on €139.99, but it is currently being calculated on €181.90.


    Request:

    ? Please provide guidance on how to correctly configure VAT calculations for bundled products based on the discounted bundle price.

    Thank you for your assistance in resolving this issue.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Janilyn T

    (@janilyn409)

    Hi @pixelsee ,

    When your smart bundles include products with different tax rates applicable, please use the auto-calculated price as the main pricing method and use the percentage discount only for your bundle so that the total can be calculated properly.

    With the manual fixed total or amount discount, we use a negative amount to offer discount, so it might cause issues in calculating the tax as in your case. Please check the settings of your bundles again.

    Best regards.

    Thread Starter pixelsee

    (@pixelsee)

    Hi @janilyn409 ,

    Thank you so much for your help!

    This was a huge problem for us, and using the percentage discount seems to have fixed it. A quick side note: it is a bit tricky to hit exact amounts. I think this might be due to how the discount is calculated, but it is a downside. Any ideas?

    As an example, our regular price is €181.95, and I want it to be €139.99, which should be a 23.0401% discount. However, this yields a price of €140.05.

    Thanks again for your help!

    Plugin Support Janilyn T

    (@janilyn409)

    Hi @pixelsee ,

    Maybe you can consider providing an additional couon for buyers to purchase your bundle in that case. It’s kind of difficult to calculate the exact total price based on percentage discount, but coupons can be applied to bundles to reduce the final total to what you would like it to be.

    I think this is the only workaround for that case.

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.