How are people populating the state field in a shi...
# suitescriptc
Craig
11/09/2021, 9:35 PMHow are people populating the state field in a shipping address if the source data (ecommerce) doesn't match the exact name of a state in NS? For country, you just use the ISO code, that doesn't exist for state names in various countries.
l
Livio
11/09/2021, 9:35 PMMaybe cause its a text field - it doesnt need to match anything
c
Craig
11/09/2021, 9:37 PMIn NS it's a dropdown
Craig
11/09/2021, 9:37 PMSo must be some sort of ENUM in NS
b
battk
11/09/2021, 9:44 PMbattk
11/09/2021, 10:02 PMits one of the things thats easier using N/query
battk
11/09/2021, 10:03 PMthough the kind of work that requires transforming non matching values usually is a hardcoded lookup kind of deal
s
stalbert
11/09/2021, 10:40 PMwe tend to use a hardcoded enum generated from a SuiteQL query of the states configured on a NS account. Since states change infrequently we deem it a reasonable tradeoff. For those that don't you can just repeat/cache search results.
stalbert
11/09/2021, 10:41 PM