ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Import customer data with id


#1

Hi,
is there any option to import customers with there existing ID number, with the import tool in the UI?
when I try it, to enter a cust id in the excel file, it will be ignored by import.

Import direct in the sql DB works.
If there is no way to import the existing cust IDs with the excel sheet, is it a bad idea to import the data direct in the DB? (will it make problems in the future?)

Best regards,
Matthias


Is there a command line bulk rename?
#2

The Customer name is the primary key of Customer record in ERPNext. We don’t have Customer ID. You can put your existing IDs in the name column and they will be imported, but you won’t get the Customer name in Link fields.