Part 1: Preparing Your File For Import
Doing imports of customer information is relatively easy in PayGo. It requires you have a file in one of several formats ready with your previous customer information. The formats recommended for your source file are as follows:
– Tab-separated text document (.tab or .txt)
– Comma-separated text document (.csv or .txt)
– Microsoft Excel document, preferably single sheet (.xls)
Popular field names in PayGo’s Customer database are as follows – The label is listed first, then the actual field name in PayGo:
Customer Name: Customer_Name
First Name: First_Name
Last Name: Last_Name
Phone Number: Phone_Number
Mobile Phone: Cel_Phone
Fax Number: Fax Num
Marketing Fields: m_field1 through m_field20
Record Type: Customer_Record_Type
You can prepare your file in advance by making the first line of your excel or text file be our field names above the columns of data. 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.
Part 2: Data Import
1. Start PayGo.
2. On the Main Menu – click “Find Customer”
3. 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.
4. On the button bar at the top of the screen, click the “Export Import” button.
5. A message will appear asking if you wish to Export or Import, click “Import”.
6. 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 (*.*)”
7. 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.
8. 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.
9. 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”.
10. 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.
11. 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.
12. 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.
13. 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.