Importing customers through a CSV file allows you to take advantage of Simplesat's Email publish channel.
Preparing your import file
Head over to the Customers page and click Import customers.
To make sure data is imported correctly, we recommend starting our CSV template. You can find the link to download in the import popup, or get it here.
Working with the template CSV file
The template file looks like this:
Rows A-D (First Name - Company) will connect to core system data. Do not add columns or change the order of these columns - Simplesat looks at the column order to determine the field. (ie "Last Name" must be the second column)
The Email field is required. All other fields are optional and can be left blank.
You can include custom attributes with each customer record to use as rules for your audience.
Any data you include to the right of column D (Company) will be added as custom attributes.
Simplesat will look to the value in the header row to determine if the custom attribute exists. If it does, the existing record will be updated, if it doesn't a new custom attribute will be created.
The example below shows three custom attributes set:
Person type ,
Company status ,
Note: The CSV file needs to be saved using UTF-8 character encoding to make it work.
When ready, upload your CSV list through the import popup.
After you click Upload the import will begin. You'll receive an email after the import is complete.
Viewing imported customers
To check the data you imported, refresh the customers page and choose the customer you'd like to view.
You can see their details in the left column, including custom attributes.
Updating existing customers
Simplesat uses the customer's email address as their unique identifier.
To edit details for a customer who already exists in your account, upload another CSV file with a row including their email address. If the custom fields are blank, it will erase the data when you re-upload the file.