Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / VAT added depending on Attributes selected

VAT added depending on Attributes selected

Views: 1,493

Results 1 to 11 of 11
6 Oct 2011, 2:09 PM
#1
jamint avatar

jamint

New Zenner

Join Date:
Mar 2011
Posts:
59
Plugin Contributions:
0

VAT added depending on Attributes selected

Hi,

We sell many products that depending on the size have or havent got VAT included. So for instance sizes 2-5 of a shoe won't include VAT (childrens sizes) whereas 6-11 will include VAT.

Obviously i can set the gross price using attributes to get the correct totals. But on the customers invoice it will or won't show VAT depending on what i set the whole product to.

Is there a way to set a product to be priced by attributes and then have some of the attributes taxable and some non-taxable.

Thanks for any responses.

7 Oct 2011, 11:59 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

What country are you located in?

If United Kingdom, and you are selling to the public, all your prices must be displayed with vat INCLUDED. That is the law (UK Price Marking Order 2004).

18 Oct 2011, 10:04 PM
#3
jamint avatar

jamint

New Zenner

Join Date:
Mar 2011
Posts:
59
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

schoolboy:

What country are you located in?

If United Kingdom, and you are selling to the public, all your prices must be displayed with vat INCLUDED. That is the law (UK Price Marking Order 2004).

Thank you for your reply.

Yes i am in the UK.

What i am trying to say is that i am trying to set up a single product on the website for which some of the sizes (attribute options) include VAT and others are VAT exempt.

So a pair of shoes for instance might be £24.00 for sizes 2-5 (tax exempt) but sizes 6-11 are £28.80 as they include VAT.

We would like to make it so that if a customer selects a size 4 they are not charged VAT but with a size 8 they have VAT added.

Thanks,

21 Oct 2011, 1:58 AM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

Your displayed prices must be inclusive of VAT, so there is no configuration necessary in zencart.

What you need to do is calculate your total prices (some will be vat inclusive and others will be zero rated), but ultimately you will end up with a fixed value.

It is THESE values that you apply to your products.

For example:

Child's brown leather shoes: £10 (zero rated for vat) = £10.
So you display £10 as your price (whether it is the product or the attribute, it does not matter).

Adult's brown leather shoes: £12 (+ 20% vat) = £14.40.
So you display £14.40 as your price (again, whether it is the product or the attribute, it does not matter).

ACCOUNTING for the vat in your books is something which happens outside of zencart.

14 Jan 2012, 10:55 AM
#5
jamint avatar

jamint

New Zenner

Join Date:
Mar 2011
Posts:
59
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

Thank you for your response schoolboy.

But what i mean is that if there was a single product and some of the attributes included vat and others didn't the customer would need to see this on their invoice (for instance if they were putting the product through their books).

So when size 4 of a product is added then the vat would need to be 0% but if size 6 was added then 20% would be added. And they might be different prices.

It is not for our books that i need this calculated (as our accounting is done outside of Zen) but i do not want it to display incorrectly on the customers Zen cart invoice.

Hopefully i am not missing something :blink:

https://www.redpostequestrian.co.uk

14 Jan 2012, 12:38 PM
#6
fairestcape avatar

fairestcape

Totally Zenned

Join Date:
Mar 2008
Location:
Cape Town & London (depends on the season)
Posts:
2,957
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

Are your customers general consumers, or are they trade customers.

If they are only general consumers, then you need not display the vat anywhere - not even on the invoice. If your webshop is splitting out the vat, then you can adjust settings to prevent this.

It is also not clear how one ATTRIBUTE for a product can be vat-free, and others be vat-inclusive.

Please provide an example of one of your products where one attribute carries VAT and another attribute does not carry VAT.

(Either way... there is no mechanism in standard zencart to treat attributes from a tax or tax-free point-of-view.)

14 Jan 2012, 12:47 PM
#7
jamint avatar

jamint

New Zenner

Join Date:
Mar 2011
Posts:
59
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

