Fix Item Import Errors
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:
|
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:
|
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. |