VAT-mod for European companies

[Beez]

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.

[kuroi]

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.

[100asa]

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

[juergen852]

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..
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 language_id configuration_group_title configuration_group_description sort_order visible

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.

[juergen852]

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..
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 language_id configuration_group_title configuration_group_description sort_order visible

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.

[juergen852]

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

[francocauter]

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

[ALHO]

Hi Beez

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

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

2.
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)

3.
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.


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

[leftless]

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!!

[leftless]

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