VAT-mod for European companies

Hi again,

I feel like a fool for this but I've solved my problem, and maybe some other people may have that prob, so I post the solution

One should put the content of the folder /includes/templates/YOUR_TEMPLATE/templates in the appropriate folder on the server and not just drag and drop the zip-file :sleepy:

yes, I'm a Zen Cart Newbie ;)

Thanks for the update ... :smile:

And don't feel too bad ... you couldn't begin to imagine some of the things that others have done ... but were afraid to admit that they did it ... :lamo:

Beez:

We will work to get all prices displayed without VAT if a costumer is logged in with valid VAT number. The first step is to fix the prices in checkout shipping. Then we will move on to fix shopping cart and the rest of the shop. This will take some time. If you can contribute, please drop us a PM or post in the thread.Hi Beez,
I think I know an easy way to show at least all product prices without VAT. As far as I am aware only shipping will still include VAT then. It only takes a one or two simple edits. Not sure if it works how you want it to work.

Let me know if you're still looking for this.

I'm trying again and again, but I can't find the way to show the VAT in the order email. Any suggestion?

Hi guys, great mod, have installed mod and checked through everything thrice, but don't seem to have access to it in Admin->Configuration->VAT-mod-> Don't see VAT-mod??

Beez:

Sorry for the delayed answer.
You need to enable the mod to make it check the VAT-number with the server. You do that in the Admin->Configuration->VAT-mod->Check the VAT number->True.

All fields have displayed in Admin->Customer and Create Accout but no access in Admin dropdown?

Latest version of mod and cart and have set up Zones and Tax.

Any help would be appreciated. Thanks

Silly me, it was the permissions in Admin Profiles.

Great Mod, thanks

I can´t see Admin->Configuration->VAT-mod and tried to change my file permissions like beatnik but without any success. How can I make it viewable?

Ok, I found the problem when I switch the backend to English then it works. During testing the function I noticed a big Problem with it. If a private person from a EU country without a EU-Vat number buys sth it also deductes the tax!:shocking:

Doesn´t anyone else have this problem too?

arve:

If a private person from a EU country without a EU-Vat number buys sth it also deductes the tax!
We're unable to reproduce your problem. It works fine for us. Are you sure you have tax set up correctly? See the install.txt for instructions. Please let us know how it turns out.

Does the latest version work on zen 1.3.0 as well?

Unfortunately I don't think so. 1.3.5 are earliest I think it will work on, without too much work... Good luck and thanx for your intrest. Please let us know how it turns out.

Revenant:

Does the latest version work on zen 1.3.0 as well?If you're still running a store on one of the 1.3.0.x releases, I'd recommend upgrading anyway. Unless you've heavily modded your cart, the upgrade's not to difficult and there were a large number of security fixes added in 1.3.5.

Have you solved the problem to show the customer vat number in email order?
I'm trying many times, with no success: I don't know where I add the code.
Thanks

vike:

oh, dang. there it was.. didnt see it as i checked there when you asked.. hmeh..

yet: the table 'configuration_group' should contain the following column/cells acqoarding to my database:
configuration_group_id ('27')
configuration_group_title ('VAT-Mod')
configuration_group_description ('VAT-Mod options')
sort_order ('27')
visible ('TRUE')
what do you mean this extra '1' would refer to or describe and what column title is it supposed to belong to? i now know the sql-file (VAT-mod_English.sql) is correct.. :lookaroun
adding a '1' may rather create more errors..

The 1 which I inserted to the SQL-Patch is for the language. My DB the structure is:

             [     configuration\_group\_id](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60configuration_group_id%60+ASC)                           [     language\_id](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60language_id%60+ASC)                           [     configuration\_group\_title](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60configuration_group_title%60+ASC)                           [     configuration\_group\_description](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60configuration_group_description%60+ASC)                           [     sort\_order](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60sort_order%60+ASC)                           [     visible](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60visible%60+ASC)

So cfg-id is 23, language-id is 1 and then title as you defined it.

