Importing a file is a fast way to get your customers into ONE UP. 

  • Your file should be formatted as a table and must include a header that defines the fields. 
  • Import files must be in csv format (comma delimited)
  • Some headers are required: Company Name if you import a Company, Last Name if you import individuals.

Spreadsheet programs like Google™ Docs Spreadsheet and Microsoft Excel make it easy to create and edit CSV files. Use the attached .CSV file for all of the columns you can import.

Import your customers in Sales - Customers - green button - Import Customers: Import Customers and Customer Contacts

 

After your customers are imported, you can view them with View Customers and View Customer Contacts.

 

The attached template shows an example of how to import customers, their contacts and also an individual customer that is no company.

 

Please note that the import file also contains some useful information at the bottom. Before importing your records, please remove the whole all lines after your last customer data to get rid of this information block.

If the lines are not removed before import, OneUp will produce an error message and won't let you import your file.

 

Was this article helpful?
7 out of 8 found this helpful

Need more help? Ask an expert!

Click here to submit a support request to a ONE UP expert.