VAT-mod for European companies

Great! Thanx for the update. Good luck with your store.

Hi, I tried to install VAT-mod_135.zip on Zen 1.37.

After fixing an error in SQL: Statement , '1' was missing at ('27', '1', 'VAT-Mod'.....) so i corrected it to:
INSERT INTO configuration_group VALUES ('27', '1', 'VAT-Mod', 'VAT-Mod options', '27', '1');

The VAT Mod was visible in the admin section, but nothing was displayed at the adress sections. This would not really be a problem, but /index.php?main_page=checkout_shipping didn't work anymore, so there was only an empty page when trying to check out.

Any help apreciated !!! :laugh:

Hi to all members,

for first, tnx very much for this useful MOD. You are great!!!

I've tried to install this mod in my zencart 1.37 but I have some problems and I think this mod works 60% on my website.

First problem: when I try to make new registration, no script give me the error if I leave blank the field VAT or the VAT number is wrong. Is that true?

Can I have for someone an address of their website for test, like customer, the script?

I don't understood very well how the script check, via server EU, if the VAT is correct or no.

Thank you very much for all the answers

csfound:

Hi to all members,

for first, tnx very much for this useful MOD. You are great!!!

I've tried to install this mod in my zencart 1.37 but I have some problems and I think this mod works 60% on my website.

First problem: when I try to make new registration, no script give me the error if I leave blank the field VAT or the VAT number is wrong. Is that true?

Can I have for someone an address of their website for test, like customer, the script?

I don't understood very well how the script check, via server EU, if the VAT is correct or no.

Thank you very much for all the answers

Any suggestion?

juergen852:

After fixing an error in SQL: Statement , '1' was missing at ('27', '1', 'VAT-Mod'.....) so i corrected it to:
INSERT INTO configuration_group VALUES ('27', '1', 'VAT-Mod', 'VAT-Mod options', '27', '1');
sorry but will you please give us a file and a row in where the error occurs? perhaps you can undo your change to retrieve the error-message..

juergen852:

The VAT Mod was visible in the admin section, but nothing was displayed at the adress sections. This would not really be a problem,
good this problem is no real problem for you :] but still - to check what it can be telling about itself and other bugs - what do you mean by 'adress sections'?

juergen852:

index.php?main_page=checkout_shipping didn't work anymore, so there was only an empty page when trying to check out.
can you see php-errors? (http://php.net/manual/en/ref.errorfunc.php#ini.display-errors, http://php.net/manual/en/function.error-reporting.php)
else try echoing at appropriate breakpoints..

juergen852:

Any help apreciated !!! :laugh:
i trust we will solve this soon :yes:

csfound:

when I try to make new registration, no script give me the error if I leave blank the field VAT or the VAT number is wrong. Is that true?
can you please give us the number to test at our implementations?

csfound:

Can I have for someone an address of their website for test, like customer, the script?
mine is still in 135 and in bad shape.. erhrm.

csfound:

I don't understood very well how the script check, via server EU, if the VAT is correct or no
i could perhaps explain it... ?

csfound:

tnx very much for this useful MOD. You are great!!!
thank _you. allways great to be apriciated and see were filling a need with our work. thank you all.

vike:

sorry but will you please give us a file and a row in where the error occurs? perhaps you can undo your change to retrieve the error-message..

good this problem is no real problem for you :] but still - to check what it can be telling about itself and other bugs - what do you mean by 'adress sections'?

can you see php-errors? (http://php.net/manual/en/ref.errorfunc.php#ini.display-errors, http://php.net/manual/en/function.error-reporting.php)
else try echoing at appropriate breakpoints..

i trust we will solve this soon :yes:
Hi,

Quote:
Originally Posted by juergen852 View Post
After fixing an error in SQL: Statement , '1' was missing at ('27', '1', 'VAT-Mod'.....) so i corrected it to:
INSERT INTO configuration_group VALUES ('27', '1', 'VAT-Mod', 'VAT-Mod options', '27', '1');
sorry but will you please give us a file and a row in where the error occurs? perhaps you can undo your change to retrieve the error-message..

---> This is in the first line of the SQL statements for the database.

Quote:
Originally Posted by juergen852 View Post
The VAT Mod was visible in the admin section, but nothing was displayed at the adress sections. This would not really be a problem,
good this problem is no real problem for you :] but still - to check what it can be telling about itself and other bugs - what do you mean by 'adress sections'?

----> Well, ok, it's a problem for me too. What I wanted to say:
In the user registration at the frontend side of the shop no VAT field was displayed. But I was still able to continue registration. That's why I said: "It's not a real problem" as the shop still worked fine to that point..... The real problem was, that, after buying something, the chekcout page was blank. So I had to remove the MOD and get back to my backup.

Quote:
Originally Posted by juergen852 View Post
index.php?main_page=checkout_shipping didn't work anymore, so there was only an empty page when trying to check out.
can you see php-errors? (http://php.net/manual/en/ref.errorfu...display-errors, http://php.net/manual/en/function.error-reporting.php)
else try echoing at appropriate breakpoints..

Well, too late for the logs, could not track it back...
Did you get it running on an 1.37?
Maybe it's easiest to set up a clean 1.37 and checkt it there...

Quote:
Originally Posted by juergen852 View Post
Any help apreciated !!!
i trust we will solve this soon

Thanks, Juergen

I've just finished to apply Beez mod to my store https://www.100asa.it, and it work very well. But I can't see the customer vat in admin: the filed is blank.

...and I can't see the VAT numer in the email order! It's very important for me to see the VAT number in the email order, because I entry the email order in another database.

csfound:

First problem: when I try to make new registration, no script give me the error if I leave blank the field VAT or the VAT number is wrong. Is that true?
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

The mod is not set to make VAT-number mandatory, don't really know why one would do that...

The script works that it checks the VAT-number against a EU server and checks that the VAT-number and country is the same. If not ok from the server or if VAT-number and country matches you get an error displayed, works both in the shop and in Admin.

100asa:

But I can't see the customer vat in admin: the filed is blank.
It works for me on Zen Cart v. 1.3.7... Are you sure you got all the code?

100asa:

...and I can't see the VAT numer in the email order!
That's because it isn't there ;-) I think the file that sends that email is /includes/classes/order.php or maybe admin/order.php. The corresponding language files are includes/languages/english/checkout_process.php and admin/includes/languages/english/orders.php. You could get the VAT-number from any of these files... We can do it for you if you make it worth our while :-)