Our customers are the general public, so displaying VAT is not essential. Although if we (personally) buy something from a general website and want to put it through our business book then we often want VAT to be displayed. Also, there are often professionals in the sport we are supplying goods for who may want to put things through their books. However, i accept your point, maybe we could turn VAT off and just supply invoices with VAT if they are requested.

An example would be a pair of shoes.

Sizes 3-5 are ex-vat
Sizes 6-11 are inc-vat

All one product (and sometimes the same retail price) but some have vat and some do not.

Please let me know your thoughts.

14 Jan 2012, 1:08 PM
#8
fairestcape avatar

fairestcape

Totally Zenned

Join Date:
Mar 2008
Location:
Cape Town & London (depends on the season)
Posts:
2,957
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

Assuming that your store is set up for UK vat - which will include VAT at 20% set as a tax rate and VAT EXCLUSIVE at 0% set up as a tax rate (both with the same PRIORITY number), and that these are applied to UK as a ZONE... AND that the store's settings are configured to show tax in the order confirmation and the invoice...

... the best way (only way) to show different sizes of shoes is to split the shoes into two products - one for chldren (to whom the vat-free option applies) and the other for adults (to who the vat option applies).

When you add/edit5 a product, you will select the VAT rate for the adult shoes and the VAT FREE rate for the children's shoes.

The user manual that can be purchased off this site (link above) provides good information on setting up the taxes and zones.

14 Jan 2012, 1:56 PM
#9
jamint avatar

jamint

New Zenner

Join Date:
Mar 2011
Posts:
59
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

Thank you fairestcape.

That is what we have been doing so far. But having them as two seperate products is awkward when it comes to women with small feet who will have to follow a link and to various other products this applies to. Especially when a lot of our competitors websites do not have to do this.

I think i may look into seeing whether a developer can custom make this.

Also, to stop Tax displaying on checkout and invoice. Is it Customers > Order Total and removing Tax? Or does this do something more severe than just remove it from these 2 places. Will it still calculate a total in vat?

15 Jan 2012, 5:22 PM
#10
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

JaminT:

Thank you fairestcape.

That is what we have been doing so far. But having them as two seperate products is awkward when it comes to women with small feet who will have to follow a link and to various other products this applies to. Especially when a lot of our competitors websites do not have to do this.

VAT law in the UK does not apply to the SIZE of the shoes. It applies to whether they are being sold to be worn by ADULTS or CHILDREN.

If an ADULT is purchasing a size 3 shoe to wear themselves, in terms of the law, that adult should pay VAT. However, if an adult purchases a shoe identified by the retailer as a CHILDREN'S shoe, then they are likely to get away with it.

JaminT:

I think i may look into seeing whether a developer can custom make this.

Also, to stop Tax displaying on checkout and invoice. Is it Customers > Order Total and removing Tax? Or does this do something more severe than just remove it from these 2 places. Will it still calculate a total in vat?

NO... don't tamper with OT.

I suggest you purchase the MANAL and go through all the areas relating to setting up taxes.

15 Jan 2012, 7:12 PM
#11
jamint avatar

jamint

New Zenner

Join Date:
Mar 2011
Posts:
59
Plugin Contributions:
0

Re: VAT added depending on Attributes selected

Thank you for your advice schoolboy.

Got the manual. Have taxes set up and all is working fine.

We understand the laws on vat, many of our suppliers supply shoes or, for instance, horse riding hats that the smaller sizes are ex-vat as they claim they are "children" sizes. But a lot of these are purchased by adults.

My question only really relates to whether attributes can handle varying vat rates. And from researching and advice here i do not think there is currently a mod for it (i have only been able to find an osCommerce mod).

So we are left with 3 choices....
a) Set up 2 seperate products for the same item. 1 with vat and 1 without. Not ideal as it may mean customers give up if their size is not available when looking at the first product and buy elsewhere.
b) Remove VAT from the OT, so instead it just shows totals. Then if a customer needs a VAT receipt they can request it and we will supply a shop receipt (the one we use for out accounts). Not ideal either as the customer might not return if it is a hassle.
c) See if a developer can develop a module. Most likely what we will do if it is not mega money and is possible.

Unless anyone reading this has another idea? :lookaroun