Address Settings: Address Formats

Address formats are standard formulas for shipping addresses and are associated with countries. iMIS comes with several out-of-the-box formulas that are already set up for you to use. You can Select to edit the out-of-the-box address formats, or you can add new ones.

Before you create a new address format, review one of the existing out-of-the-box formats as an example. Go to Settings > Addresses > Address formats.

The following address formats outlined in the table below are predefined for specific countries. For example, format 12 is applied to Bulgaria, format 13 is applied to Japan, and format 14 is applied to Korea. It is recommended that you review these formats to be sure that they fit your business needs. If necessary, you can modify the formats (change the format that applies to a country). For countries that have not had address formats applied to them, you must format address layouts and apply them to the countries.

Required address field formatting codes

Use the available fields to format the address layout (Country_Addr_Layouts.ADDRESS_LAYOUT). The formatted address layout combines the component fields of the address with four formatting codes:

  • [U] - Uppercase. Enter [U] before a component field to make the data in the field all uppercase. For example, [U]CITY would generate all capital letters for a city such as NEW YORK or LONDON.
  • [N] - New line. Enter [N] after a component field to insert a carriage return. For example, ADDRESS_1[N] would generate a carriage return and place the next component field on a different line in the address.
  • [S] - Space. Enter [S] after a component field to insert a space between component fields. For example, [U]STATE_PROVINCES[S][U]ZIP would display as TEXAS 75208 when generated in an address.
  • [C] - Comma. Enter [C] after a component field to insert a comma between component fields. For example, CITY[C][S][U]STATE[S][U]ZIP would display as Dallas, TEXAS 75208 when generated in an address.

Creating a new address format

Do the following to create a new address format:

  1. Go to Settings > Addresses > Address formats.
  2. Select Add address format:
    1. The Format field automatically populates with the next succeeding format code. For example, if the last format code created was 15, then format code 16 will be entered automatically in the Format field.
    2. Note: If a new format was created and saved with the number 15, and then later deleted, the next address format created will still be 16, and not 15 again.

    3. Enter a Description for the country address format.
    4. Begin selecting components to populate the Formula.
  3. Click Save.

Applying an address format to a country

Make sure the country you want to apply an address format to has been added to the Countries table.

Do the following to apply an address format to a country:

  1. Go to Settings > Addresses > Countries.
  2. Select the desired country.
  3. From the Address format drop-down, select the correlating address Format code.
  4. Click Save.

Best Practices & Troubleshooting

Review the following tips:

  • It is recommended to Purge System Cache after applying address formats to specific countries, as the changes may not immediately take effect.
  • When creating or editing address formats, copy and paste the code into a text editor to ensure no spaces or blank carriage returns are a part of the code. Format codes will honor all text including spacing. This may cause component field text, such as "[U]", to display in the address.