Skip to main content
Avalara Help Center

Guidelines for the item and tax code import template

This article applies to:Avalara AvaTax Update

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.
C TaxCode Text (25) Required

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).

  • Was this article helpful?