Step 1: Export the Magento Tax Rate Data

1. On the Admin menu, select Sales > Tax > Import / Export Tax Rates.
2. Click the Export Tax Rates button. When prompted, click Save. Then, open the exported file in
OpenOffice Calc.

3. In a second instance of OpenOffice Calc, open the new tax rate data, so you can see both, side
by side. The basic Magento tax rate data includes the following columns:

  • Code
  • Country
  • State
  • Zip/Post Code
  • Rate

4. In the new tax rate data, take note of any additional tax rate data that you might need to set
up in your store before the data is imported. For example, the tax rate data for California also

  • TaxRegionName
  • CombinedRate
  • StateRate
  • CountyRate
  • CityRate
  • SpecialRate

If you need to import additional tax zones and rates, you must first define them from the
Admin of your store, and update the tax rules as needed. Then, export the data, and open the
file in OpenOffice Calc, so it can be used for reference. However, to keep this example simple,
we will import only the standard tax rate columns.

Leave a Comment

Your email address will not be published. Required fields are marked *