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 fieldTypeDescription
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