Luis
10/15/2024, 2:13 PMCeligo AI
10/15/2024, 2:13 PMAI generated answer (using internal Slack threads):****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Here is a step-by-step guide on how to import a new address to a group of existing customers using CSV: 1. Prepare two CSV files. The first file (File 1) should contain all the customer fields you want to set other than Address fields. The second file (File 2) should contain all the addresses you want to import with 1 address per line. 2. Link the two files together using a common field. This could be the External ID or any other unique identifier that is common to both files. 3. In NetSuite, navigate to Setup > Import/Export > Import CSV Records. 4. Select the record type as 'Customer'. 5. Choose 'Multi-File' as the import type. 6. Upload File 1 and File 2. 7. During the import process, NetSuite will ask you what field you want to use to link the files together. Choose the field you used to link the two files in step 2. 8. Map the fields in your CSV files to the corresponding fields in NetSuite. 9. Review your mappings and start the import. 10. Once the import is complete, the new addresses will be added to the existing customers. Remember, each address must have a unique label. Also, if the 'header' (other customer) data isn't clean, you might end up accidentally creating other customers and duplicate addresses. It's always a good idea to double-check your data before starting the import.
Celigo AI
10/15/2024, 2:13 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.849405348
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847893178
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839917719
Celigo AI
10/15/2024, 2:13 PM