Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Login  Sign up

How to Import Products/Services into Xero

You can import Products/Services from text files or Excel spreadsheets directly into Xero using SaasAnt Transactions (Online) software.

 Pre Requisites

Connect your Xero account to SaasAnt Transactions (Online) App from Xero App Marketplace by clicking the "Get this app" button and get the 30-day free trial [No credit card required]. Alternatively, you can log in with your Xero account directly through this link -

Steps to Import Items into Xero

To import Items into Xero using the SaasAnt Transactions (Online) application, follow the steps below.


Step 1: Click on the "New Import" Menu to upload your file.

Step 2: Select your file and spreadsheet which has the Item that you want to import.

Step 3: Select Item as the Xero entity.

Step 4: Set up the mapping of the columns in your Item import file to the corresponding fields in Xero.

Step 5: Click Import and your Item will be directly added to your Xero account.


Please refer basics of field mappings for more info. If you have any confusion or doubts, feel free to drop an email to

SaasAnt Transactions (Online) Fields

Field Name



Item Name

150 Characters

Name of Item

Item Code

30 Characters

User-defined alpha-numeric code for Item

Inventory Asset Account 


Inventory account name for the item

Is Tracked As Inventory


True if the item is tracked as inventory

Is Purchased


If the item is for purchasing, set the value as “True” 

Is Sold


If the item is for sales, set the value as “True” 

Purchase Unit Price


Purchase unit price for the item

Purchase Account


Purchase account for the item

Purchase Description


Purchase description for the item

Purchase Tax Type


Purchase tax type for the item

Cost of Goods Sold Account


Account used for inventory purchase

Sales Unit Price


Sales unit price for the item

Sales Account


Sales account for the item

Sales Description


Sales description for the item

Sales Tax Type


Sales tax type for the item


Possible Failures & Troubleshooting Tips

Price List Item with Code already exists

A product/service already exists in Xero with the given "Item Code". To save a new Item, please change the "Item Code".

Click here to start a Free Trail.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.