How does Sterling Order Management System Software identify the leaf region for a given postal code?

A region can represent a set of postal code ranges. Sterling Order Management System Software selects the region that includes the required postal code as part of its set. Since multiple regions could include the same postal code, conflict resolution is done in the following manner:

  • The region definition having the maximum significant digits in the range is given the highest preference.
    • For example, region R1 has specified a range of 901-902 whereas region R2 has specified a zip code range as 90101-90103. When looking for a postal code of 90101, 90102 or 90103 - R2 is selected as the correct region. When searching for any other postal code between 901-902, R1 is selected as the correct region.
  • The region having the least range is given a higher preference.
    • For example, region R3 has specified a range of 90101-90220 whereas region R2 has a zip code range specified as 90101-90103. When looking for postal code of 90101,90102 or 90103 - R2 is selected as the correct region. When searching for any other postal code between 90101-90220, R3 is selected as the correct region
  • The starting postal code closest to the required postal code is given a higher preference.
    • For example, region R4 has specified a range of 90099-90102 whereas region R2 has specified a zip code range as 90101-90103. When looking for a postal code of 90101 or 90102, R2 is selected as the correct region. When searching for any other postal code between 90099-90100, R4 is selected as the correct region.