We’ve just installed code that will correctly check and validate an EU VAT number then assign a customer to an appropriate tax group, i.e. UK VAT exempt for EU member state transactions with a valid EU VAT number.
I’ve just finished a commercial extension which handles the issue of charging channel island customers zero vat, without having to moving around countries, etc.
<removed>
Some of you may know me as the author of Auctionmaid Matrixrate, which filters based on Postcode to solve a lot of the UK issues around posting to places like the Channel Islands.
No releases available for package “connect.magentocommerce.com/community/Auctionmaid_Matrxrate”
Cannot initialize ‘channel://connect.magentocommerce.com/community/Auctionmaid_Matrxrate’, invalid or missing package file
Install Errors
Package “channel://connect.magentocommerce.com/community/Auctionmaid_Matrxrate” is not valid
PEAR ERROR: install failed
Majacore, sounds like you are having some issues with your Magento Connect. Maybe you want to post on the matrixrate forum as opposed to this thread and I’ll see if I can help. I’m certainly not aware of any issues, this code has been stable for quite some time.
Rgds
Karen
majacore - 31 March 2009 01:00 AM
No releases available for package “connect.magentocommerce.com/community/Auctionmaid_Matrxrate”
Cannot initialize ‘channel://connect.magentocommerce.com/community/Auctionmaid_Matrxrate’, invalid or missing package file
Install Errors
Package “channel://connect.magentocommerce.com/community/Auctionmaid_Matrxrate” is not valid
PEAR ERROR: install failed
Yes, we have a fully functioning module that correctly checks validity of an EU VAT number and assigns a tax class accordingly. you can test it on our store at www.360tacticalvr.com
Going to sound stupid, but if I upload a csv file to magento using the “import tax rates” feature it says “successful” but then there arent any rates set up or anything? I dunno how to attache the file to show you it tho…
Note that Isle of Man attracts normal VAT as if it was Hampshire. So as explained clearly there, you only need Jersey and Guernsey. Done in 10 minutes, brilliant. Thanks Karen @ WebShopApps
I’ll be checking out a few of the other must-have UK extensions too. The generic courier tracker is something I’ve wanted for ages.
Attached is the CSV tax table please have a look - BE WARNED I am not an expert and this is used at your own risk! ALSO if you open the CSV file in EXCEL you may run into problems. (i used a combo of excel and bbedit to get this to work)
I’d like to hear thoughts on the solution and if I’ve made any glaring errors!
Hi Guys,
I’m using Magento 1.4 and I’ve managed to modify the exported CSV spreadsheet to include all those tax rates you attached, which you can then import via Import/Export tax rates. It appears to work with Excel as long as the CSV is in “Comma Delimited” format.
It does appear to work fine in Magento, but there are 2 countries with invalid codes according to Magento. I’m just trying to figure out which ones! If anybody would like this CSV file, just PM and I’ll attach it.
On a separate note, somebody has also written a similar question on another forum; I have a UK store selling food for which some products like Crips and Nuts have standard 17.5% VAT on, and others, like the vast majority of food, are Zero Rated. I ship worldwide, so outside the EU everything is Zero Rated anyway.
The problem is, I have a bag of crisps for example which is £0.43 + VAT or £0.50 inclusive of VAT. This works fine for EU customers, but any customer outside the EU (because it’s all Zero Rated) pays £0.43. I’d normally still charge £0.50, but the way Magento is working it out means I’m losing 7p on every NON-EU Export.
