VAT-mod for European companies

Having just installed this mod all seems to be working fine except with customers already registered who are within the EU but with no VAT number. Logging in these customers still shows products as VAT free. Adding new customers since the mod was added does not show this problem - it is only the old non-VAT customers.

I have searched high and low in this thread for any reference to this but can't find anything - other than a problem some time ago where this problem occurred the whole time - and I have applied the changes and that was fixed.

Any suggestions?

Actually I've sorted this. It's obviously to do with the addition of a null VAT field to the address table. Simply going into the Customer screen of any previous non-VAT customer and then leaving the screen by pressing 'update' solves the problem. Since we have very few non-VAT customers this is not a problem.

Cheers

Quote:

---

Originally Posted by TPHoare

Actually I've sorted this. It's obviously to do with the addition of a null VAT field to the address table. Simply going into the Customer screen of any previous non-VAT customer and then leaving the screen by pressing 'update' solves the problem. Since we have very few non-VAT customers this is not a problem.

---

Thank you thank you thank you :) You helped me solving another problem I wrote about here: If a customer uses Paypal Express to send us their address, they are not charged the VAT even if they should be charged - in contrast to users that create an account on the shop first and then go to Paypal.

The problem seems to be that the default value for the VAT field should be '', but not NULL.

Maybe changing this in the VAT-mod_English.sql file, e.g.

Code:

---

ALTER TABLE address_book ADD entry_tva_intracom VARCHAR(32) DEFAULT '' AFTER entry_company;

---

or changing this later manually, with

Code:

---

ALTER TABLE `address_book` CHANGE `entry_tva_intracom` `entry_tva_intracom` VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_german2_ci NULL default ''

---

solves the problem. Well, it did it for me - but I hope this doesn't produce any unexpected side-effects...

If you change the VAT-mod_English.sql file and apply it then to an old address table (which does not contain the VAT field), I assume that the fields are converted correctly, so you don't need to go to the admin area and iterate over the customer entries.

I'm not a professional php programmer, and I don't really know the ZEN system, but from the code in the checkout_new_address.php in the includes/modules folder of the VAT patch, I understand that the default value that is saved to the VAT-field in the database if the user does not enter a VAT on the account creation page is indeed '', not null.

But I haven't tested this extensively, it just seems to work e.g. if I let a french customer who is not a company buy in a German shop. Maybe someone who is more familiar with this could verify that my solution is clean...

Bernhard

Hi everyone (hopefully is someone still around)

Thanks for the great mode. I have only question (at this stage :smile: ) in regards to the shipping tax calculation which I think it is related to this mode.

First the facts:

vatmod_for_european_companies_1-3-0
Zen Cart v1.38

Shipping modules DHL|GLS|TPGPost


Now when I go to the checkout the shipping shows fine including the tax but when i go to the payment page the shipping tax disappears although vat shows fine.

So any idea why does this may happen will be great.

You can see it for yourself here http://www.carmo.nl/store

The site is live so if you need to login to check it out please use any first name but second name use "testing" so that I can delete it.

Thanks

Tassos

Hi all,
I installed this mod and all works fine except for the fact that if a customer doesn't insert any VAT information, NO TAX is anyway applied to the price.

If I'am a private EU customer I need to view all the prices with TAX.
I missed something in the configuration of the mod or it doesn't do what I need?

Reading the instructions of the mod I understand that if the customer doesn't insert any VAT he will see the prices with TAX...

Thanks in advance :hug:

Quote:

---

Originally Posted by Aletiger

Hi all,
I installed this mod and all works fine except for the fact that if a customer doesn't insert any VAT information, NO TAX is anyway applied to the price.

If I'am a private EU customer I need to view all the prices with TAX.
I missed something in the configuration of the mod or it doesn't do what I need?

Reading the instructions of the mod I understand that if the customer doesn't insert any VAT he will see the prices with TAX...

Thanks in advance :hug:

---

Maybe the solution I posted above will help you: http://www.zen-cart.com/forum/showpo...&postcount=253

Bernhard

Quote:

---

Originally Posted by BStBln

Maybe the solution I posted above will help you: http://www.zen-cart.com/forum/showpo...&postcount=253

Bernhard

---

Hi Bernhard, the problem is the same: if I register to the shop as an EU customer without VAT the prices are without TAX that is wrong.
A private EU customer must pay my products with TAX included.

Any suggestions? :no:

Quote:

---

Originally Posted by Aletiger

Hi Bernhard, the problem is the same: if I register to the shop as an EU customer without VAT the prices are without TAX that is wrong.
A private EU customer must pay my products with TAX included.

Any suggestions? :no:

---

So after you applied the modification to the table, did you then register a new account or did you only test with the old one? The accounts that are registered already stay the same in the table, the ALTER TABLE... statement only applies to the creation of new accounts.

To convert old accounts, you could try something like this:

Code:

---

ALTER TABLE __ADDRESSBOOK__ SET entry_tva_intracom='' WHERE entry_tva_intracom IS NULL

---

Replace __ADDRESSBOOK__ by the name of your address_book table, e.g. "zen_address_book" or just "address_book", if you didn't use prefixes. You have to look it up in the database.

Before you apply it, under all circumstances, make a backup of your database, so you will be able to restore it in case something goes wrong!

Hope this helps.

Bernhard

Hi Bernhard, thanks for your reply.
I applied the change as you suggested, but I didn't solved the problem with private EU customer.

So finally I modified the code of another mod to fit to my needs.

Thanks again :clap:

Quote:

---

Originally Posted by Aletiger

Hi Bernhard, thanks for your reply.
I applied the change as you suggested, but I didn't solved the problem with private EU customer.

So finally I modified the code of another mod to fit to my needs.

Thanks again :clap:

---

Hi Aletiger,

Can you post your solution as I have the same problem?

Thanks

Tassos