[solved] Tax Configuration Issue

[Porpoise]

Have been hunting all through the fora for an answer to this but the only actual solution I found was for a previous version of Prestashop - which doesn't work in the same way.

 

The problem is - we need to be able to set the tax based on delivery destination NOT the product.

 

ALL the products (including shipping) will carry the same rate of tax only governed by the destination.

 

i.e.

 

If the product is sold locally, the tax rate is 5% GST.

If sold to the UK, the tax rate is 20% VAT

 

Currently, there is no mechanism to collect the tax for any other jurisdiction, so for any other destination there is NO TAX.

 

Unfortunately, there appears to be no way to do this in Prestashop 1.5.2.0 (whereas there WAS a way to do it in a previous version - I don't know which version but there is a "how-to" video here:

http://www.youtube.com/watch?v=Jr2U9ci0XNU

)

 

This is a major omission of v1.5.2.0 in my view as it is obvious that different jurisdictions will have different tax rates.

 

If I am wrong and there is actually a mechanism or a fix to enable setting tax rates according to destination - not product - could someone please enlighten me, as this is an urgent requirement for our situation. The tax needs to be added as the last item (before the TOTAL amount) in the shopping cart before passing over to the payment process.

Edited August 13, 2013 by vekia (see edit history)

[Porpoise]

Have been hunting all through the fora for an answer to this but the only actual solution I found was for a previous version of Prestashop - which doesn't work in the same way.

 

The problem is - we need to be able to set the tax based on delivery destination NOT the product.

 

ALL the products (including shipping) will carry the same rate of tax only governed by the destination.

 

i.e.

 

If the product is sold locally, the tax rate is 5% GST.

If sold to the UK, the tax rate is 20% VAT

 

Currently, there is no mechanism to collect the tax for any other jurisdiction, so for any other destination there is NO TAX.

 

Unfortunately, there appears to be no way to do this in Prestashop 1.5.2.0 (whereas there WAS a way to do it in a previous version - I don't know which version but there is a "how-to" video here:

http://www.youtube.com/watch?v=Jr2U9ci0XNU

)

 

This is a major omission of v1.5.2.0 in my view as it is obvious that different jurisdictions will have different tax rates.

 

If I am wrong and there is actually a mechanism or a fix to enable setting tax rates according to destination - not product - could someone please enlighten me, as this is an urgent requirement for our situation. The tax needs to be added as the last item (before the TOTAL amount) in the shopping cart before passing over to the payment process.

 

As a start to a hacked solution, I have added a new field to the country table; "country_tax_rate_id" and am currently hunting through the files trying to figure out where to inject some code (preferably without hacking the core files), so if anyone can help there (in the absence of a proper built-in function), I'd really appreciate the help.

[mytwocentimes]

Have been hunting all through the fora for an answer to this but the only actual solution I found was for a previous version of Prestashop - which doesn't work in the same way.

 

The problem is - we need to be able to set the tax based on delivery destination NOT the product.

 

ALL the products (including shipping) will carry the same rate of tax only governed by the destination.

 

i.e.

 

If the product is sold locally, the tax rate is 5% GST.

If sold to the UK, the tax rate is 20% VAT

 

Currently, there is no mechanism to collect the tax for any other jurisdiction, so for any other destination there is NO TAX.

 

