globalmemory:

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?

BStBln:

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.

BStBln:

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?:unsure:

globalmemory:

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?:unsure:

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

BStBln:

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. :bigups:

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

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) :beta:

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!

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.

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?

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) :beta:

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

Zencart (1.39h) noob here.
Problems I encounter installing Vat-mod for 1.39h beta beta,

I had interference with

• stock by attributes 1-4-13
• captcha antirobot registration 1-3

I also got a blank page on my admin side

I did a merge between
\admin\orders.php
modified by sba and vat-mod, i used winmerge to do that merge... great tool that winmerge thing..

I did the same thing with
\includes\modules\create_account.php modified by captcha
\admin\includes\functions\general.php modified by sba

Blank screen on admin
http://www.zen-cart.com/forum/showthread.php?t=35911&page=112

I took out zen_draw_admin_box function
in
\admin\includes\functions\general.php

and that fixed the admin blank

Now captcha was working but did not appears.. so no signups
basically captcha modifies
\includes\templates\template_default\templates\tpl_modules_create_account.php

but this file is overriden by
\includes\templates\temperso1\templates\tpl_modules_create_account.php created by VAT-Mod

once you find this out, you can merge the 2 files in
\includes\templates\temperso1\templates\tpl_modules_create_account.php

... finally I could go for taxes configuration...
My company is registered in France so I used
GB 879456458 to check it... working great...

*** To follow up on all the file changes.... ***

I used a little trick in the MS-Dos prompt,
dir /s /b>filelist.txt
this create a text files with all files, folders and subs..
I did this for all the files of every addon i used... watch out for your new admin folder name and YOUR_TEMPLATE folder name...

Note: before installing the addon, make a back up for once, but also a small back up of only the files that are modified by that add on... that will save you time to reload the previous version...

Then I put all those strings in excel, make 2 pivot table, one on the file complete path+name string, one on the filename alone... for the overriding thing.

and look for files modified more than once...

I suggest this to be done as soon as adding modules to ZC...

NOW my question... is there a soft that can keep trace of all changes, modified files etc... instead of me doing a excel and pivot? something that could back up only modified files...

That would be so helpful.

Thanks for the great addon VAT-mod and the Beta version on the post for 1.39h!

If you are sure that the add-on is compatible with the last Zen-Cart version, blank pages are often (almost always) caused by a bad copy and paste of the code.
You have to find in which file you introduced this little bug.
Sorry for not being more helpful.

Hi all,

Has there been any update on getting this module working for 1.3.9h ?

It was working fine for 1.3.8 - but seems not to work any more.

An update would be most appreciated

Thanks

Works fine in 1.3.9h here Jamie...

Thanks eentje,

We have been using the Beta for 139 but applied a number of fixes, mainly down to the clients needs (heavily modified site).

When we get a chance we'll feed back.

Take Care

Is anyone using this mod on zen cart 1..5.0?

The 1.3.9 beta is still buggy... although it works... eventually...

1.5.0 is still lightyears away... (afaik)

Thanks eentje

I wonder what people are doing who need it in zen 1.5.0?

Hi All,

Are there any secrets to using the VAT mod in 1.39? I have it working PROVIDED the user has entered their VAT number. For some reason it seems to ignore the module if there is no VAT number against the client (v. annoying).

I have to say that this is essential for my shop, so if 1.5 is not supporting this, I am going to have to look for another cart. Any ideas or suggestions? Zencart has done an excellent job so far, but the VAT module keeps the tax men at bay, and with out it I have been caught out of pocket a few times.

Thank you

I'd very interested to know if anyone has looked to see how much work is involved in using VAT-mod in 1.5.0. Will it just be a case of diffing and cut n pasting, or is 1.5.0 too radically different?