State and Province Names for CSV Import
State and province names in CSV files need to match Short Name values listed at Setup > Company > States/Provinces/Counties.
NetSuite provides initial system lists of names for several countries. You can add custom states and provinces at Setup > Company > States/Provinces/Counties > New.
If an imported CSV file includes state or province names that do not match current system or custom names, the import job returns an error like “Invalid state state_name for country country_name ”. If you receive this error, review state and province names in your file, and either make corrections to the file or make additions to system States/Provinces/Counties.
If a CSV file includes the full names for states or provinces rather than short names, the import job may complete, but state or province values may not be saved correctly. To avoid errors, use short names. For example, importing full names for the Shipping Address Country field in transactions can prevent later calculation of shipping costs.
Related Topics
- Tips for Successful CSV Imports
- Sublist Data Import
- Importing Subrecord Data
- Supported Subrecord Imports
- Effects of Auto-Generated Numbers during Imports
- General CSV File Conventions
- Tips for Using Numbers in CSV Files
- Boolean Values in CSV Files
- Avoiding Errors for Commas and Other Delimiter Symbols within CSV File Fields
- Delimiters for Hierarchical and Multi-Select Fields
- Name References
- Country Names for CSV Import