Create Customers by Mass Upload
The customer Mass Upload feature is designed to let you create new customers en-masse within the database. In addition to that, if you've already downloaded the customer Mass Download spreadsheet the Customer Mass Upload will let you update the sheet along with any modifications that have been made.
Adding customers using the Mass Upload template
To add customers using the Mass Upload template you will need to use the following process:
- Download the template from Retail Express
- Add your customer data to the template
- Upload the template into Retail Express
Click on the headings below for detailed information on each step.
Download the Excel template
Downloading the Customer Mass Upload Excel Template downloads a blank file ready for adding new customers.
Tip: To update existing customers en-masse (downloading the details into an Excel file for modification) refer to the Customers - Edit Customers by Mass Download article
To download the Customer Mass Upload template:
- Log into Retail Express
- Navigate to CRM > Customers Mass Upload
- Select the File Format depending on the version of Excel you're using
- Click Get Excel Template
The template will be downloaded to your computer.
Adding Customers to the Excel Upload Template
To add your customers to the Excel Upload Template:
- Open the file downloaded in the previous step
- Click Enable Editing to unlock the file so you can make changes
- Information on each field can be found in row 7 and 8 i.e. the type of values it accepts and the character limit
- Enter the details for your customers as required
Note: To create a new customer successfully ensure the FirstName and Surname fields are populated and the Customer UID and Customer Number fields are blank - Save the file
Note: Make a note of the location of the file as you will need to find this file in the next section)
Proceed to the next section for information on uploading the file.
Upload the Excel template (update customers)
To upload the Customer Mass Upload Template file:
- Log into Retail Express
- Navigate to CRM > Customer Mass Upload
- Click the Upload Excel tab
- Click Browse for File
- Navigate to where you saved the file and click Open
- Click Upload
- A progress bar will be shown while the upload is processed
- The system will advise when completed
Frequently Asked Questions
Errors with the upload are commonly related to special characters such as question marks, comma's, dollar signs and other special characters. These are not accepted within customer creation and need to be removed before re-attempting the upload process.