Unfortunately, there appears to be no way to do this in Prestashop 1.5.2.0 (whereas there WAS a way to do it in a previous version - I don't know which version but there is a "how-to" video here:

 

This is a major omission of v1.5.2.0 in my view as it is obvious that different jurisdictions will have different tax rates.

 

If I am wrong and there is actually a mechanism or a fix to enable setting tax rates according to destination - not product - could someone please enlighten me, as this is an urgent requirement for our situation. The tax needs to be added as the last item (before the TOTAL amount) in the shopping cart before passing over to the payment process.

 

@porpoise - I am new to this whole prestashop thing, but LOCALIZATION >> TAXES >> enable tax and set the "based on" drop-down to "Destination"

 

hope this helps

 

EDIT: sorry - I reread your post - and what I wrote makes no sense - apologies and good luck finding a solution ---> though I wonder how you go about collecting VAT from clients beyond your company's country borders ? seems odd

Edited December 11, 2012 by mytwocentimes (see edit history)

[Porpoise]

@porpoise - I am new to this whole prestashop thing, but LOCALIZATION >> TAXES >> enable tax and set the "based on" drop-down to "Destination"

 

hope this helps

 

Hi,

Thanks for your response.

I already did that bit but it doesn't actually have any affect anywhere, as there is nowhere to input the relevant tax-rates linked to the relevant country.

[mohsart]

You need to add tax rules for each country where the tax should be applied, i.e. Localization, Tax rules, edit e.g. 20% VAT, Add new tax rule, Select UK

 

/Mats

[Porpoise]

You need to add tax rules for each country where the tax should be applied, i.e. Localization, Tax rules, edit e.g. 20% VAT, Add new tax rule, Select UK

 

/Mats

 

Hi Mats,

 

Thanks for the pointer.

 

Hit me! I must be going blind! I KNEW I must be missing something! I missed that little button in the top right-hand corner!

 

Might be helpful if it was made a bit more obvious!

 

However, I still have a slight problem - I have done the ROW No Tax as All countries, Jersey GST as Jersey only and UK VAT as UK only (assuming that by doing all the other countries first, the Jersey and UK entries would subsequently over-ride those 2 values) but it seems that it does not - as the UK still shows 0 tax in the part of the list I can see. However, I can't see what it's done with Jersey in the ROW list, as there doesn't seem to be any way to see past the first page of countries in the list.

 

Steve

Edited December 11, 2012 by Porpoise (see edit history)

[El Patron]

rather than add taxes manually isn't it easier and more accurate to import the localizaton pack for each country you offer in your front office registration?

 

back office-->localization-->localization

 

http://screencast.com/t/2IpTiG6uP

[Porpoise]

Hi Mats,

 

Thanks for the pointer.

 

Hit me! I must be going blind! I KNEW I must be missing something! I missed that little button in the top right-hand corner!

 

Might be helpful if it was made a bit more obvious!

 

However, I still have a slight problem - I have done the ROW No Tax as All countries, Jersey GST as Jersey only and UK VAT as UK only (assuming that by doing all the other countries first, the Jersey and UK entries would subsequently over-ride those 2 values) but it seems that it does not - as the UK still shows 0 tax in the part of the list I can see. However, I can't see what it's done with Jersey in the ROW list, as there doesn't seem to be any way to see past the first page of countries in the list.

 

Steve

 

Work-round: Fixed them directly in the DB via phpMyAdmin

[Porpoise]

rather than add taxes manually isn't it easier and more accurate to import the localizaton pack for each country you offer in your front office registration?

 

back office-->localization-->localization

 

http://screencast.com/t/2IpTiG6uP

 

Not really, as we have no way of dealing with the taxes for any other country and we only accept payment in GBP and we only sell from 1 location. So any other country's tax/currency etc., configuration is irrelevant to us. We do ship all over the world, however - so it would take forever to install the localisation pack for every country only to set their tax as 0%

 

Thanks for the response though.

Steve

[mohsart]

Agreed, as for me, I charge 25% VAT to all EU countries, local tax rules for e.g. Germany is irrelevant.

Btw, I believe that 0% tax is default, at least I have no special rule for 0% tax and it seems to work OK

 

/Mats

[Porpoise]

Agreed, as for me, I charge 25% VAT to all EU countries, local tax rules for e.g. Germany is irrelevant.

Btw, I believe that 0% tax is default, at least I have no special rule for 0% tax and it seems to work OK

 

/Mats

 

Unfortunately, we are in a unique position because we have 3 tax options to deal with the whole planet. Anyhow, I have now entered the country tax rates as suggested but it still isn't working correctly. It calculates the correct tax for the shipping but it is still using the product tax for the products instead of using the destination tax for the whole cart!?!

[Porpoise]

There is another tax issue we need to solve (once it's actually calculating the tax correctly) - we need to add code to separate the tax according to the destination country, as we have to pay the collected tax to different jurisdictions! The easiest way to add it to the DB would seem to be to just add a <country_id> field to the <ps_order_detail_tax> table - then it's a case of finding where to inject the necessary code to insert the relevant country code into the table when the order is placed.

 

Also, I will then need to code the necessary part in admin for extracting the details for the relevant tax returns. (2 jurisdictions) [as I have had to do with our existing osCommerce application. However, the osCommerce site structure is far simpler that the Presta structure, so any help/pointers would be gratefully received vis-a-vis where to inject code].

 

I'm guessing it would be a far better idea to use the override system (however one does that) rather than hard-coding into existing core files!

[Porpoise]

@porpoise - I am new to this whole prestashop thing, but LOCALIZATION >> TAXES >> enable tax and set the "based on" drop-down to "Destination"

 

hope this helps

 

EDIT: sorry - I reread your post - and what I wrote makes no sense - apologies and good luck finding a solution ---> though I wonder how you go about collecting VAT from clients beyond your company's country borders ? seems odd

 

There is a special arrangement with the UK tax authority, whereby we pay the VAT to the local post office and they pay it to the UK tax office. That way, our UK customers don't get shafted with another £9 fee by Royal Mail for collecting the VAT from the recipient before they can receive their goods.

[Porpoise]

Still doesn't seem to be any solution to this issue...

[El Patron]

I was helping a customer of one of our modules (geo pricing) who expected say Germany taxes to shop up when testing from a German IP address. They had in fact not set up the tax rules, which I am far from an expert at. I found this thread and then a little more digging to find the doc on this and thought I would post so it might help others.

 

http://doc.prestashop.com/display/PS15/Understanding+Local+Settings#UnderstandingLocalSettings-Taxes

[Pronesis]

Hi Porpoise, i'm in your same situation.

 

Do you have found a solution ? This is a big issue

[Pronesis]

I've seen the problem is caused by the European VAT Module, if i disable this module all is ok... i 'don't understand the reason of this function in modules/vatnumber/VATNumberTaxManager.php:

 

public function getTaxCalculator()

{

// If the address matches the european vat number criterias no taxes are applied

$tax = new Tax();

$tax->rate = 0;

 

return new TaxCalculator(array($tax));

}

[JerseyG]

Hi Steve (Porpoise)

 

I presume that as you are now up and running you have found an answer to this problem. However I thought I would let you know how I solved it.

 

I created a tax rule called “Tax Collector” I then added United Kingdom tax at 20% to this rule. I also added Jersey GST at 5% to this rule.

 

All products have “Tax Collector” set as the Tax Rule on the prices tag.

 

Dependent on customers’ location either 20%, 5% or no tax is charged.

 

For clarification I have removed the 5% GST for Jersey at the moment as I do not pass on the Tax but can re enable it by adding it back to the “Tax Collector” rule.

 

G

[vekia]

...

 

hello

 

thank you for this nice know how, i really appreciate it, im convinced that it will be really helpful for other merchants.

I just want to ask something, is there any chance to know, for what prestashop version you created these taxes?

[JerseyG]

Hello Vekia

 

Thank you for your comment.

Version is 1.5.2.0

 

G

[Porpoise]

Hi Steve (Porpoise)

 

I presume that as you are now up and running you have found an answer to this problem. However I thought I would let you know how I solved it.

 

I created a tax rule called “Tax Collector” I then added United Kingdom tax at 20% to this rule. I also added Jersey GST at 5% to this rule.

 

All products have “Tax Collector” set as the Tax Rule on the prices tag.

 

Dependent on customers’ location either 20%, 5% or no tax is charged.

 

For clarification I have removed the 5% GST for Jersey at the moment as I do not pass on the Tax but can re enable it by adding it back to the “Tax Collector” rule.

 

G

 

Hi JerseyG,

 

Yes, what confused me initially was the terminology used by the developers (English is not their first language) but once I figured it out, it was relatively straight-forward. I just called it "Sales Tax" but otherwise I think it's the same solution as yours.

 

Steve.

[JerseyG]

Hello Vekia

 

I think you can mark this one as solved.

 

Thanks In advance

 

G

[vekia]

thanks for all entries here,

topic marked as solved, exactly as you suggested

regards

[LeGastronome]

Hi,

 

What a headache... !!!

 

I have also notice that in TaxRule you can't display all country in the table, and you don't have possibility to navigate to other pages

[casstete]

Hi Mats,

 

Thanks for the pointer.

 

Hit me! I must be going blind! I KNEW I must be missing something! I missed that little button in the top right-hand corner!

 

Might be helpful if it was made a bit more obvious!

 

However, I still have a slight problem - I have done the ROW No Tax as All countries, Jersey GST as Jersey only and UK VAT as UK only (assuming that by doing all the other countries first, the Jersey and UK entries would subsequently over-ride those 2 values) but it seems that it does not - as the UK still shows 0 tax in the part of the list I can see. However, I can't see what it's done with Jersey in the ROW list, as there doesn't seem to be any way to see past the first page of countries in the list.

 

Steve

 

you didn't miss it , I just spent 2 hours going through all the tax and tax rules and checking again & again until I also found the F****ING add rule button .

 

Talk about making things complicated ( invisible ) and still you have to then configure country by country ...

 

Not like the French who make the software are in """" EU """ where everyone pays the tax from where it was bought .

 

I been working in IT since 2000 and it's just getting worse ! I wanna see the person who sets up Prestashop in "hours"

 

Every second step I make i haveone issue or another without even wanting to customise !

[casstete]

thanks for all entries here,

topic marked as solved, exactly as you suggested

regards

make life easy for people and simply add a EU option to the countries , as when selling in the EU local VAT is applied , so I can make a rule with one selection instead of 20+ .

 

thx