how can i map a customer by external id when creating a sales order using a csv import?

AI generated answer (using internal Slack threads):

To map a customer by external id when creating a sales order using a CSV import, you need to set the External ID as a key in your CSV file. This External ID should be unique for each customer to prevent duplication of sales orders. Here are the steps to do this: 1. Prepare your CSV file with all the necessary fields for creating a sales order. Make sure to include a column for the External ID. This ID should be unique for each customer and should match the External ID set in NetSuite for the respective customer. 2. In NetSuite, navigate to Setup > Import/Export > Import CSV Records. 3. Select the record type as 'Sales Order' and the import type as 'Add'. 4. Upload your CSV file and proceed to the mapping step. 5. In the mapping step, map the 'External ID' field in your CSV file to the 'External ID' field in NetSuite. Similarly, map all other necessary fields. 6. Save the mapping and proceed with the import. Remember, the system won't allow duplicate External IDs, so make sure each customer has a unique External ID. If you encounter any errors during the import, it could be due to issues with the CSV file formatting. Make sure the commas are visible and the file is properly formatted. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******