VAT-mod for European companies

[BStBln]

The options are None, Null, As Defined and Current Timestamp

Try "As defined" and make sure the textbox below is empty (also no spaces etc.)

This is for new accounts, but you also have to update the existing ones, do you know how?

[globalmemory]

Try "As defined" and make sure the textbox below is empty (also no spaces etc.)

This is for new accounts, but you also have to update the existing ones, do you know how?

I should be able to work it out. Thanks for your help.

[globalmemory]

Try "As defined" and make sure the textbox below is empty (also no spaces etc.)

This is for new accounts, but you also have to update the existing ones, do you know how?

Actually, on second thoughts i will need help on the existing customer accounts. Do i just change the settings within the address book, and if so, to what? Also, am i supposed to uncheck the null box as shown in the previous attached image? And just to be sure, this fix will enable VAT to be added to EU customers outside the UK when paying via Paypal Express?

[BStBln]

Actually, on second thoughts i will need help on the existing customer accounts. Do i just change the settings within the address book, and if so, to what? Also, am i supposed to uncheck the null box as shown in the previous attached image? And just to be sure, this fix will enable VAT to be added to EU customers outside the UK when paying via Paypal Express?

After fixing this, everything should work as expected.

The setting you already made ensures that for new customers, the field will be filled with an empty string instead of NULL, which was wrong and is not understood by the shop software.

Now you have to change all those existing records which have NULL in this field. You can either do it manually, record by record (not sure if there is some kind of bach mode), but I suggest you to do this simply by entering SQL code:

update address_book set entry_tva_intracom = '' where entry_tva_intracom is null 

