Foreign Countries

The foreign country table defines the correspondence between country codes and country names. The table also includes additional information for each country, such as a region number, a default shipping class, and where the postal code should appear in relation to the city name on the address label.

When you enter the address of a US or Canadian customer QuickFill can automatically determine what the country code is based on the state code that you enter. However when you enter the address of a foreign customer you must enter 'ZZ' in the 'state' field and one of the defined country codes in the 'country' field. QuickFill then automatically displays the full country name corresponding to the country code.

Every country can be assigned to one of six regions.  When you create your database QuickFill will by default put the United States in region 1, Canada in region 2 and all other countries in region 3.  The purpose of these regions is to allow you to set up a price schedule that varies by region. For example you might have one price for North American subscribers, one for Central and South America, one for Europe and another for the rest of the world.  The names of the regions are defined on the General tab of the Preferences screen.

Just as you have different prices for different regions you may also have delivery methods that vary from one country another.  Your US and Canadian subscriptions may be delivered by first class mail, while subscriptions to other countries may be delivered by a variety of different couriers.  You can set up a shipping class code for each of these different delivery methods and specify in the country table what the default shipping class should be for each country.

To view or edit the definition of  a country scroll to the country in the list and click the "Change" button.  To define a new country click the "New" button, or you can base the definition of your new country on an existing country by using the "Replicate" button.  To delete a country's definition select the country in the list and click the "Delete" button. You can merge countries by changing the country code of one country  to match that of another existing country.

If you delete country names from the list you may end up with customer records that use the deleted country code.  Similarly, if you import prospects and subscribers on a regular basis and there are any errors in the country codes or names for foreign customers, you will end up with mismatched country codes in your customer addresses.  For example, your country table may list the country code for Germany as DE, but you may have imported customer addresses with a code of GER.  To detect any customer addresses with country codes that do not match their country names, run the 'Mismatched country codes' report.  Click here for further information on the 'Mismatched country codes' report.

These are countries that actually are part of the postal system of some other country. For example, Puerto Rico has its own ISO country code, but its mail is delivered through the US postal system and it should be addressed like all US mail with a state code and zip code. Another example: Scotland doesn't have its own ISO code, but some Scottish patriots like to see their mail addressed to Scotland instead of the United Kingdom. These ambiguous entries were deliberately omitted because problems occur if you give one geographic area two different codes. In the case of Puerto Rico, you end up counting addresses in the wrong place on AAM/BPA audit reports if you treat Puerto Rico as a foreign country. In the case of Scotland you end up breaking the duplicate address detection if a customer sometimes has Scotland as his country and sometimes has the United Kingdom.

Country code

Enter the country code you want to assign to the country; the code may be up to four characters in length, but the default list that QuickFill creates for you uses two character ISO standard codes. Exception: the code for the United States is USA and the code for Canada is CAN. These two codes may not be changed.

To get a list of all customers with a particular code or codes, select 'Promotional labels' under 'Customer Lists' on the 'Reports' menu. (Click here for details on the 'Promotional labels' report. )

Country

Enter the name of the country (you can enter up to 24 characters).

Region

Enter a region number from 1 to 6.  The names of the six regions are specified on the General tab of the Preferences screen.

Default shipping class

QuickFill uses the code you enter in this field to automatically specify the shipping method for any new orders you enter for subscribers located in this country. The purpose of this default shipping method is to save you time during order entry. If a customer requests some other shipping method, you can override the default when you enter the order. If you're not sure of the available shipping codes, right click in this field to select from a list of correct codes. Shipping codes can range from A to Z, with A, F and P normally being assigned to Air Mail, First Class and Periodical Class.

You may also override the shipping class for each region on the publication definition shipping tab (Click here for details on the shipping code override fields in the publication definition). If you do so then subscriptions to that publication will use the shipping class specified on the publication screen instead of the one on the foreign country screen.

Postal code position

Here you can specify the position of the postal code in relation to the city field.  This is generally a matter of custom in the country in question. If you find that the postal code position for a country is wrong, you may go back and correct it; QuickFill will update all customer records for that country.

The options to position the postal code above or below the city require special handling if there isn't room to print the postal code on a line by itself since we are constrained by a six line limit for addresses. In that case QuickFill will print the postal code to the left of the city instead of above the city, or to the right of the city instead of below the city.