Country Code in NetSuite from Shopify

While syncing orders or customers from Shopify to NetSuite, graphQL query returns Country Code from Shopify.

This country Code can be mapped directly to NetSuite Country code.

Setup > Company > State/Province/County

addresses 
{
    name
    address1
    address2
    company
    city
    country
    provinceCode
    zip
    phone
    countryCode
    firstName
    lastName
}

The Country Code can be matched with query in NetSuite:

let queryResults, sql;
sql = `SELECT id, name FROM country WHERE name = '${countryName}';`
queryResults = query.runSuiteQL({ query: sql }).asMappedResults();
if (queryResults[0].id) {
    sql = `SELECT id, name FROM country WHERE name LIKE'%${countryName}%';`
    queryResults = query.runSuiteQL({ query: sql }).asMappedResults();
}
let countryCode = queryResults[0].id ? queryResults[0].id : null;

Leave a comment

Your email address will not be published. Required fields are marked *