Fix Item Import Errors

Last updated
Save as PDF

This article applies to:Avalara AvaTax Update

To avoid errors when you import items, use these recommendations and best practices:

Try a trial import of a few items to increase your familiarity with the import process before importing larger numbers of items
Adhere to size limits for each data field. Find the size limit for each field in the Type (Size) column of the item import formatting table.
Be sure to enter a description in column B for each item. It can be anything you want, but it's required
Ensure tax codes in column C are either Avalara tax codes or custom codes that are already entered into your AvaTax account

When you finish adding your items, learn how to manage them.

If an import errors, an error file lists the rows that didn't import. All rows not listed in the error file imported successfully. Use the information in the sections below to troubleshoot errors.

Troubleshoot file imports

To troubleshoot file imports:

Go to Transactions > Transaction import history.
On the Transaction import history screen, in the Error File column for an imported file, click the Download icon. The Error.csv file downloads.
Open Error.csv and view the error message in the last column for each record that failed to import.
Make the necessary corrections to the records, and then delete the last column (the one with error messages).
Save the file with a new name and import it.

Item import error messages

When you import items, some records may result in an error that you need to troubleshoot. Item import error messages and their probable causes are listed below:

Error message	Error condition
'Text ' is not a valid ColumnName value.	One or more of the following conditions apply: If the indicated column is TaxCode, the text in column C isn't a valid tax code The indicated text in the indicated column has too many characters
There is missing or incorrect information. See Details below and complete the form. Input Header row missing or invalid.	One or more of the following conditions apply: One or more of the 3 required columns is missing One or more of the column headings is incorrect One or more of the column headings is missing
ItemCode is required.	There's no text in the ItemCode column.
Description is required.	There's no text in the ItemDescription column.
There is missing or incorrect information. See Details below and complete the form. The maximum number of records (100000) has been exceeded.	There are too many rows of data in the file. Files can't exceed 100,000 rows, including the heading row.