When importing customer data via CSV into Kolleno, the system relies on the customer_id field to correctly identify and update existing customer records.
If the customer_id in the CSV file does not match the one already stored in Kolleno, the platform will treat the record as a new customer instead of updating the existing one.
This mismatch can result in duplicate customer profiles appearing in your customer list.
Example Scenario
Let’s say you upload a CSV file with customer records. For one customer, instead of updating the existing profile, the system creates two separate customer because the customer_id values did not match:
CSV ID:
cust_abc123xyz→ Generated from the CSV importCSV ID: aaaaaa-bbbb-cccc-dddd-xxxxxx→ Pre-existing in Kolleno
Since these IDs do not match, Kolleno assumes they are two different customers.
By contrast, if the CSV contains the same customer_id already stored in Kolleno, the import will correctly update the existing profile instead of creating a duplicate.
How to Prevent Duplicate Customers
To avoid creating duplicate profiles:
Check the customer_id column in your CSV file.
Ensure it matches the IDs already in Kolleno.
Align your CSV values with Kolleno IDs.
If you’re updating existing records, copy the exact IDs into your CSV file before importing.
Re-upload the corrected CSV file.
The system will then update the existing profiles rather than creating new ones.