VAT-mod for European companies

[libelle]

Hi to all, I'm trying to install this mode, but I have this problem updating the database. This is the error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO configuration VALUES ("", "Check the VAT number", "ENTRY_TVA_INTRACO' at line 3
in:
[INSERT INTO configuration_group VALUES (27, "VAT-Mod", "VAT-Mod options", 27, 1); INSERT INTO configuration VALUES ("", "Check the VAT number", "ENTRY_TVA_INTRACOM_CHECK", "true", "Check the Customer's VAT number by the europa.eu.int server", 27, 1, "", "", NULL, "zen_cfg_select_option(array('true', 'false'),"); INSERT INTO configuration VALUES ("", "VAT number of the store", "TVA_SHOP_INTRACOM", "", "Intracom VAT number:", 27, 22, "", "", NULL, NULL); INSERT INTO configuration VALUES ("", "Minimum characters for VAT number", "ENTRY_TVA_INTRACOM_MIN_LENGTH", 10, "Required characters for VAT number (0 if you don't want checking)", 27, 17, "", "", NULL, NULL); ALTER TABLE address_book ADD entry_tva_intracom VARCHAR(32) DEFAULT NULL AFTER entry_company; ALTER TABLE orders ADD billing_tva_intracom VARCHAR(32) AFTER billing_company;]
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.

What should I do? HELP!!!

[oberheimer]

Still not working
"Server is unable to check your VAT number: please, leave blank"
maybe i should disable it for now
i'm using 1.3.8a with 1.30
i'm getting tired of this, some say it work but not for me and i have installed it as i should. It can't take this long to fix, if not i have to pay someone to fix it...

[oberheimer]

Can anyone fix this or?
I even tried to install and fix it and the shoping cart stoped working lol
If not i have to use the shop without it, it's not rocket science
I'm not a coder, but i'm sure it would be an easy fix for someone who can code.

[dimjoula]

Just for your information, the beta version I released here is only compatible with Zen Cart 1.3.9, it is not compatible with 1.3.8a.

@ oberheimer: it is possible that your web server (say, your provider) refuse to connect to an external server (from a server to another server), thus blocking the connection to the VAT Number website. If this is the case, there is nothing to fix.

[Brent]

Hi dimjoula,

Firstly many thanks for taking the trouble to release the update.

I wanted to check something in /admin/invoice.php around lines 236

The stock version from 1.3.9h is as follows:

<?php if (ORDER_COMMENTS_INVOICE > 0) { ?>
      <tr>
        <td class="main"><table border="0" cellspacing="0" cellpadding="5">
          <tr>
            <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_DATE_ADDED; ?></strong></td>
            <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_STATUS; ?></strong></td>
            <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
          </tr>
<?php
    $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
                                    from " . TABLE_ORDERS_STATUS_HISTORY . "
                                    where orders_id = '" . zen_db_input($oID) . "' and customer_notified >= 0
                                    order by date_added");

    if ($orders_history->RecordCount() > 0) {
      $count_comments=0;
      while (!$orders_history->EOF) {
        $count_comments++;
        echo '          <tr>' . "\n" .
             '            <td class="smallText" align="center" valign="top">' . zen_datetime_short($orders_history->fields['date_added']) . '</td>' . "\n";
        echo '            <td class="smallText" valign="top">' . $orders_status_array[$orders_history->fields['orders_status_id']] . '</td>' . "\n";
        echo '            <td class="smallText" valign="top">' . ($orders_history->fields['comments'] == '' ? TEXT_NONE : nl2br(zen_db_output($orders_history->fields['comments']))) . '&nbsp;</td>' . "\n" .
             '          </tr>' . "\n";
        $orders_history->MoveNext();

Your version is as follows:

<?php if (ORDER_COMMENTS_INVOICE > 0) { ?>
      <tr>
        <td class="main"><table border="1" cellspacing="0" cellpadding="5">
          <tr>
            <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_DATE_ADDED; ?></strong></td>
            <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></strong></td>
            <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_STATUS; ?></strong></td>
            <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
          </tr>
<?php
    $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
                                    from " . TABLE_ORDERS_STATUS_HISTORY . "
                                    where orders_id = '" . zen_db_input($oID) . "'
                                    order by date_added");

    if ($orders_history->RecordCount() > 0) {
      $count_comments=0;
      while (!$orders_history->EOF) {
        $count_comments++;
        echo '          <tr>' . "\n" .
             '            <td class="smallText" align="center">' . zen_datetime_short($orders_history->fields['date_added']) . '</td>' . "\n" .
             '            <td class="smallText" align="center">';
        if ($orders_history->fields['customer_notified'] == '1') {
          echo zen_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";
        } else {
          echo zen_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";
        }
        echo '            <td class="smallText">' . $orders_status_array[$orders_history->fields['orders_status_id']] . '</td>' . "\n";
        echo '            <td class="smallText">' . ($orders_history->fields['comments'] == '' ? TEXT_NONE : nl2br(zen_db_output($orders_history->fields['comments']))) . '&nbsp;</td>' . "\n" .
             '          </tr>' . "\n";
        $orders_history->MoveNext();

Most of these differences however seem to be as a result of changes made by the Zen Team between V1.3.8a and V1.3.9h. What I couldn't work out is whether the VAT Mod needs the old code or if I can drop it

Kind regards,

Brent

[oberheimer]

Ok if you can install it so it works (copy everything to the new files)
i can send $$ your way (paypal). I'm just checking with my host first about connecting to a different server

I just need this to work so i can open my shop

[oberheimer]

Hmm i set the vat check to false now so i can check it manually but i still have a blank screen in the cart index.php?main_page=checkout_payment

if i can fix this i'm set for now

[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.
@ oberheimer: this bug looks like a bad copy and paste of a mod to a genuine zen cart file. Try to find what you have modified in the checkout files and redo it carefully. It is a classical mistake. You should try to find better advice on this matter in other sections of this forum.

[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)

[oberheimer]

Now it works
thanks alot dimjoula for info
Now i just need to fix the store country, they charge me 25% even for the company but i think someone fixed it here so need to check thanks alot i'm so happy atm