You must use the column heading labels exactly as shown below in the import file. The individual data fields must conform to the type and size restrictions listed in the table. All columns in the item import file are required, as noted by the Use column.
|Column||Column Heading||Type (Size)||Use||Description|
|A||Item||Text (50)||Required||A unique identifier for the product, service, or charge.|
|B||ItemDescription||Text (255)||Required||A comment associated with an item that describes the product, service, or charge.|
An Avalara tax code or custom tax code indicating the category of product, service, or charge.
Every item imported must have a tax code assigned to it. If an item's tax code field is left blank during import, AvaTax Update assigns tax code U0000000. Items with a tax code of U0000000 should be properly mapped to an Avalara tax code or a custom tax code or else AvaTax will treat it as fully taxable Tangible Personal Property (TPP).