ANS-1776 · CSV IMPORT & DATA MIGRATION
How to Import Multiple Vendor Addresses into NetSuite Using CSV?
Learn two methods for efficiently uploading vendor address data, either by linking multiple CSV files or by structuring a single flat file with unique address labels.
Short answer
NetSuite allows importing multiple vendor addresses using two primary methods. Users can upload multiple CSV files, linking them via a common column. Alternatively, a single flat file can be used by creating unique column headers for each address (e.g., 'Address 1', 'City 1', 'Address 2', 'City 2') and utilizing the '+' option during mapping to add multiple addresses.
Scenario
Organizations often need to import comprehensive vendor data into NetSuite, which frequently includes multiple addresses for a single vendor, such as billing, shipping, or alternate locations. Manually entering each address can be time-consuming and prone to error, necessitating an efficient method for bulk data upload.
Solution
NetSuite provides two primary methods for importing multiple vendor addresses efficiently:
Using Multiple Files:
This method involves uploading vendor address information together with the primary vendor details using separate CSV files. A linked column must be present in the CSV templates to establish the relationship between the two files.
Using a Single Flat File:
Alternatively, all vendor address data can be included within a single flat file. To achieve this, additional columns must be inserted into the CSV, and the address labels must be renamed to ensure uniqueness for each address set. During the mapping process in NetSuite, the '+' symbol should be used to add multiple addresses.
Example of unique address labels in a flat file:
Address 1 City 1 State 1 etc… Address 2 City 2 State 2 etc…Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support