Import/Update customers
Navigate to Administration > Customers > Import / Update to import or update customers in bulk. This module allows you to upload a CSV file with customers and customer data. This makes it possible to both update existing customers and to create new ones from a external source.
The file must be in CSV format and use ; as separator.
The columns in the file must follow the example below. At the bottom of this article there is a template that can be downloaded and used.
Update customers
To download a list of customers the Segmentation tool can be used. Create a segmentation, click Export results and choose Download with all customer data. This list follows the correct format to be imported.
Change the desired field in Excel and upload the file back to Tixly.
Add new customers
To add a new customer to the list, create a new row and give it the Customer ID 0. When the list is imported, the system will generate a Customer ID for the new customer.
If you change an existing Customer ID, this will update the customer with the ID that is input. Therefore the Customer ID should never be changed.
Upload CSV file
Click Browse, select the correct file and click Upload.
In the next view, an overview of all changes will be shown. To approve them, click Confirm customer upload or click Cancel to stop.
- Yellow cell in the table means that the value in the cell will be changed (e.g. new email).
- A Green row means that a new customer will be added.
- Blue box shows number of customers that are being uploaded.
- Yellow box shows number of customer cards that will be changed.
- Turquoise box shows number of customer cards that will not be changed.
- Green box shows how many customers will be created.
After clicking Confirm, wait until the message Customer successfully imported! is shown together with a thumbs up!
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article