Post by activ » Fri Jun 15, 2012 2:46 pm

Hi,

I am running Opencart 1.5.3.1 with no mods or anything and the default theme.
The problem I am having is that when I create a discount coupon based on a percentage the amount of discount is calculated before adding vat, this results in an amount that makes no sense to the end customer. Not sure about the rest of the world but Dutch customers are used to not being bother by anything without vat so all discount should be on the price including vat.

Example: If the price excluding vat is 100 euro, the price including vat will be 119 euro and a 10% discount should be 11,90 euro. (not 10 euro which it is now)

Could you please either correct this or make it configurable?

Thanks in advance for taking the time to read this and maybe help out.

Newbie

Posts

Joined
Fri Jun 15, 2012 2:38 pm

Post by marissaj » Wed Jul 04, 2012 3:44 pm

I'm having the same problem and would be great if someone had a way to fix this???

Newbie

Posts

Joined
Wed Apr 18, 2012 6:29 am

Post by daisybeedesign » Wed Sep 05, 2012 5:00 pm

I am having the same issue - I need the discount code to come off incuding vat

i.e £25 - 20% = £20 = £5 discount

£25 - vat = £20.83 - 20% code = £4.17 dicount

New member

Posts

Joined
Wed Jan 18, 2012 12:44 am

Post by ADD Creative » Thu Sep 06, 2012 12:42 am

A 20% discount off the ex. VAT price, once you add the vat, is the same as 20% off inc. VAT price.

So inc. VAT price of £25 is £20.8333
20% of £20.8333 is £4.1667
So the ex. VAT price after discount is £20.833 - £4.1667 = £16.6666
20% VAT of £16.6666 is £3.3333
£16.6666 including £3.3333 VAT is £20

20% of the inc. VAT £35 price is £5
£25 - £5 = £20 which is the same result above.

I have tested this in OpenCart 1.5.3.1 and it works fine. If you do not get the same result it might be down to the Status or sort order of your Order Totals.

Shops in the UK will show the discount on the inc. VAT price in store. If you ask them for a VAT invoice, it will show the ex. VAT discount price, as it has to by law. See http://www.hmrc.gov.uk/vat/managing/cha ... -etc.htm#1

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by SXGuy » Thu Sep 06, 2012 1:25 am

100 + 20% vat = 120 inc vat
120 - 10% = 108 inc vat
108inc vat / 6 (20%) = 18
108 inc vat - 18 = 90 ex vat

100 - 90 = 10 = 10% discount (ex vat)
120 - 108 = 12 = 10% discount (inc vat)

Only way it cant be working for you, is if your not inputting the correct excluding vat price for your products. or your order totals are in the wrong order.

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by ADD Creative » Thu Sep 06, 2012 2:05 am

OpenCart will subtract the VAT on the discount from the total VAT at the end.

So taking your example, 100 - 90 = 10 (10% ex. VAT discount), OpenCart will display this.

10 * 0.2 (20%) = 2, OpenCart calculates the VAT on the discount amount.

20 - 2 = 18 (VAT), Opencart subtracts the VAT on the discount from the total VAT.

90 + 18 = 108, Opencat shows this as the total.

What final order total do you get for your example?

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by daisybeedesign » Thu Sep 06, 2012 2:30 am

I have my order totals laid out so it is

Subtotal
Vat
Discount
Shipping
Total

subtotal shows as ex vat - so discount comes off the ex vat price

So if my product is £25 inc vat
Sub total shows as £20.83
Discount is 20% = £4.166
So total product price with 20% discount is £20.83

I wanted this to be £25 (inc vat) minus 20% discount (£5) = £20 (inc vat)

I am a "moron" as pointed out by the big man Daniel this morning so I have no idea what I am doing wrong (and feel like shit for having had such a negative response to a query from a company I try and support and promote where I can).

New member

Posts

Joined
Wed Jan 18, 2012 12:44 am

Post by activ » Thu Sep 06, 2012 2:17 pm

Okay, I do agree that the result is the same but I'd still like the option to show the discount as coming of the amount including tax. That's what Dutch customers are used to and they get confused with the current way.
If this could be configurable it would be really nice.

