[Skip to main content](#vessel-content) # Coupon and Tax calculation on Order Total wrong ## - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 10 months ago - 10 years 10 months ago [\#223264](#223264) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#223264 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* was created by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* -- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: - Detailed tax display: Yes - Type of address...: Billing - Main tax zone: Missouri (7.475%) - VAT number check: no check - Show taxed prices: no tax - Round prices during calculations: NO (it doesn't do it right if we enable this) - Floating tax prices: NO - Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones. Last edit: 10 years 10 months ago by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86286 - Thank you received: 14263 - - 10 years 10 months ago [\#223278](#223278) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#223278 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* Hi, You have two things to control how taxes are calculated for the coupons: - the "apply discount" setting of the HikaShop configuration - the "product tax category" setting of the coupon So you need to try the different combinations to get the one you want and that's it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 10 months ago [\#223344](#223344) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#223344 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* I am well aware of the tax options available at the product and system level… Please read the other post that's related to the same matter which also creates a problem for the authorize.net payment gateway… I may not fully understand the wording in the documentation with regard to the tax field and the coupon itself but again changing the coupon to taxable seems to take care of this, however as noted here: [ www.hikashop.com/forum/payment-methods/8...-invalid.html#223268](http://www.hikashop.com/forum/payment-methods/879841-authorize-net-270-line-item-2-is-invalid.html#223268) ...there is something wrong with the way the taxes are being calculated with regard to the total of the order. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86286 - Thank you received: 14263 - - 10 years 10 months ago [\#223346](#223346) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#223346 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* Let's continue on only one thread for the same issue please. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 10 months ago [\#223422](#223422) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#223422 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* Then pick which one. There is an issue on both fronts. If you use a coupon it causes authorize.net to fail. Otherwise the order total is wrong. So tell me, where should I be to get this problem fixed! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 10 years 10 months ago [\#223774](#223774) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#223774 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* Hi, We already replied to the authorize.net coupon issue and we also provided the patch. Like Nicolas wrote ; please do not mix your messages in several threads for the same subject. You created a thread for your coupon/tax issue ; that's good. Lets' authorize.net issue in the authorize.net thread and the coupon issue in the coupon thread. Ok ? So, please provide details about your HikaShop configuration for the coupon and also some details about your coupon code configuration. > You have two things to control how taxes are calculated for the coupons: > \- the "apply discount" setting of the HikaShop configuration > \- the "product tax category" setting of the coupon > So you need to try the different combinations to get the one you want and that's it. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 10 months ago - 10 years 10 months ago [\#223784](#223784) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#223784 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* I am sorry that I did not follow protocol, however I was told to open a new thread on an issue that is tied to this one. I first addressed the symptom--where the Authorize.net payment plugin fails to properly sanitize the data submitted to authorize.net and then this thread to address one of the causes I encountered. 1. The authorize.net line 270 issue is not fixed. The authorize.net gateway plugin is not submitting the correct information resulting in the error. One of the issues that help to expose this bug is the use of the coupon which I was then told to open a new thread on. The only way I could "fix" the payment plugin was to change the setting in the plugin to not send the order details to Authorize. Which is NOT the desired choice, but we have to keep the shopping cart going. 2. The coupon issue helps to break the authorize.net payment gateway plugin. But as noted you can see it has issues on its own, no matter what payment plugin is used to settle the order. [ ![screen_shot_order_2015-12-10.png](/forum/attachment/28405) ](/forum/attachment/28405 "...2015-12-10.png") As noted in this (the "coupon thread") if I make the coupon Taxable, it will calculate the product tax correctly (for an unknown reason) but it miscalculates the total of the order. Also as noted earlier in this thread the tax settings are repeated here for your convenience: Coupon: Percentage discount, Product tax category None. > Detailed tax display: Yes > Type of address...: Billing > Main tax zone: Missouri (7.475%) > VAT number check: no check > Show taxed prices: no tax > Round prices during calculations: NO (it doesn't do it right if we enable this) > Floating tax prices: NO We have one tax jurisdiction for our State that should calculate 7.475% on taxable goods for billing in the state of Missouri. All of our products are taxable. As shown in the data in both threads, when the percentage coupon is applied, the order total is incorrect. - [ ![screen_shot_order_2015-12-10.png](/forum/attachment/28405) ](/forum/attachment/28405 "...2015-12-10.png") [ ](/forum/attachment/28405?download=1 "...2015-12-10.png") Last edit: 10 years 10 months ago by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 10 months ago - 10 years 10 months ago [\#224430](#224430) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#224430 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* Any hope of at least acknowledging there is a problem here with the order totals and an eta? Christmas shoppers totaly confused with the bizarre order totals they're getting. Will using a 3rd party coupon system like AWO bypass this issue in Hikashop?? Last edit: 10 years 10 months ago by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[DinaLou](/forum/user/40057-dinalou "View DinaLou's Profile")** - [![DinaLou's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40057-dinalou "View DinaLou's Profile") - [ Offline](/forum/user/40057-dinalou) Less More - Posts: 6 - Thank you received: 1 - - 10 years 10 months ago [\#224790](#224790) by [DinaLou](/forum/user/40057-dinalou "View DinaLou's Profile") Replied by *[DinaLou](/forum/user/40057-dinalou "View DinaLou's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#224790 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* I'm having a similar problem. Only I use TaxCloud. Without a coupon applied all of the numbers are correct. After a coupon is added the numbers don't add up. I did some calculating and it looks like it is applying the tax amount BEFORE the discount instead of using the new adjusted tax amount. [ ![before.png](/forum/attachment/28565) ](/forum/attachment/28565 "before.png") [ ![after.png](/forum/attachment/28566) ](/forum/attachment/28566 "after.png") - [ ![before.png](/forum/attachment/28565) ](/forum/attachment/28565 "before.png") [ ](/forum/attachment/28565?download=1 "before.png") - [ ![after.png](/forum/attachment/28566) ](/forum/attachment/28566 "after.png") [ ](/forum/attachment/28566?download=1 "after.png") The following user(s) said Thank You: [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[TaxCloud](/forum/user/32971-taxcloud "View TaxCloud's Profile")** - [![TaxCloud's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32971.jpg)](/forum/user/32971-taxcloud "View TaxCloud's Profile") - [ Offline](/forum/user/32971-taxcloud) Less More - Posts: 41 - Thank you received: 14 - - 10 years 10 months ago [\#224942](#224942) by [TaxCloud](/forum/user/32971-taxcloud "View TaxCloud's Profile") Replied by *[TaxCloud](/forum/user/32971-taxcloud "View TaxCloud's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#224942 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* This issue is correctly identified - any discounts or adjustments to the sales price MUST be applied BEFORE sales tax calculation. TaxCloud documentation on this point is explicit, and our last review of the HikaShop implementation adhered to the requirement. Did something change (question for team HikaShop)? --- TaxCloud is the internet's only free sales tax service. Learn more at [ taxcloud.com](https://taxcloud.com) Support available via [ service.taxcloud.net](http://service.taxcloud.net) or by email to service@taxcloud.net Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 10 years 10 months ago [\#224963](#224963) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#224963 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* Hi, Nothing changed ; we always have a setting to let the shop owner decide if he want to applied the discount before or after the taxes. Because in some other countries, things could be different ! [ www.hikashop.com/support/support/documen...nfig.html#main\_taxes](https://www.hikashop.com/support/support/documentation/54-hikashop-config.html#main_taxes) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")** - [![stratacorps's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33546-stratacorps "View stratacorps's Profile") Topic Author - [ Offline](/forum/user/33546-stratacorps) Less More - Posts: 116 - Thank you received: 7 - 10 years 10 months ago - 10 years 10 months ago [\#224995](#224995) by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile") Replied by *[stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#224995 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* The order totals and how they are presented on the checkout page and the order/invoice are still incorrect as documented earlier. Last edit: 10 years 10 months ago by [stratacorps](/forum/user/33546-stratacorps "View stratacorps's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[DinaLou](/forum/user/40057-dinalou "View DinaLou's Profile")** - [![DinaLou's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40057-dinalou "View DinaLou's Profile") - [ Offline](/forum/user/40057-dinalou) Less More - Posts: 6 - Thank you received: 1 - - 10 years 9 months ago [\#225215](#225215) by [DinaLou](/forum/user/40057-dinalou "View DinaLou's Profile") Replied by *[DinaLou](/forum/user/40057-dinalou "View DinaLou's Profile")* on topic *[Coupon and Tax calculation on Order Total wrong](/forum/46-discount-coupon/880933-coupon-and-tax-calculation-on-order-total-wrong#225215 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : any -- Error-message(debug-mod must be tuned on) -- : no errors displayed We are only using the native Hikashop components (coupon/discount codes. No 3rd party (e.g. AWO) installed. We have a coupon code for a 100% percentage off a specific product. When the shopper adds the correct item, and applies the coupon code, the shopping cart total is incorrect: Subtotal $25.00 Coupon $-25.00 Shipping $0.00 MO Sales Tax $0.00 Total $1.87 The total should be $0.00 Testing a 50% coupon... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 The .93 would be the correct tax calculation, but obviously the order Total included Tax on the $25.00 So Cart totals Before coupon... Subtotal $25.00 MO Sales Tax $1.87 Total $26.87 50% coupon applied... Subtotal $25.00 Coupon $-12.50 MO Sales Tax $0.93 Total $14.37 I have also tried using a Flat amount coupon with the same results. The Tax Line is CORRECT, but the order total is not using this value, its using the total tax before discount. Our tax settings are: * Detailed tax display: Yes * Type of address...: Billing * Main tax zone: Missouri (7.475%) * VAT number check: no check * Show taxed prices: no tax * Round prices during calculations: NO (it doesn't do it right if we enable this) * Floating tax prices: NO * Apply discounts: Before taxes EDIT: The coupons have the field "Product tax category" set to None. So I went in and changed the coupon field setting to Taxable and I think it works. In reading the documentation, we should be able to leave this as the default "None" ??? But this does work around the issue if it doesn't affect shipments to non-taxable zones.")* I already have the coupon setting set to the BEFORE option. I don't know what to do! [ ![coupon.png](/forum/attachment/28661) ](/forum/attachment/28661 "coupon.png") - [ ![coupon.png](/forum/attachment/28661) ](/forum/attachment/28661 "coupon.png") [ ](/forum/attachment/28661?download=1 "coupon.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84ODA5MzMtY291cG9uLWFuZC10YXgtY2FsY3VsYXRpb24tb24tb3JkZXItdG90YWwtd3Jvbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.328 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)