Printable View
Hi again,
I feel like a fool for this but I've solved my problem, and maybe some other people may have that prob, so I post the solution
One should put the content of the folder /includes/templates/YOUR_TEMPLATE/templates in the appropriate folder on the server and not just drag and drop the zip-file :sleepy:
yes, I'm a Zen Cart Newbie ;)
Thanks for the update ... :smile:
And don't feel too bad ... you couldn't begin to imagine some of the things that others have done ... but were afraid to admit that they did it ... :lamo:
Hi Beez,Quote:
Originally Posted by Beez
I think I know an easy way to show at least all product prices without VAT. As far as I am aware only shipping will still include VAT then. It only takes a one or two simple edits. Not sure if it works how you want it to work.
Let me know if you're still looking for this.
I'm trying again and again, but I can't find the way to show the VAT in the order email. Any suggestion?
Hi guys, great mod, have installed mod and checked through everything thrice, but don't seem to have access to it in Admin->Configuration->VAT-mod-> Don't see VAT-mod??
All fields have displayed in Admin->Customer and Create Accout but no access in Admin dropdown?Quote:
Originally Posted by Beez
Latest version of mod and cart and have set up Zones and Tax.
Any help would be appreciated. Thanks
Silly me, it was the permissions in Admin Profiles.
Great Mod, thanks
I can´t see Admin->Configuration->VAT-mod and tried to change my file permissions like beatnik but without any success. How can I make it viewable?
Ok, I found the problem when I switch the backend to English then it works. During testing the function I noticed a big Problem with it. If a private person from a EU country without a EU-Vat number buys sth it also deductes the tax!:shocking:
Doesn´t anyone else have this problem too?
We're unable to reproduce your problem. It works fine for us. Are you sure you have tax set up correctly? See the install.txt for instructions. Please let us know how it turns out.Quote:
Originally Posted by arve
Does the latest version work on zen 1.3.0 as well?
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.
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.Quote:
Originally Posted by Revenant
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
The 1 which I inserted to the SQL-Patch is for the language. My DB the structure is:Quote:
Originally Posted by vike
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.
The 1 which I inserted is for the language. My DB the structure is:Quote:
Originally Posted by vike
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.
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???
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
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. :no:
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 :bangin:
:oops:
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!!:cry::cry::cry:
:clap:mmm... i fiddled a bit (db extentions) and managed fo fix my own fault - sorry about the false alarm :blush:
Question about this mod. I have a european distributor in Spain and so we are setting up a joint website.
I am unfamiliar with VAT and was not sure exactly what this mod is doing. Is it just for removing the VAT if a valid number is entered in the customer info? Or should it be adjusting the VAT for the loaction in europe the customer is purchasing from? (like if they are in spain, shipping to germany what should it do?) All I keep getting is the default 33% estimate. Is that normal?
Sorry for the noob questions. I've just not been able to find explanations for this type of thing anywhere. :-)
Antiocles
I've a problem.
I've setup vat mod to ceck the vat number, but don't work.
If I write an strange vat (1234) in the vat field, the account is created.
Only if there's another error in account creation, the vat mod ceck the vat number and show me the error page.
Plase, try this on 100asa dot it
Thank you
Nice site you have there!
I have investigated a bit this VAT (IVA) check and I got this from VIES:
Dear all,
You have indicated issues with the use of the VIES on the Web application after its upgrade to a new architecture, last Thursday July 5th.
We would like to remind you that the URL of the web page allowing you to verify the validity of a VAT number has moved to http://ec.europa.eu/taxation_customs/vies/vieshome.do.
This page is intended for interactive users not applications.
A SOAP web service, offering the same functionality as the interactive service is available at http://ec.europa.eu/taxation_customs...i/checkVatPort.
SOAP is a standard protocol based on XML exchanges and commonly used for implementing web services. The complete description of the service (IN and OUT parameters, possible exceptions... ) is provided in a WSDL file which is available at http://ec.europa.eu/taxation_customs...ckVatPort?wsdl.
This file usually constitutes the entry of a SOAP engine that can generate the needed code to manage the interactions with the service.
Please contact your application providers for technical assistance.
Best regards,
see if you can make anything out of this
Ciao
Thank's for reply.
The problem is VAT mod don't ceck the vat number in create account.
In admin section ceck flag in vat section is set to true.
ps: complimenti per il sito e per il caffè!
Hi all
Was doing some testing and noticed the following:
Checking out with a customer where NO tax is calculated, the
word 'VAT' appears in the order total
(ex. VAT : €0,00)
But checking out with a customer where tax IS calculated, the
word 'tax' doesn't appear.
(ex. : €18,90)
screenshot attached
Anyone else noticed this?
Or better, anyone know how/where to fix?
Regarding my post about the display of the word 'tax'.
Did a search on the forum and found another thread about it here:
http://zen-cart.com/forum/showthread.php?p=420574
So it may not be related to this mod after all.
The thread has a solution, posted by Ajeh, for the problem.
It doesn't seem to work with a multilingual shop but I have posted
the question in the other thread.
The CGI-method is not longer available so vat number check gives a 404 not found and schrews the total layout of the shop!
I think we have to found a solution very soon. For now i have to disable VAT check.
Someone experiences with SOAP/XML to change this wonderful, very usefulll and vero good coded module?
Quote:
Originally Posted by francocauter
it's possible to show in checkout_payment.html the billing name complete with company name and vat number?
Many customers don't see this information and they think we don't send them the invoice.
How can I do?
Is someone already working on this? If your are a SOAP/XML coder with a littlebit time please help us to get this nice and wonderfull module working.
Quote:
Originally Posted by importprijs.nl
There is't a checkout_payment.html file in Zen Cart.
I think it's standard to display the billingname complete with companyname on checkout. What do you mean? You want to display the vatnumber in billingaddress?
Maybe you can make a screenshot where you want to add the vat number..
Quote:
Originally Posted by 100asa
Hi Beez. Gled talking with you. I have a problem trying to install your VAT mod. When I'm using tha Admin tool "Install SQL pach" acotding with your instraction I receive : [INSERT INTO configuration_group VALUES ('27', 'VAT-Mod', 'VAT-Mod options', '27', '1');]Quote:
Originally Posted by Beez
PLease help me. I use Zen Cart v1.3.7.1 Can be this an issue?
Hi,
I had the same problem. Please refer to following post for the solution:
http://www.zen-cart.com/forum/showpo...&postcount=115
Regards
Terry
Hello,
I just installed the VAT mod on my webshop, but I get an error. The error says : "Server is unable to check your VAT number: please, leave blank"
The VAT number I enter is in the right format, cause he does not give me an error on the format. He just gives me that error about being unable to check the number.
Anyone have any advice for me ?
A second question : I'd like to make that VAT field 'required', so customers have to fill in a correct VAT number before being able to continue.
Thanks in advance, Jan.
I found that a bit ropey, I switched it off and now I check VAT no.s manually.
Easy enough to add asterix, harder to make compulsory.
HI
Thanks for this great mod.
I installed it but my Gross prices in Admin do not compute properly. Her is my Tax config:
TAX CLASSES
1 tax class : VAT
ZONES DEFINITIONS
1st zone : Belgium
2nd zone: EU (European Union)
TAX RATES
Tax rates 1: Tax Class: VAT, Zone: EU, Tax Rate: 21%, Priority 1
Tax rates 2: Tax Class: VAT, Zone: EU, Tax Rate: 21%, Priority 2
Everything works fine at checkout and it works nicelly except for one important problem:
When I input Net Prices in Admin and choose VAT as Taxe rate, ZenCart compute 2x the VAT to calculate the Gross price.
for example: I input Net Price 100 and choose Tax Rate VAT (21%) it should compute a Gross price of 121, but instead it gives me a Gross Price of 142 !!
What can be wrong ? PLEASE HELP
My Config is as follow
Basis of Product Tax is Shipping
Basis of Shipping Tax is Shipping
Display Prices with Taxe is True
Display Prices with Taxes in Admin is True
Sales Tax Display is 1
hello
i am getting this error when trying to install the sql
1062 Duplicate entry '27' for key 1
in:
[INSERT INTO zen_configuration_group VALUES ('27', 'VAT-Mod', 'VAT-Mod options', '27', '1');]
can someone help me please.
Thanks
Hello all fans, thanks for all your intrest and contributions!
Sorry for the extreme delay - we've been, just as extremely, buzzy :lamo:
But now we're finally back and hope to be so more regularly :lookaroun
Version 1.2.6 is available at http://www.zen-cart.com/index.php?ma...products_id=89
The Mod currenly is only tested with Zen Cart 1.3.7
We installed the Mod on a Zen Cart 1.3.7 distribution, and had to fix only the sql-file's quoting and to update the contact with the server (with a POST-request btw)..
As for the language_id column in the configuration_group table there is none in the 1.3.7 distribution. Maybe there's another mod?
Sebastian Bergquist (Beez) & Viktor Bergquist (vike)
Hi has anybody got this mod working on zen cart v1.3.8 ?
Good Day All
First I would like to thank Beez & vike for this mod.
Question I have setup a customer in the UK and apparently, when your company is in the UK and you ship to a company in the UK you need to charge VAT on the shipping can this be done and if so would you be able to point me in the right direction on how to.
Thanks
Dave G
Also wondering about version 1.3.8
I found that there is a duplicated function called zen_address_format()
on functions_customers.php
and general.php
functions_customers.php is from the catalog files and the and the is from admin. Are you sure you got the right files in the right directory? or has there been changes in 1.3.8?Quote:
Originally Posted by joachimp
We have not tested with Zen Cart 1.3.8, yet, but we will do it as soon as we got the time. If anyone does install it on 1.3.8, please report your finding.
Hi,
I'm doing a full restore, maybe I did made a mistake... I will let you know...
Joachim
Same deal, when trying to log in on the admin part I get the following:
Fatal error: Cannot redeclare zen_address_format() (previously declared in /www/zencart/admin/includes/functions/general.php:470) in /www/zencart/admin/includes/functions/functions_customers.php on line 35
zencart2 is before installing the mod, zencart is with the mod.
shrek:/www/zencart2/admin/includes/functions# regrep zen_address_format
./functions_customers.php:35: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {
./functions_customers.php:134: return zen_address_format($format_id, $address->fields, $html, $boln, $eoln);
./general.php:465: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {
shrek:/www/zencart2/admin/includes/functions#
shrek:/www/zencart2/admin/includes/functions#
shrek:/www/zencart2/admin/includes/functions#
shrek:/www/zencart2/admin/includes/functions# cd /www/zencart/admin/includes/functions/
shrek:/www/zencart/admin/includes/functions# regrep zen_address_format
./functions_customers.php:35: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {
./functions_customers.php:134: return zen_address_format($format_id, $address->fields, $html, $boln, $eoln);
./general.php:470: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {
shrek:/www/zencart/admin/includes/functions#
I will do some further digging...
Extra figures appearing on invoice page in admin
On the attachment we have circled two areas - we need to get rid of these but cannot work out what they are called so cannot find similar problems on zencart. They only started appearing after we recently installed the European VAT Module - do you have any ideas how we could delete/remove these from invoices?
other conversation about this
http://www.zen-cart.com/forum/showth...hlight=invoice
We have compared files and everything seems fine.
Please help is anyone else getting this problem?
This is the code for invoice.php in our admin folder.
<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce |
// +----------------------------------------------------------------------+
// | Copyright (c) 2006 The zen-cart developers |
// | |
// | http://www.zen-cart.com/index.php |
// | |
// | Portions Copyright (c) 2003 osCommerce |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | [email protected] so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
// $Id: invoice.php 6524 2007-06-25 21:27:46Z drbyte $
//
require('includes/application_top.php');
require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();
$oID = zen_db_prepare_input($_GET['oID']);
include(DIR_WS_CLASSES . 'order.php');
$order = new order($oID);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/menu.js"></script>
<script language="javascript" type="text/javascript"><!--
function couponpopupWindow(url) {
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=450,height=280,scree nX=150,screenY=150,top=150,left=150')
}
//--></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- body_text //-->
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"></td>
<td class="pageHeading" align="right"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2"><?php echo zen_draw_separator(); ?></td>
</tr>
<?php
$order_check = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
customers_suburb, customers_city, customers_postcode,
customers_state, customers_country, customers_telephone,
customers_email_address, customers_address_format_id, delivery_name,
delivery_company, delivery_street_address, delivery_suburb,
delivery_city, delivery_postcode, delivery_state, delivery_country,
delivery_address_format_id, billing_name, billing_company, billing_tva_intracom,
billing_street_address, billing_suburb, billing_city, billing_postcode,
billing_state, billing_country, billing_address_format_id,
payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
currency_value, date_purchased, orders_status, last_modified
from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'"); // TVA_INTRACOM
$show_customer = 'false';
if ($order_check->fields['billing_name'] != $order_check->fields['delivery_name']) {
$show_customer = 'true';
}
if ($order_check->fields['billing_street_address'] != $order_check->fields['delivery_street_address']) {
$show_customer = 'true';
}
if ($show_customer == 'true') {
?>
<tr>
<td class="main"><b><?php echo ENTRY_CUSTOMER; ?></b></td>
</tr>
<tr>
<td class="main"><?php echo zen_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>
</tr>
<?php } ?>
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_SOLD_TO; ?></td>
</tr>
<tr>
<!-- BEEZ_VIKE_GENERAL_FIX REPLACE BEGIN -->
<td class="main"><?php echo zen_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>
<!-- BEEZ_VIKE_GENERAL_FIX REPLACE END -->
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
</tr>
<!-- BEEZ_VIKE_GENERAL_FIX REPLACE BEGIN -->
<tr>
<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?> <?php echo $order->customer['telephone']; ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?> <?php echo '<a href="mailto:' . $order->customer['email_address'] . '">' . $order->customer['email_address'] . '</a>'; ?></td>
</tr>
<!-- BEEZ_VIKE_GENERAL_FIX REPLACE END -->
<!-- TVA_INTRACOM BEGIN -->
<?php if (zen_not_null($order_check->fields['billing_tva_intracom'])) { ?>
<tr>
<td class="main"><b><?php echo ENTRY_TVA_INTRACOM; ?></b> <?php echo $order_check->fields['billing_tva_intracom']; ?></td>
</tr>
<?php } ?>
<!-- TVA_INTRACOM END -->
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_SHIP_TO; ?></td>
</tr>
<tr>
<td class="main"><?php echo zen_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<!-- TVA_INTRACOM BEGIN -->
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<tr>
<td class="main"><b></b></td>
<td class="main"><?php echo TVA_SHOP_INTRACOM; ?></td>
</tr>
</table></td>
</tr>
<!-- TVA_INTRACOM END -->
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_ORDER_ID . $oID; ?></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_DATE_PURCHASED; ?></td>
<td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_PAYMENT_METHOD; ?></td>
<td class="main"><?php echo $order->info['payment_method']; ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>
</tr>
<?php
for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
echo ' <tr class="dataTableRow">' . "\n" .
' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
' <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];
if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) {
for ($j = 0; $j < $k; $j++) {
echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . nl2br($order->products[$i]['attributes'][$j]['value']);
if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
if ($order->products[$i]['attributes'][$j]['product_attribute_is_free'] == '1' and $order->products[$i]['product_is_free'] == '1') echo TEXT_INFO_ATTRIBUTE_FREE;
echo '</i></small></nobr>';
}
}
echo ' </td>' . "\n" .
' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";
echo ' <td class="dataTableContent" align="right" valign="top">' . zen_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><b>' .
$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) .
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n" .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
$currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><b>' .
$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><b>' .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
$currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n";
echo ' </tr>' . "\n";
}
?>
<tr>
<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
</table></td>
</tr>
</table></td>
</tr>
</table>
<?php
//--Add comments starts--
$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 limit 1");
//--Add comments ends--
?>
<?php
<!--add comment starts-->
<tr><td class="main"><?php echo '<b>Customer comments: </b>' . $orders_history->fields['comments']; ?></td>
</tr>
<!--add comment ends-->
?>
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
I found a small bug in VAT-Mod 1.2.5.
File vatmod.php was place in false directory.
admin/includes/languages/extra_definitions/vatmod.php
BUT SHOULD HAVE BEEN IN
admin/includes/languages/english/extra_definitions/vatmod.php
marksu
I had the same problem. First it seemed that the total column appeared above the list.Quote:
Originally Posted by martyndw2005
But if you look at the figures you will see that it's not the total column that is out of place, but the unit price (look at the row where you've ordered multiple items).
In my case there was a missing <tr> or <td> tag somewhere...
:oops: I get this funny message at the top of the page, when trying to register as a new customer, with a valid VAT number:
Warning: file_get_contents() expects at most 2 parameters, 3 given in /var/www/html/cart/includes/functions/extra_functions/functions_vatmod.php on line 77
I have PHP 4.3.9, ZC 1.3.7.1 and the latest VAT-mod.
Also, I can't seem to find where to manually validate users VAT numbers in the admin section?
Any idea?
VAT-Mod 1.2.7beta for Zen Cart v. 1.3.8
For Companies inside European Union dealing with european sales tax.
IMPORTANT NOTE: THIS IS NOTE THE OFFICIAL RELEASE FROM Beez & Vike.
IT IS A *BETA* VERSION.
I did a simple Cut and Paste from the previous code VAT-Mod 1.2.6 for Zen Cart v. 1.3.7) and paste it to Zen Cart v. 1.3.8 files.
It works for me, but you should take it with cautious.
What's new:
- Compatibility with Zen Cart v. 1.3.8
- adding Bulgaria and Romania to the list
- french translation
- update of the VIES link to check the validity of the number
I hope that Beez & Vike will offer an official release soon. :smile: And thanks guys for your great help !!
Dimjoula: thank you very much
All seems to be working ok, except a PHP4 problem with VAT verification process in function zen_verif_tva, where is used file_get_contents with $context parametr, which is supported from PHP5.
I know it's weird to use PHP4 in the age of PHP6 coming :-)
Hi there everyone
Every time I install or update this Mod in my outputted Invoice, instead of "Company VAT No. XXXX......" I get TVA_SHOP_INTRACOM.
Is there a way to correct that? and how?
Thanks for your help in advance.
@francocouter - See post 146; that may help
Thanks Ryk that helpedQuote:
Originally Posted by Ryk
Kind Regards
Hi
Should users get the option to add/change/correct their VAT number?
It doesn't seem to be there in any of the 'My Account' options.
[sorry if this has been raised before, but this is a very long thread to wade through]
Thanks
Pa
Look carefully, it's working in My Account -> View or change entries in my address book.
Duh - So it is.
Sorry - these senior moments seem to be happening more and more ;-)
Thanks Mate
Pa
I have had same problem .. it turned out to be line 202 on admin/ invoice.php .. took out </td>Quote:
Extra figures appearing on invoice page in admin
On the attachment we have circled two areas - we need to get rid of these but cannot work out what they are called so cannot find similar problems on zencart. They only started appearing after we recently installed the European VAT Module - do you have any ideas how we could delete/remove these from invoices?
other conversation about this
http://www.zen-cart.com/forum/showth...hlight=invoice
We have compared files and everything seems fine.
Please help is anyone else getting this problem?
more detail on other topic
http://www.zen-cart.com/forum/showth...hlight=invoice
hope this helps
For those who did not go to the previous page, there is an unofficial upgrade version of this plugin for ZenCart 1.3.8 at this address:
http://www.zen-cart.com/forum/showpost.php?p=509374
For me the same problem. I put al the files in the wright places, see reply 146.Quote:
Originally Posted by francocauter
but ive nowhere in the admin a possibility to put in my own shop VATnr.
also are my vatnr of customers empty.
i updated my site till 1.3.6 with database patchlevel 1.3.7
Good Day All
Not sure if this is the correct place to post this question, but I need to start somewhere.
I have a UK based ZenCart and need to exclude the Channel Islands from being charged VAT can this be done using VAT-mod? If not I'm open for suggestions.
Thank You
Dave G
Everything works fine with ZenCart 1.3.8 and the VAT-Mod I adapted for this version, and I solved a little bug in the admin area. You should give it a try. But, VAT-mod 1.2.7b is NOT compatible with ZenCart 1.3.7 and below, you must use the last version of ZenCart (1.3.8)Quote:
Originally Posted by aurelius99
I don't recall the exact procedure (see Zen Cart tutorials and the VAT-Mod Read Me file). But, you have to create a Zone Definitions (see Locations / Taxes) menu, e.g. EU , add the countries, then on the Tax Rate menu, tell to which Zone Definition applies the tax rate.Quote:
Originally Posted by Dave G
dimjoula thank you for the reply I have VAT-Mod working fine the problem is the Channel Islands are "not part of the UK but rather a separate possession of the Crown" I have tried to add "Channel Islands" as a country and Jersey, Guernsey, Alderney, Sark and Herm as Zones but then the Royal Mail does not work and I am still getting charged VAT.Quote:
Originally Posted by dimjoula
Maybe I missing something?
Dave G
Are these islands part of the UK (so the same country) ? If yes, I think you have to do the same thing with countries which have states (US, Canada, Australia, ...). See the Locations / Taxes menu, Zones, and Zones Definition. Then, try to make a zone tax free and another with tax. If you are not successful, I belive you should see another part of the forum or use the search function because it is not related to the VAT-Mod module. And I am sure will get better answers, because more people are stoping by there !
Thanks dimjoulaQuote:
Originally Posted by dimjoula
You made me think on how to do this and I got it working.
Thank You
Dave G
Is anyone having problems with the VAT number verification? I keep getting the error message that they cannot find the number from the europa.eu.int server. :frusty:
I am using the updated VAT for Zen Cart v. 1.3.8
Thanks!
I updated all the files for the latest VAT beta for Zen Cart 1.3.8 but my site still does not show the VAT tax on any of the pages except in the account info. Can someone help? My site is http://eustore.oculusis.com
Thank You! :blink:
Nevermind :oops: I didn't have a correct EU address when I was testing.Quote:
Originally Posted by cheungvong
I read all, but could not find an answer.
I'd like to have VAT excluded for a company (If VAT number is entered) and included for a customer (if VAT is omitted).
The activation of a company as non VAT customer could be done with manual approval after checking on http://ec.europa.eu/taxation_customs...tedLanguage=EN.
Any ideas how to accomplish that? Txs
Sorry, I did not mentioned.
How to take off VAT for the companies in the same country?
I have successfully installed this onto a 1.3.8 (more testing needed), but wanted the verification to work.
After playing with the urls on the vies site i found the following fix seemed to work (not guaranteed! :smile:):
In includes/functions/extra_functions/functions_vatmod.php i replaced:
$monfd = file_get_contents('http://ec.europa.eu/taxation_customs/vies/viesquer.do', null, $context);
with
$monfd = file_get_contents('http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms=' . $prefix . '&iso=' . $prefix . '&vat=' . $tva, r);
Not fully tested but seems to work, i also amended the admin version of this file to the same and that seems to work when editing a customers vat number.
Is this mod supposed to show the total during checkout without VAT as mine seems not to, but this may be installing the 1.3.7 version onto my 1.3.8!?!?
Sorry, it does not work this way, unfortunately. I would love to, but it is only during the checkout process that it applies VAT or not. Your shop will display all items with or without VAT (depending on your parameter), not depending on the client status.Quote:
Originally Posted by mindows
Mmh. The verification is still working for me. Around line 71, can you replace POST with GET, and keep the same code? I think your server don't want to send a POST request, and only accept to send a GET request.Quote:
Originally Posted by rickcj
After editing a few spelling mistakes, I release it again:
VAT-Mod 1.2.7 for Zen Cart v. 1.3.8
For Companies inside European Union dealing with European sales tax.
IMPORTANT NOTE: THIS IS NOTE THE OFFICIAL RELEASE FROM Beez & Vike.
I did a simple Cut and Paste from the previous code VAT-Mod 1.2.6 for Zen Cart v. 1.3.7) and paste it to Zen Cart v. 1.3.8 files.
It works for me, but you should handle it with care.
What's new:
* Compatibility with Zen Cart v. 1.3.8
* adding Bulgaria and Romania to the list
* French translation
* update of the VIES link to check the validity of the number (http://ec.europa.eu/taxation_customs/vies/)
I hope that Beez & Vike will offer an official release soon (they don't answer to their e-mails :( ). And thanks guys for your great help !!
Yahoo! I found a solution!Quote:
Originally Posted by dimjoula
It is VAT mod for EU comp + Customer Tax Exempt :clap:
VAT mod for EU comp gives me a possibility to register companies on the site properly, review details to make sure it is not a scam.
http://www.xadoireland.ie/e-shop/images/company.jpg
Then Customer Tax Exempt mode gives possibility to "turn on" the company view mode - they can see all prices without tax, at the same time, when ordinary users see the prices with VAT!
http://www.xadoireland.ie/e-shop/images/Options.jpg
For the customers, which have in the field Customer Tax Exempt "ALL" (I put ALL manually as a "stamp" after checking all the details) will be shown the prices without VAT!
Who does not have that entered - will be shown normally with VAT!
Just if you will try to merge them you will need to review the overlapping files!
Or will not work :lamo:
Fatal error: Cannot redeclare zen_address_format() (previously declared in /home/www/7f081bbe8f38b5cfa4478b5cbaeba6ac/web/shop/admin/includes/functions/general.php:470) in /home/www/7f081bbe8f38b5cfa4478b5cbaeba6ac/web/shop/admin/includes/functions/functions_customers.php on line 115:
zen cart 1.3.8
server info
PHP Built on: Linux imu124 2.6.18.5-imu-x86-136 #1 SMP Fri Mar 28 12:20:37 CET 2008 i686
Database Version: 5.0.45-log
Database Collation: utf8_general_ci
PHP Version: 5.2.5
Web Server: Apache
Web Server to PHP interface: apache2handler
Joomla! Version: Joomla! 1.5.6 Production/Stable [ Vusani ] 12-August-2008 22:00 GMT
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
Check your files and make sure the 2 function files are current ...
The function is listed in both, but it is commented out of general.php
Perhaps you do not have the files updated correctly?
Or, perhaps you have an add-on that has overwritten these functions with an out of date version? :unsure:
here is the VAT module i installed http://www.zen-cart.com/index.php?ma...products_id=89,
what should i do access admin section this is not possible yet . thanks
now i have find a solution and can login to backend the vat modul is displayed but i get this error:oops:
Warning: file_get_contents() [function.file-get-contents]: URL file-access is disabled in the server configuration in /home/www/7f081bbe8f38b5cfa4478b5cbaeba6ac/web/shop/admin/includes/functions/extra_functions/functions_vatmod.php on line 84
Warning: file_get_contents(http://ec.europa.eu/taxation_customs/vies/viesquer.do) [function.file-get-contents]: failed to open stream: no suitable wrapper could be found in /home/www/7f081bbe8f38b5cfa4478b5cbaeba6ac/web/shop/admin/includes/functions/extra_functions/functions_vatmod.php on line 84
I can not see Vat module in Frontend, thanksn for your help
Hello, i've installed this mod on my zencart 1.3.8a store, but i do not want one thing: customers must write their vat numer in following way:
"Contry Code" + "VAT Number"
-exapmle
VAT = PL1234567890
I want to leave just "VAT Number", without the contry code
-example
VAT = 1234567890
I will not get orders from others contries, only from mine, so "Contry Code" for me is useless.
Does somebody know how to do it? Witch files i must modify? I tried to do it for my own, but my php knowledge isn't great.
No, you cannot change it. It is the European law. The number must be written this way. But, it is mandatory for foreign companies. If you are planing to accept orders only from your country, you don't need this plugin. It is useless. For individuals and for companies in your country, you must add VAT anyway. Ask your accountant about the European VAT regulations.
I keep getting this error message, no matter what I'm trying to do:
"Server is unable to check your European Tax number: please, leave blank."
Anyone found a way to make it work?
Yes i just implemented it 2 week ago and is working fin on ZenCart 1.3.8a First i got this message also but after reading again the readme carefully i found i did something wrong.
I am running super orders on my sites and i wondered if this mod can be used on that?
Am i right in thinking that the changes to orders.php, packing slip.php and invoice.php will be irrelevent to my sites as they are using the super order equivalent files?
What is the best way to get this running on super orders?
Look at the differences between orders.php etc from this mod and the original files and copy the extra code from the VAT mod files into the equivalent super order file?
i.e compare vat mod orders.php with zencart orders.php, extract the extra code and paste into super order orders.php?
Anyone who is running super orders and this mod give any advice?
thank you for this wonderful mod
It almost works perfectly. New customers can add their VAT-number and when they are living outside my country and within the EU, the do not have to pay the VAT.
But the problem is that when users in EU outside my country don't have a company with a VAT-number, they must pay VAT....but in this mod, they are also vat-free.
How can I handle this?
Works now...didn't read the manual correct. I forgot making a second geo_zonesQuote:
Originally Posted by raimond
Hi all users of the VAT-mod!
We're glad to see that the mod is being used, and quite successfully by the looks of it :)
We're haven't been able to maintain the development of this mod for over a year, but We'll try to keep track of it now. I've just updated the version here: http://www.zen-cart.com/index.php?ma...products_id=89 Current version is 1.2.8 and for Zen Cart 1.3.8a.
As soon as Zen Cart version 2.0 is out will we update the VAT-mod as soon as we can.
Stay tuned!
Good to see you back !
I am not an expert in php coding and I am glad you are taking over the project again. For the next version, as there is no rush, can you please see if you can implement the code that will display prices with or without VAT for the whole shop (not only at checkout). See the previous posts, someone seems to have found a solution (not tested by myself), but if it is fine, it would be great to have a more elegant way to include this code into VAT-mode ? Indeed, we must display prices with VAT in the shop to customers that must pay them. So doing it only at checkout is not enough (not tolerate) according to our European laws.
I think that European comanies depend on China whether there are subventions for many indurtrial branches. It is conducted until it devastate concurency. Then subventions are lower and lower and prices became more real. The cloth industry is one example. China has destroyed others and became leader at this industry only because dumping prices. Now we must be prepared for Chinas domination in this industry. It'll happen in other industries.
Hi
I istalled the last version of this module 2 times, but after that my site crashed!!! :censored:
The administration zone works normally, but the catalog is a white page, without any html code!!!
I don't understand where if I do any errors, but I'm sure that I copied all file in my site, and the sql patch works perfectly.
Another problem: this folder: "\includes\templates\YOUR_TEMPLATE\templates\" is empty!!
then I uploaded these files (taken from the previous version of the module):
tpl_modules_address_book_details.php
tpl_modules_checkout_new_address.php
tpl_modules_create_account.php
Is this correct?
thanks!
New version (1.3.0) uploaded today. As soon they have approved it it can be found here: http://www.zen-cart.com/index.php?ma...products_id=89
New in this version is that all prices in the store is shown without tax if customer from another country than the store is logged in with a verified VAT-number.
francy88: I'm terribly sorry that I missed the files in templates. I've checked and they are in the new version (1.3.0). Good luck!
ok thanks beez, I will try to install the new version of the module.
do you think that are the 3 template files (token from the old version of the module) that break the site?
Another question about 1.2.7 beta version:
if I create a new account on my site and I insert a VAT number during registration, this field not compares in database (under "address_book" table). Instead, if I insert this field from admin page (customers), it appears in DB, and the tax will removed during checkout.
Where is the problem??
thanks
Francesco
I don't think the emplate files would break the site that bad.Quote:
Originally Posted by francy88
I haven't noticed any problem there. Let me check and see if it works for me. There could be that you have missed something when you edited the files or maybe there is something with the old template files. I don't remember when the different changes were made. I'll get back when I checked it out.Quote:
Another question about 1.2.7 beta version:
if I create a new account on my site and I insert a VAT number during registration, this field not compares in database (under "address_book" table). Instead, if I insert this field from admin page (customers), it appears in DB, and the tax will removed during checkout.
Where is the problem??
francy88: I've tested it on my installation. When I register an account with VAT-number it works as it should for me. The tax is not added when the customer is from another country than the store. The VAT-number is stored in the "address_book" table. Am I not getting what you mean?
Hi Beez, I solved my problem.
At the begin I put the file "create_accout.php" under "includes/modules".
Now I put the same file under "includes/modules/classic" and all works...
Another question: if I try to change my VAT data in frontend (home » My Account » Address Book » Update Entry), the imput field "european tax number" is not populates with the old VAT number (inserted during registration).
Also, if I try to insert a new VAT number, database not updates.
Another test I have do is to create a new account without VAT number, and after that try to insert a VAT number under "home » My Account » Address Book » Update Entry"; but nothing changes....
How can I do??
sorry for my poor english, but I'm italian :P :P
Thank you very much!
Francesco
I've checked and it all works for me. I think you must have missed some changes in some files. Try to reapply the files from the latest version.
ok thanks.
which files I must change to apply changes on profile?
Francesco
Hey,
I just tried to install the mod and got a white screen too...
In my case the functions_vatmod.php is broken (in includes/... and admin/includes/...)
edit (from line 121 to end)
toPHP Code:'CZ'=>'CZ', //Czech Republic
'SI'=>'SI');//Slovania
'RO'=>'RO', //Romania
'BG'=>'BG'); //Bulgaria
return $intracom_array;
}
?>
If I'm wrong and the array is broken with intend, please tell me ;)PHP Code:'CZ'=>'CZ', //Czech Republic
'SI'=>'SI', //Slovania
'RO'=>'RO', //Romania
'BG'=>'BG'); //Bulgaria
return $intracom_array;
}
?>
MfG
hi overlord.
yes, the ")" was an error I've find too, and I've correct it.
but the site remains broken also after the modify... :no:
I hope you did not just see the ) but also the , instead of the ; ?!!