Newbie

Posts

Joined
Fri Jun 15, 2012 2:38 pm

Post by ADD Creative » Thu Sep 06, 2012 4:47 pm

daisybeedesign wrote:I have my order totals laid out so it is

Subtotal
Vat
Discount
Shipping
Total

subtotal shows as ex vat - so discount comes off the ex vat price

So if my product is £25 inc vat
Sub total shows as £20.83
Discount is 20% = £4.166
So total product price with 20% discount is £20.83

I wanted this to be £25 (inc vat) minus 20% discount (£5) = £20 (inc vat)

I am a "moron" as pointed out by the big man Daniel this morning so I have no idea what I am doing wrong (and feel like shit for having had such a negative response to a query from a company I try and support and promote where I can).
You have to have your Taxes (VAT) just before the final total. The discount is shown ex. VAT as that is how the calculations are done internally. It has to be this way as, at least in the UK, as you must by law show the ex. VAT total of all products shipping, and discounts on a VAT invoice. And you must also show the VAT due on the totals.

The order needs to be (this is the default on install).

Subtotal
Discount
Shipping
Vat
Total

I think what is confusing, is that the products lines show the inc. VAT price, that makes people think that the totals are inc. VAT when they are not.

Maybe there are extensions that will do want you want. The other option is to switch of taxes completely and just use inc. VAT prices for everything and do your VAT invoicing manually. But you would have problems if you sold outside the EU.

How OpenCart works internal is correct, this is not a bug, it's just some people want to show the information to customers in a different way.

The developers get a lot of bug reports that are not bugs. Only today some one told them that postcodes should not have letters in only numbers.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by daisybeedesign » Thu Sep 06, 2012 5:00 pm

Hi Ad Creative

Thanks again for taking the time to reply - very much appreciated . I'll take another look at this today.

New member

Posts

Joined
Wed Jan 18, 2012 12:44 am

Post by ADD Creative » Thu Sep 06, 2012 8:11 pm

Actually the default order is shipping before discount, but this does not effect the calculations.

Subtotal
Shipping
Discount
Vat
Total

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by SXGuy » Thu Sep 06, 2012 8:37 pm

change the order totals to this.

Subtotal
Shipping
Vat
Discount
Total

Does that do what you want?

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by ADD Creative » Thu Sep 06, 2012 9:41 pm

SXGuy wrote:change the order totals to this.

Subtotal
Shipping
Vat
Discount
Total

Does that do what you want?
The discount is calculated internally on the ex. VAT price so must always be before the VAT total, otherwise the VAT will be too high.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by gibby » Mon Jun 23, 2014 4:49 pm

We have the same problems and unable to resolve it, making opencart useless for the UK market.

Has anyone managed to sort this issue for the UK?

We have used other carts that work fine with UK VAT & discount coupons

Thanks

G

New member

Posts

Joined
Mon Jul 08, 2013 3:27 am

Post by Johnathan » Mon Jun 23, 2014 10:56 pm

As discussed in this topic, you need to make sure your "Taxes" Order Total comes after your "Coupon" Order Total.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by trinkaljuneja » Tue Jun 24, 2014 6:32 pm

try sorting in order totals

A coder by Hobby and Developer by Profession

Images in Manufacture
http://www.opencart.com/index.php?route ... on_id=6943
Description and images in Manufacture
http://www.opencart.com/index.php?route ... on_id=6978

http://codertj.com


New member

Posts

Joined
Tue Aug 23, 2011 9:08 pm

Post by webdesires » Tue Nov 24, 2015 1:07 am

We have developed a VQMOD which does what you need:

http://www.opencart.com/index.php?route ... n_id=24744

Regards, WebDesires.
We are a team of developers in the UK - professional and friendly, message us or give us a call anytime and we will be happy to help.

Phone: +44 (0) 121 318 6336 - Web: webdesires.co.uk - Skype: WebDesires
OpenCart Support - OpenCart Web Development - Our OpenCart Plugins


User avatar
Active Member

Posts

Joined
Mon Sep 28, 2015 6:34 pm
Location - West Midlands, United Kingdom
Who is online

Users browsing this forum: No registered users and 37 guests