Tip: Importing Tax Rates
Over the past few months, our support team has provided assistance to numerous customers on the issue of taxes on an almost daily basis. In this post we will describe a couple of tips that will prevent having issues with configuring taxes prior to launching your store in a production environment. Defining tax rates and zones is typically taken care of right before launch and such an effort and configuration is typically specific to your business requirements and rules.
Importing tax rates using the CSV import has been a frequent issue. Normally when creating the CSV file to import, users were editing with Microsoft Excel. Since Magento requires all the strings in the CSV file to be enclosed with double quotation marks and Excel removes these, Magento will not read the CSV file properly (this is applicable to all CSV import files in Magento).
Example of files edited in Excel (when opening on notepad or any other text editor
Code,Country,State,Zip/Post Code,Rate,default US-NY-12007-Rate 1,US,NY,12007,4, US-NY-12009-Rate 1,US,NY,12009,4, US-NY-12023-Rate 1,US,NY,12023,4, US-NY-12041-Rate 1,US,NY,12041,4,
Proper file format with double quotation marks
"Code","Country","State","Zip/Post Code","Rate","default" "US-NY-12007-Rate 1","US","NY","12007","4", "US-NY-12009-Rate 1","US","NY","12009","4", "US-NY-12023-Rate 1","US","NY","12023","4", "US-NY-12041-Rate 1","US","NY","12041","4",
If you need to apply tax to the shipping fees, please keep in mind that Magento’s default setting is the complete opposite. This however can be modified by selecting on the dropdown located under System> Configuration > Sales > Tax > Tax Classes > Tax Class for Shipping the desired tax class for your selected carriers fees.
While the tips described above may be applicable to a wide audience, as previously mentioned configuring and managing your store taxes sometimes may require advanced settings depending on your business specifics.