VAT-mod for European companies

i can not get the download of the new version :(

Hi,

I tried applying this version to 1.3.9h but have a problem during checkout.

If I add a £10 item to the basket when I go through checkout the total is £20 (always double) for the item and £2 (always 10% of the total value for VAT).

Any ideas?

Quote:

---

Originally Posted by dimjoula

VAT-Mod BETA UNOFFICIAL for Zen Cart v. 1.3.9h
For Companies inside European Union
===========================
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:
- 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/gvQSY8YGb (Zip file, 151 KB) :beta:

---

Quote:

---

Originally Posted by dimjoula

@ Brent: thank you. You are right, I used an older file. The only difference is the deletion of the icon column. So I have changed the archive.

---

Pleasure. I can't read any code so I have unfortunately have no idea what is important and what is not.

I think you may need to check /admin/orders.php as I think you are still using the version from 1.3.8a

Has anyone else noticed VAT calculation errors when using Group Discounts? This was originally discussed here.

If you do have you may want to check the following monologue. :smile:

Any advice on this happily received.

@dimjoula

Thanks for you update of the vat mod. One question though. could you try and make it compatible with super orders? What I mean is already make the changes in the files super_invoice.php, and super_packingslip.php.

Quote:

---

Originally Posted by BStBln

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

---

I'm having this exact problem as customers outside the UK but within the EU are not being charged VAT when they pay via paypal express. Please let me know exactly what the entry_tva_intracom fields in the database should be set to? Should i be unticking the Null box and in the default field setting it to 'None' and putting two exclamation marks ' ' like this underneath?:dontgetit

Quote:

---

Originally Posted by globalmemory

I'm having this exact problem as customers outside the UK but within the EU are not being charged VAT when they pay via paypal express. Please let me know exactly what the entry_tva_intracom fields in the database should be set to? Should i be unticking the Null box and in the default field setting it to 'None' and putting two exclamation marks ' ' like this underneath?:dontgetit

---

If I remember correctly, the problem was that the default was NULL but should be an empty string.

How familiar are you with databases? Do you know the difference between NULL and ''? And which database and database management software do you use?

Quote:

---

Originally Posted by BStBln

If I remember correctly, the problem was that the default was NULL but should be an empty string.

How familiar are you with databases? Do you know the difference between NULL and ''? And which database and database management software do you use?

---

I'm making changes through phpmyadmin and I'm not familiar with the code or commands. The fields are currently as follows:

http://www.zen-cart.com/forum/newatt...anageattach&p=

Can you edit this image so I can see exactly what changes to make?

Quote:

---

Originally Posted by globalmemory

Can you edit this image so I can see exactly what changes to make?

---

Which other options do you have in this combo box labelled "Default" (which on your picture is filled with value NULL)?

Quote:

---

Originally Posted by BStBln

Which other options do you have in this combo box labelled "Default" (which on your picture is filled with value NULL)?

---

The options are None, Null, As Defined and Current Timestamp