Make sure you have the correct table name (maybe in your database, it is not "adress_book" but "zen_address_book" or something similar, look this up before and change the sql statement accordingly.

I haven't tested it, but I guess it should work. To be on the safe side, make a backup of your database before!!

Bernhard

[globalmemory]

After fixing this, everything should work as expected.

The setting you already made ensures that for new customers, the field will be filled with an empty string instead of NULL, which was wrong and is not understood by the shop software.

Now you have to change all those existing records which have NULL in this field. You can either do it manually, record by record (not sure if there is some kind of bach mode), but I suggest you to do this simply by entering SQL code:

update address_book set entry_tva_intracom = '' where entry_tva_intracom is null 

Make sure you have the correct table name (maybe in your database, it is not "adress_book" but "zen_address_book" or something similar, look this up before and change the sql statement accordingly.

I haven't tested it, but I guess it should work. To be on the safe side, make a backup of your database before!!

Bernhard

Thanks for all you help.

[FEQ]

Hi,

I am running zencart 1.39h and have applied the 1.39h VAT mod for european companies. In previous installations this worked perfectly.

For some reason I am now finding that taxes for purchases in the Store country (UK) calculate VAT correctly (UK VAT appears on the invoice), but purchases for European Companies without a VAT number have no VAT added. It seems as if the EU VAT zone is not being applied.

Any clues as to where to start debugging? entry_tva_intracom has been set to ''. I have the priorities of the Tax Rates set as 1 EU, 2 UK. Both rates use the "Taxable Goods" tax class. Our products are all electronic delivery, so set to free shipping.

Thanks. FEQ

[dimjoula]

VAT-Mod BETA UNOFFICIAL VERSION 2 for Zen Cart v. 1.3.9h
For Companies inside European Union

===========================
It is a version 2 patch for Zen Cart v. 1.3.9h.
I have edited 3 small bugs from my previous patch, and especially the one with the NULL entry in the address_book SQL database (see the last two pages on this thread for a solution). Hope it works.
===========================

Remake and compatibility with Zen Cart v. 1.3.9h
Special edition done by dimjoula.

IMPORTANT NOTE: this is not the official release from Beez & Vike.
It is a *BETA* version. I did a copy and paste from the previous codes (VAT-Mod 1.3.0 for Zen Cart v. 1.3.8a) and paste them to Zen Cart v. 1.3.9h files. It works for me with my own personal configuration, but you should take it with care. IT MAY NOT WORK WITH YOUR OWN CONFIGURATION out of the box. Perhaps you will need to edit some files. If it is the case, please share it here.

BACKUP - BACKUP first your files and database before updating your store with these files. It may be buggy. You must know how to restore it!!!

What's new:
- 3 small bugs have been edited compared to the previous release of this unofficial patch
- PARTIAL (90%) Compatibility with Zen Cart v. 1.3.9h (but should be OK in most regular situations; potential problem when the customer uses several different addresses located in different countries)
- french translation
- update of the VIES link to check the validity of the number (only for a compatibility with php 5.3)
- THIS FUNCTION INTRODUCED IN THE PREVIOUS MOD DOES NOT WORK ANYMORE: "Don't add tax on any prices in the store if customer is logged in with verified VAT-number and customers shipping address is not in the same country as the store." So, the file catalog/includes/functions/functions_taxes.php is not updated. Please, use the geniune file from 1.3.9h instead.

Download the file here: http://dl.free.fr/tQn26jxyb (Zip file, 150 KB)

[smprofx]

It seams that this module doesn't work anymore because the VIES EU site has suffered some modification and verification patch from the module must be updated to point to the new address.

Now I'm getting this error when creating a new account: "Server is unable to check your European Tax number: please, leave blank"

I'm using Zencart 1.38a and module worked fine until EU VIES site updated their page.

Can someone with some experience update this module? (I'm don't have coding knowledge).

Thank you!

[dimjoula]

It seams that this module doesn't work anymore because the VIES EU site has suffered some modification and verification patch from the module must be updated to point to the new address.

No everything is fine. The VIES website is still OK, it has not changed. It is working for me with ZenCart 1.3.9h and the latest mod I offer for download.
So your problem is coming from somewhere else?

[oberheimer]

VAT-Mod BETA UNOFFICIAL VERSION 2 for Zen Cart v. 1.3.9h
For Companies inside European Union

===========================
It is a version 2 patch for Zen Cart v. 1.3.9h.
I have edited 3 small bugs from my previous patch, and especially the one with the NULL entry in the address_book SQL database (see the last two pages on this thread for a solution). Hope it works.
===========================

Remake and compatibility with Zen Cart v. 1.3.9h
Special edition done by dimjoula.

IMPORTANT NOTE: this is not the official release from Beez & Vike.
It is a *BETA* version. I did a copy and paste from the previous codes (VAT-Mod 1.3.0 for Zen Cart v. 1.3.8a) and paste them to Zen Cart v. 1.3.9h files. It works for me with my own personal configuration, but you should take it with care. IT MAY NOT WORK WITH YOUR OWN CONFIGURATION out of the box. Perhaps you will need to edit some files. If it is the case, please share it here.

BACKUP - BACKUP first your files and database before updating your store with these files. It may be buggy. You must know how to restore it!!!

What's new:
- 3 small bugs have been edited compared to the previous release of this unofficial patch
- PARTIAL (90%) Compatibility with Zen Cart v. 1.3.9h (but should be OK in most regular situations; potential problem when the customer uses several different addresses located in different countries)
- french translation
- update of the VIES link to check the validity of the number (only for a compatibility with php 5.3)
- THIS FUNCTION INTRODUCED IN THE PREVIOUS MOD DOES NOT WORK ANYMORE: "Don't add tax on any prices in the store if customer is logged in with verified VAT-number and customers shipping address is not in the same country as the store." So, the file catalog/includes/functions/functions_taxes.php is not updated. Please, use the geniune file from 1.3.9h instead.

Download the file here: http://dl.free.fr/tQn26jxyb (Zip file, 150 KB)

Have any more people tried this?
i'm working on a uppdate for our site so need to be sure
And can you just overwrite if it's stock zen cart 1.3.9h