Setting Up Tax Rates in Magento Go via Import/Export

Setting proper Tax rates in Magento Go can be pretty frustrating, especially if you need to set up different tax percentages settings per zip code (or zip code range). And for some reason, Magento Go does not come with the default tax settings and they don't maintain the list. Luckily, Magento Go has feature to export tax settings, edit the rates in Excel, and then import them back. Sounds great?

Export existing Magento Go tax rates


To export your tax file, go to Sales → Tax → Manage Tax Zones & Rates


Open the file in spreadsheet editor you like, add more tax rules and export the file back to CSV. When you export CSV from Office, then by default the CSV contents looks like normal CSV:

Code,Country,State,Zip/Post Code,Rate,Zip/Post is Range,Range From,Range To,default
US-CA-*-Rate 1,US,CA,*,8.5,,,,
US-NY-*-Rate 1,US,NY,*,8.375,,,,

However there is a catch - if you try to import the modified file, it won't work.

How to import tax rates properly

You need to format the CSV file with all the fields double quotation marks. I used OpenOffice to export the CSV, and checked setting "Quote all text fields".


After doing that, the file looks like this:


"Code","Country","State","Zip/Post Code","Rate","Zip/Post is Range","Range From","Range To","default"
"US-CA-90680","US","CA",90680,8,,,,
"US-CA-92656","US","CA",92656,8,,,,

Notice the difference? Now when you import it again, Magento Go will accept newly formatted file.

For those who need to get their Magento Go store to apply tax rate for products, here is example CSV file for tax rates in Orange County, CA.

Location: New York, NY, USA

Comments

Post a Comment

Popular posts from this blog

Stubbing and Mocking Static Methods with PHPUnit

Image
PHPUnit has ability to stub and mock static methods. Consider the class Foo : <?php class Foo { public static function doSomething() { return static::helper(); } public static function helper() { return 'foo'; } } ?> To test the static helper() function with PHPUnit, you can write you test like that: <?php class FooTest extends PHPUnit_Framework_TestCase { public function testDoSomething() { $class = $this->getMockClass( 'Foo', /* name of class to mock */ array('helper') /* list of methods to mock */ ); $class::staticExpects($this->any()) ->method('helper') ->will($this->returnValue('bar')); $this->assertEquals( 'bar', $class::doSomething() ); } } ?> The new staticExpects() method works similar to the non-static expects...
Read more

MongoDB: Remove an Arbiter From a Replica Set

Image
Removing an arbiter from MongoDB Replica Set can be quite tricky, and official MongoDB documentation does not say it directly how to do it. I assume that you have auth enabled (just like I have), so lets start with connecting to your ReplicaSet "repl" master as an administrator: mongo mongo.domain.com/admin -u admin -p pass You will see the following prompt: repl:PRIMARY> Type in conf=rs.conf() repl:PRIMARY> conf = rs.conf() { "_id" : "repl", "version" : 8, "members" : [ { "_id" : 0, "host" : "mongo.server.com:27017", "priority" : 2 }, { "_id" : 1, "host" : "mongo1.server.com:27017" }, { "_id" : 2, "host" : "arbiter.server.com:27017", "arbiterOnly" : true }, { "_id" : 3, "host" : "mongo2.server.com:27017" } ] } Now lets adjus...
Read more

Enable HTTP/2 Support in AWS ELB

Image
This thread  was started more than a year ago, asking for when Amazon Web Services will add support for HTTP/2  into their ELB. In addition to that, people are also asking, how to configure ELB to support multiple SSL certificates. AWS support team has been reluctant on giving out any specific details on when both of these features will be available, citing: I've verified that the ELB team is aware of the interest in ELB supporting HTTP/2. Please keep an eye on What's New from Amazon Web Services: http://aws.amazon.com/new/ for any updates. What is HTTP/2? HTTP/2 is a replacement for how HTTP is expressed “on the wire.” It is not a ground-up rewrite of the protocol; HTTP methods, status codes and semantics are the same, and it should be possible to use the same APIs as HTTP/1.x (possibly with some small additions) to represent the protocol. HTTP/2 protocol is supported by major modern browsers including IE11, Edge 13, Firefox 47, Chrome 52, Safari 9.1, Opera 38, ...
Read more