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:
To export taxes in a CSV file, perform the following:
To import taxes correctly, the CSV file that you upload must have the following columns:
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>
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
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.
Back To Top