2.2 Upload new customers

The following fields are supported for import of customer data. Note that a customer may have up to 3 payment methods on file (for auto-pay), so this could be a combination of (say) 2 credit cards and 1 bank account. The total number of payment methods should not exceed 3. In the table below, the

If tokenization is supported by your selected 3rd party payment processor and you have existing customers with tokenized payment methods on file, then use only the tokenization fields starting on No 72 below and not the credit card or ACH fields. For example if a customer had a single credit card that was tokenized by your payment processor, then populate the customer data (fields 1-26) and the 1st tokenization record (fields 72- 82).

Fig 11.1 shows how to download template for customer

3. Fill the applicable below fields as per the template

4. Save the template on your desktop and upload it into the system.

Notes when working with Excel:

Figure 11.0 - Get External Data, Text

After clicking From Text, select your text file from the Import Text File dialog and click Open. This launches the Text Import Wizard. There are three pages to complete. The first page is essentially to determine whether the file is to be considered Delimited or Fixed Width. The second page depends upon the first. You will be asked what characters to consider as delimiters or asked to choose the widths of a fixed width file.

Figure 11.1 - Text Import Wizard: 3 of 3

The third page is what is going to help you determine the format of each field. Select your account id field from theData preview at the bottom then select Text from the Column data format list in the upper left. Note that the header of the field in the bottom Data preview has changed to Text. Repeat for any other fields and click Finish in the lower right to complete your operation.