When we import Customer to ERPNext, we have to do three steps:
- Import Customer
- Import Address
- Import Contact
When we have customer list with a lot of sames names like below (for example, John are two different Johns, whereas Jack is the same person)
Name Address Contact
John Street 1 622 123
John Street 2 0812 345 678
Jack Street 3 722 0437
Jack Street 4 0877 123 445
in ERPNext, when we import with same Name,
then the ID will be like this
Jack (there is no Jack-1 because it’s the same person, i only import 1 record)
Then go to Step 2 & Step 3,
If I don’t know what’s the primary key of the names, how can I make street 1 to go to John and street 2 to go to John-1? and both street 3 & street 4 go to Jack?
The same also with Step 3.
If I only have 4 records, we can do it manually. But if we have 2,500+ records, we need to find automated way to do this from the Data Import Tool or maybe MySQL tool like phpmyadmin?
We have some ideas, but stuck how to link it & also how to use phpmyadmin to generate the auto numbers generated by the address title, something also like John, John-1, etc.
Can someone advise with this batch processing?
Thank you in advance.