Location Import
Locations can be used to categorize records according to geographic area. You can use the Import Assistant to set up and update location records in your NetSuite account.
Before you can import locations, an administrator, or another user with permission to enable features, must go to Setup > Company > Enable Features, and on the Company subtab, check the Locations box and click Save.
After you have imported location records successfully, you can review them at Setup > Company > Locations.
If you plan to import other record types that include fields referencing location values, complete the import of locations first.
Location body fields for which data can be imported include Name, External ID, Sublocation of (the parent location if any), whether the location is inactive, and a transaction prefix field you can use to make auto-generated transaction numbers independent per location. (Transaction prefix values can be up to 8 alphanumeric characters.) If you are using NetSuite OneWorld, the Subsidiary field is also available.
The location import supports the import of multiline sublists. When importing a file where the sublist data contains multiple lines for each sublist item, you should include an external ID for each location record to uniquely identify the record the sublist data belongs to. For more information, see Multiline Sublists for CSV Import and Import Format and Mapping Considerations in Importing Sublist Data in a Single File.
As of Version 2015 Release 2, fields formerly in the Address sublist for Location are mapped as body fields, and fields formerly in the Return Address sublist are structured as a subrecord. By default, the Address body field is read-only, and data from other related body fields is copied into it. If you map the Override body field and set it to Yes (meaning true), you can import data for the Address body field. Similarly, the Address field in the Return Address subrecord is read-only, and data from other related subrecord fields is copied into it. If you map the Override subrecord field and set it to Yes (meaning true), you can import data for the Address subrecord field.
Supported Location Sublist Imports
The Location import supports the import of the following sublist data:
|
Sublist |
Notes |
|---|---|
|
Translation |
When the Multi-Language feature is enabled. You can map multiple instances of this sublist to import translations for multiple languages. Selectively updatable based on the Language key field. |
|
Business Hours |
You can map multiple instances of this sublist to import more than one set of business hours. For information about setting up business hours, see Defining Store Business Hours. |
Every sublist on each record can optionally have a separate file. For imports that update existing Location records, handling of sublist data updates depends on the setting for the Overwrite Sublists advanced option, and on whether the sublist is keyed. Complete deletion of sublist data currently is not supported. For more information, see Sublist Data Import.
For more details about fields that can be mapped in the Location record, see the SOAP Schema Browser’s location reference page. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.