Importing a Customer File

The Import Customer File utility can be used to import new customers.

Existing Customers cannot be updated by this utility

1. From the Main Screen of Retailer, click Utilities -> Import / Export Files -> Import Customer File
   
2. In Customer File Type, enter a name for the Customer File template. If the template has previously been created, select it from the list.
   
3. If you wish for all details to be uppercase (NAME, ADDRESS, etc) tick Convert all customer details to uppercase
   
4. Select a default Statement Type from the list. All imported customers will have this Statement Type set
   
5. Select a default Account Category from the list. All imported customers will be placed in this Account Category
   
6. Click Import
   
1. If this is the first time importing a customer file using the selected template, the Customer File Setup screen will appear. Enter a number next to each field that corresponds to the column in the file . Click Save.
   
2. If the selected template has changed, click the down arrow next to Tools and click Change Customer File settings
   
7. Select the Customer File to import. Files need to be in CSV or TXT formats
   

• Related Articles

• Importing Centrepay file

  Setting up CentrePay From the main menu screen of Retailer, click Customers in the menu at the top and then Batch Payments. Click Import and then CentrePay Setup. In Import Payment Type select from the drop down which paytype should be used for ...

• Importing Batch Payment file

  In Retailer 3.2, a feature was introduced that allowed you to make batch payments to customers. This can be done through the Batch Payment screen in Retailer. The file needs to be saved onto your computer first. This can be any CSV file with the ...

• Importing a Simson Cards Stock File

  This is the advice for importing a Simson card stock file. The stock file is embedded in this article. Do not try this with another stock file. The stock file included with this article has been tested. We know it works . Saving the Stock File Click ...

• Importing a Henderson Greetings Stock File

  This is the advice for importing a Henderson Greetings stock file. The stock file is embedded in this article. Do not try this with another stock file. The stock file included with this article has been tested. We know it works. Saving the Stock File ...

• Importing a Catalogue File

  NewsXpress / GNS / ANCOL / Newspower have the ability to provide you with a catalogue file that negates the need for you to set it up manually. These catalogue files can save you tremendous amounts of time during busy trading periods such as Back to ...