Import and export taxes

To manage taxes easily, without having to create or edit one tax at a time, you can export and import taxes and their definitions using a CSV (.csv) file.

To import taxes, perform the following:

  1. Click Ecommerce » Taxes.
  2. On Taxes page, click More actions » Import Taxes.
  3. Select a CSV file from your computer and click Import.

To export taxes in a CSV file, perform the following:

  1. On Taxes page, click More actions » Export Taxes.
  2. Click Export.
    The CSV file is downloaded on your computer.

Format of the CSV file

To import taxes correctly, the CSV file that you upload must have the following columns:

  • Title (Required)
    In this column, enter the title of the tax, for example VAT.
    If you have only one language, the title column must have the following header: Title<Language=language code>
    For example, if your site is in English only, the title column header must be Title<Language=en>

    If you have more than one languages, you must add a title column for each language.
    For example, for English and French, the first two column headings must be Title<Language=en> and Title<Language=fr>

  • Based On (Required)
    This column defines whether the tax is based on the shipping or the billing address.
    It can contain values shipping or billing.
  • Country (Required)
    In this column, enter the country code, for which the tax is applicable. 
  • State (Required for US and Canada only)
    In this column, enter the state, for which the tax is applicable. 
  • City (Optional)
    Enter the city, for which the tax is applicable.
  • County (Optional)
    Enter the county, for which the tax is applicable.
  • From Zip (Optional)
    Enter a range of ZIP codes, for which the tax is applicable. 
  • To Zip (Optional)
    Enter a range of ZIP codes, for which the tax is applicable. 
  • Tax Rate (Required)
    Enter the tax rate in percentages.
    For example, for a 20% tax, enter 20
  • Apply To Shipping (Required)
    Enter TRUE, if the tax must be applied to the shipping costs.
    Enter FALSE, if the tax must not be applied to the shipping costs
  • Tax for additional tax classes (Optional)
    If you have created different tax classes, you can enter a different rate for each tax class.
    For example, if the standard VAT is 20%, but the VAT for books is 10%, you can create a tax class Books and apply different tax for books only. For more information, see Create tax classes.

    The header of this column has the following syntax: TaxClass-name of tax class-Rate
    The name of the tax class is the name of the tax class, used in the code. You can check this name by clicking Ecommerce » Tax classes. On Tax classes page, click the respective tax class and expand the Advanced section. You can see the name.

    For example, if your tax class is named Books and Drugs, the header of the column in the CSV file is TaxClass-books-and-drugs-Rate

  • Tax exempt (Optional)
    Tax exempt can be applied to a specific tax class. For example, if you have a tax class Books, in a particular country, books can be exempt from tax. In this field you enter TRUE, if the tax class is exempt from tax, and FALSE otherwise.

    The header of this column must be the following: TaxClass-name of tax class-Exempt

    NOTE: For each additional tax class, add another class tax column for rate and for tax exempt. Each tax class column for rate must be followed by a column for tax exempt. For example, if you have two tax classes – tax class Books, and tax class Drugs, you must have the following column headers: TaxClass-books-Rate, TaxClass-books-Exempt, TaxClass-drugs-Rate, TaxClass-drugs-Exempt.

Was this article helpful?

Next article

Tax classes