Import/Update customers

Navigate to Administration > Customers > Import / Updatto 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.

Sk_rmavbild_2020-06-15_kl._13.34.43.png

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.

Sk_rmavbild_2020-06-15_kl._13.41.56.png

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.

Sk_rmavbild_2020-06-15_kl._14.02.55.png

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article