juergen852:

juergen852:

After fixing an error in SQL: Statement , '1' was missing at ('27', '1', 'VAT-Mod'.....) so i corrected it to:
INSERT INTO configuration_group VALUES ('27', '1', 'VAT-Mod', 'VAT-Mod options', '27', '1');
This is in the first line of the SQL statements for the database.
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..

juergen852:

juergen852:

The VAT Mod was visible in the admin section, but nothing was displayed at the adress sections.
In the user registration at the frontend side of the shop no VAT field was displayed. But I was still able to continue registration.
..
Maybe it's easiest to set up a clean 1.37 and checkt it there...
yes, how thoroughly did you install this mod? i suggest you give it a retry - even more since your further follow fatal errors and because if you dont see this field and also no errors - with risk for repetition, i say there must be something wrong in the installationprocess..

juergen852:

juergen852:

index.php?main_page=checkout_shipping didn't work anymore, so there was only an empty page when trying to check out.
The real problem was, that, after buying something, the chekcout page was blank. So I had to remove the MOD and get back to my backup.
awh, tough..
juergen852:

too late for the logs, could not track it back...
ah. to bad.. but still, for the future:
vike:

can you recieve php-errors? (http://php.net/manual/en/ref.errorfu...display-errors, http://php.net/manual/en/function.error-reporting.php)
else try echoing at appropriate breakpoints.. :yes:

juergen852:

Did you get it running on an 1.37?
yes and we now have that confirmed by a new update to conform to zencart 137

beez will post more on thit soon.

thanks for your patience. good luck with your work. peace.

There is a new version of the VAT-mod on its way to the downloads section, the new version is 1.2.3 and is for Zen Cart 1.3.7.

We have made some fine tuning of the code and updated the distributed files to 1.3.7. We have changed some comments in the code to better distinguish the VAT-mod changes from more of general fixes we have found. A thread for these general fixes can be found here.

These general fixes are optional but recommended to make it more clearer for the user. The change in tpl_modules_address_book_details.php are however more essential...

The mod as it is now shows the prices without taxes (if logged in with valid VAT-number) on checkout_payment. We're working to get it to show price without taxes on checkout_shipping as well.

We also have plans to make the entire shop show prices without VAT if logged in with a valid VAT-number even when the shop is configured to show prices with tax. If you feel that you can contribute, please give a shout!

Beez:

That's because it isn't there ;-) I think the file that sends that email is /includes/classes/order.php ... It's right! I've try to add billing_tva_intracom on line 1101
$extra_info=email_collect_extra_info('','', $this->customer['firstname'] . ' ' . $this->customer['lastname'], $this->customer['email_address'], $this->customer['billing_tva_intracom'], $this->customer['telephone']);

with no success!

We can do it for you if you make it worth our while :-)
:yes:

Hi,

I will set up a clean 1.37 for new trial and keep you posted on the results.

Greets
Juergen

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

The mod is not set to make VAT-number mandatory, don't really know why one would do that...

The script works that it checks the VAT-number against a EU server and checks that the VAT-number and country is the same. If not ok from the server or if VAT-number and country matches you get an error displayed, works both in the shop and in Admin.

Thank you very much for your reply Beez!

So, like I suppose, I have some problems with this mod.
Can you help about these functions?
First, when we make new registration, javascript doesn't works because i don't received no error if i leave blank field or i entry wrong VAT number.

In Admin configuration I've set TRUE ......

csfound: You are right, there was an error in create_account.php (catalog/includes/modules/create_account.php). Could you please try the file I've attached here and see if it works. The mod doesn't returns an error if you leave the VAT field blank. It returns an error if you enter a faulty VAT number or if it doesn't match your country.

I've also added that you must enter a company name if you've entered a VAT number even if it's not required in the admin settings.

If this works we'll update the package in the download section, so please report back.

Good luck!

Beez:

csfound: You are right, there was an error in create_account.php (catalog/includes/modules/create_account.php). Could you please try the file I've attached here and see if it works. The mod doesn't returns an error if you leave the VAT field blank. It returns an error if you enter a faulty VAT number or if it doesn't match your country.

I've also added that you must enter a company name if you've entered a VAT number even if it's not required in the admin settings.

If this works we'll update the package in the download section, so please report back.

Good luck!

Great Beez, now works 100%, you can update in download section!!!

One question: it is possible to make mandatory the VAT field? Is it too difficult or is simple make this mod?

Tnx

New version (1.2.4) just uploaded.

Now the mod shows the prices without VAT in the checkout payment if logged in with valid VAT number. In the rest of the shop prices are displayed with VAT if chosen in admin.

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,

I'm having the same problem as juergen852 has

----> Well, ok, it's a problem for me too. What I wanted to say:
In the user registration at the frontend side of the shop no VAT field was displayed. But I was still able to continue registration.

on a quasi new 1.3.7 Installation.

in the admin section, there is a VAT field for each customer

Any clues?

Martin