You can import Products/Services from text files or Excel spreadsheets directly into Xero using SaasAnt Transactions (Online) software.
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 - https://apps.saasant.com/eti-importer-login/index.html.
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.
SaasAnt Transactions (Online) Fields
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".