Search code examples
netsuitedata-migrationcountry-codesiso-3166

NetSuite data import with country code?


Question for the NetSuite experts:

Before my time, my current company decided to move to NetSuite. I'm being asked to retrieve customer data from our in-house SaaS and reformat it for import to NetSuite. Our NetSuite consultant says the customer import feature requires us to specify country by country name -- and, of course, NetSuite's built-in list of country names differs from our internal list which some developer pulled long ago from ISO 3166.

We asked the consultant why NetSuite doesn't import based upon two-letter ISO 3166 country code. He shrugged.

So, NetSuite experts, why doesn't Oracle allow for importing of customer data with two-letter ISO 3166 country code?


Solution

  • That's how system Architectured.

    The only way is to use country enumerations table for lookup and replace codes with country names.

    Ref: https://netsuite.custhelp.com/app/answers/detail/a_id/10888

    Country Enumerations