Menu Close
Knowledge Base

How to Import Customers into PayGo

You are here:
< Back

How to Import Customers into PayGo

Do you have customer information that you’d like to import into your new PayGo POS software?

In this article you’ll learn how to import customers into your PayGo POS software.

Importing Customers into PayGo Part 1

To import customers into your PayGo POS software, you’ll need to have your customer information in one of the following file formats:

  • Comma-separated text document (.csv or .txt) 
  • Microsoft Excel document, preferably single sheet (.xls)

Below is a list of different types of customer information that you can enter into your PayGo POS Software. Following the information type is the field name. Use the field names as the title of the associated column of data in your excel or text file. For example, in the first line of your column of customer first names, you would enter: First_Name

In a tab-separated or comma-separated text document, the field names would be the first line, then a tab (or comma) then another field name, etc. all the way across the first line of your file.

Types of Customer Information and Their Field Names

Company Name: Customer_Name

First Name: First_Name

Last Name: Last_Name

Address: Address

City: City

State: State

Zip: Zip

Country: Country

Email: Email

Phone Number: Phone_Number

Mobile Phone: Cel_Phone

Fax Number: Fax Num

Targeting Data:

Marketing Fields: m_field1 through m_field20

Birthday: Birthday

Record Type: Customer_Record_Type

Representative: Representative

Comments: Comments

Part 2: Data Import

  • Start PayGo.
  • On the Main Menu – click “Find Customer”
  • For the find request, leave all the fields blank and click the “Find” button – this will bring up every customer record. If you do not have any customers in your database this will come up with no results, so create at least one customer with “New Customer” and try it again.
  • On the button bar at the top of the screen, click the “Export Import” button.
  • A message will appear asking if you wish to Export or Import, click “Import”.
  • A file window will appear asking for the location of your source customer file we made earlier in the document. Locate this file and click Open. If you notice your file is not showing, make sure that the “File Types” box (on Windows) below shows “All Files (*.*)”
  • A window will appear named “Import Field Mapping” – this window allows you to match up the field names of your source data on the left panel to the field names of our point of sale software in the right panel. Make sure you followed the instructions earlier in this document and named your source fields in your file according to the names our software uses. This saves quite a large amount of time.
  • On the bottom of this window, there is a checkbox that says “Don’t Import First Record (Contains Field Names)” – Since your source file should had field names matched to ours already, we will select this checkbox.
  • In the middle of this window on right side, there is an “Arrange by:” label with a drop-down menu next to it. In this drop-down menu, select “matching names”.
  • In the field mapping area above, the software should have just matched up the “Source Fields” to the “Target Fields” with an arrow pointing across to the other side to denote that data is moving across. If it does not match your fields, double check your source file to make sure the names match ours, and try again.
  • There is a set of buttons labeled “<<” and “>>” which allow you to scroll through a few sample records before going ahead with your import, check and see if your data matches up – then take the plunge and hit the “Import” button.
  • On the “Import Options” dialog that appears, make sure “Perform auto-enter options while importing” is checked. This generates relevant customer IDs and other information for you and is very important.
  • The software will attempt to perform your import and should inform you how many new customers were imported after it is finished.

PayGo is a solution provider for independent retailers based in Rochester, Minnesota. Our primary focus is on point of sale / retail management software. We also offer a Merchant Account integration, a WooCommerce integration, Digital Marketing Services, and more.]]>

Still Stuck? We're Here to Help!

Previous How to create Loyalty Programs (aka Frequent Buyer Programs) in PayGo
Next Importing Customer Information Into PayGo
Table of Contents