Whether you choose 1 for english, 43 for austrian (zen-cart.at which I use) or maybe 49 instead of 1 for a german version is up to you.

vike:

oh, dang. there it was.. didnt see it as i checked there when you asked.. hmeh..

yet: the table 'configuration_group' should contain the following column/cells acqoarding to my database:
configuration_group_id ('27')
configuration_group_title ('VAT-Mod')
configuration_group_description ('VAT-Mod options')
sort_order ('27')
visible ('TRUE')
what do you mean this extra '1' would refer to or describe and what column title is it supposed to belong to? i now know the sql-file (VAT-mod_English.sql) is correct.. :lookaroun
adding a '1' may rather create more errors..

The 1 which I inserted is for the language. My DB the structure is:

             [     configuration\_group\_id](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60configuration_group_id%60+ASC)                           [     language\_id](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60language_id%60+ASC)                           [     configuration\_group\_title](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60configuration_group_title%60+ASC)                           [     configuration\_group\_description](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60configuration_group_description%60+ASC)                           [     sort\_order](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60sort_order%60+ASC)                           [     visible](http://192.22.76.25/phpmyadmin/sql.php?lang=de-utf-8&server=1&collation_connection=utf8_general_ci&db=zentest&table=configuration_group&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60configuration_group%60++ORDER+BY+%60visible%60+ASC)

So cfg-id is 27, language-id is 1 and then title as you defined it.
So the statement needs to be:

INSERT INTO configuration_group VALUES ('27', '1', 'VAT-Mod', 'VAT-Mod options', '27', '1');

Whether you choose 1 for english, 43 for austrian (zen-cart.at which I use) or maybe 49 instead of 1 for a german version is up to you.

OK, after some more testing:

So cfg-id is 27, language-id is 1 and then title as you defined it.
So the statement needs to be:

INSERT INTO configuration_group VALUES ('27', '1', 'VAT-Mod', 'VAT-Mod options', '27', '1');

Whether you choose 1 for english, 43 for austrian (zen-cart.at which I use) or maybe 49 instead of 1 for a german version is up to you.

OK, that was my theory.....
Without the additional 1 or whatever, the following error is shown when I try to run the command:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO configuration_group VALUES ('27', 'VAT-Mod', 'VAT-Mod options', '27', '1');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

After installing a fresh 1.37 (german version) I applied the patch, copied the files, but the VAT-field still isn't displayed when registering. Neither in english, nor in german.

So I checked the database again. Found all the entries from the SQL-patch, so this should be OK.

Checking entries at client details config -page: no options available.
The client's record and the order record contain VAT as expected....

Any ideas???

I installed the Mod and done the the repairs at the database but I cannot still see the vat n. in the emails and the invoices. Can some one help please.
franco cauter

Hi Beez

Just did an install of v1.2.5 on a fresh zc1.3.7 and would like to suggest the following:

File: VAT-mod_English.sql
Line: 5
Typo in the label 'Mininum caracts for VAT number' > characters

Change:
includes\languages\extra_definitions\vatmod.php
To:
includes\languages\english\extra_definitions\vatmod.php

Otherwise the defines are not found, this will also create a more 'out of the box' experience when installing on a fresh zencart.
Maybe point out in install.txt that this file needs to go in every installed language (and be translated of course)

As in point 2, I see the the same being uploaded to the admin directory.
(admin\includes\languages\extra_definitions\vatmod.php)
Shoudn't be there. :no:

Hope I'm helping out, and keep up the great work!

On a more personal note, you need to fix the links in your signature :bangin:

:oops:
I jyst installed the VAT mod module and my entyre store came to a grinding halt. How do i un install this module - your install file does not specify..

the strore runs but checkout does not function. The order processing in admin does nor work eithedr..

ver:
** Zen Cart 1.3.7**

 ** Database Patch Level:  1.3.7**

Please help!!:cry::cry::cry:

:clap:mmm... i fiddled a bit (db extentions) and managed fo fix my own fault - sorry about the false alarm :blush: