Import inventory items into Xero

You can import items (inventory items) into Xero from text, Excel and IIF files into Xero using Zed Axis.  Follow these steps:
  1. Open Zed Axis and connect to your Xero company file
  2. Click on the import tab
  3. Browse to the file that you wish to import into Xero
  4. Create a map between the columns in your import file and the corresponding fields in Xero, a detailed explanation of the fields are included below.
  5. Click import and your data will be imported into Xero as inventory items.
Here is a description of the fields that you can import on an inventory item.

Xero field Type Description
Code   The user defined code
Description   The description of the item
Purchase Unit Price   Purchase price of the item
Purchase Account Code   Account code to be used when purchasing item
Sales Unit Price   Sale price of the item
Sales Account Code   Account code to be used when selling item

Add Feedback