The CSV file upload feature in Simple RM allows you to bulk import customers from other programs you use.
A comma-separated value (CSV) file is a commonly used file structure for transferring data. You can read more about CSV files here. CSV files can be generated by a program that holds data or they can be created from scratch using any spreadsheet program.
If you wish to export data from an existing program as a CSV, check the help documents of the program that currently holds the customer data for instructions on how to export it as a CSV file.
Regardless of how you create your CSV file the main thing to ensure is that it has the column names that Simple RM is expecting. The expected column names are listed below. If your CSV file does not currently use the exact same column names you must edit the file prior to doing the import.
|first_name||The first name of the customer||Optional. Although depending on your account settings you may not be able to trigger a review request for the customer without setting a first name.|
|last_name||The last name of the customer||Optional|
|phone_number||The phone number of the customer||One of either phone_number or email_address must be set in order to trigger a request|
|email_address||The email address of the customer||One of either phone_number or email_address must be set in order to trigger a request|
|assume_satisfied||Specifies if the customer is assumed to be satisfied or not||Optional. Acceptable values are yes or no. If not set the customer will get the default assume_satisfied value specified in your account settings|
|trigger_request||When creating this customer in Simple RM you can immediately trigger a request as well||Optional, acceptable values are yes or no|
How to upload a CSV file in Simple RM. These instructions assume your CSV file is already formatted correctly.
Go to the Customer Import page in the Simple RM admin.
Click the “Choose file” button located in the Create New Import section and select your CSV file.
Click the “Process file” button. When you do you will see a new import get created. Wait for the “Processing” status to change to “Complete”.
Once the “Processing” status to changes to “Complete” you will be able to see a report of everything that just happened.
You will see a table where each row represents a row from the CSV file that was successfully processed. The structure of that table is as follows.
|Customer Id||Processing Summary|
|The ID of the customer that was created or updated. Click on the ID to view the customer.||The exact row from the CSV that was processed. As well as a log of how the row was processed.|
Processing a CSV file can results in an error that stops the process. Errors can occur part way through processing so it is possible you may see an error message as well as a table of customers that were imported successfully before the error. If an error occurs, follow the instructions in the error message.
You may be wondering how the customer information in the CSV file will mix with customer information already in your Simple RM account. Data in the CSV file will supplement existing data in SRM. This means if a customer with matching information already exists in SRM then any piece of information that exists in the CSV but not in the existing customer will be added. However, no information that already exists will be overwritten by values that are different in the CSV. For example:
email_addressas a customer in the system, but a different
first_namethen no new customer will be created and the
first_nameof the existing customer will remain unchanged.
last_namebut the CSV does. The
last_namewould get added to the customer in SRM as part of the import. The reason the
last_namegets added while nothing happens for the
first_nameis that the
last_nameis only adding to the additional information rather than overwriting existing information.
Note that because
trigger_request columns always have a value, those two columns will only ever affect new customers.
trigger_request column in the CSV file is a great way to take care of two tasks at once. If you choose to not include this column you can still trigger requests for customers any time on the Customers page.
For optimal results with your review requests try to only send them to customers you have done business with in the last 60 days.
At this time we are limiting customer imports to 2500 customers. Contact support if you wish to import a CSV file with more than 2500 customers.