The import wizard can be used to add additional records to the database or to update existing records. Focus on manipulating your source data to ensure it meets the criteria NetSuite requires for each field. Convert the data in fields referencing picklist values to the internal ID corresponding with the appropriate picklist value.
We can only import one subtype of a record at a time, for instance, importing the inventory and assembly items will need to be done in two separate imports. We can import one file only or multiple files simultaneously, where the data is stored in different tables in NetSuite, such as customers and contacts.
NetSuite provides us with advanced mapping tools in addition to simply mapping a field from the source data to the corresponding NetSuite field. The mapping screen enables us to set default values and match picklist values based on internal ID. The NetSuite fields on the mapping screen are displayed in different folders. The first folder represents the...