Rating zones and zone mapping

Rating zones are geographic areas used to determine freight rates. Rate cards use rating zones to define areas where a rate is applicable.

Skip ahead to 

• Zone mapping
  • Zone mapping types
• Adding a new rating zone
  • The 'All' zone

  • Suburbs with the same name in different regions

• Importing zone master data

A rating zone can have cities, suburbs, and businesses mapped to it.

Rate cards use rating zones to define what the rate should be from one zone to another.

e.g. You could have a rate card from the zone Auckland South to the zone Wellington with a $20 per m3 rate.

Zone mapping

Zone mapping is the master data used by eCargo to determine which zones the pickup and delivery addresses map to.

Zone mapping data is unique to your business - you can see your existing zones by going to Zone mapping under the Invoices section of eCargo Web.

Tip: To see all zone mappings for a particular type, leave the 'Search text' blank.

Zone mapping types

There are three types of zone that can be set up.

When calculating rates, eCargo will first look for a business zone mapping - if one can't be found, it will look for an address zone mapping, and then a cascaded zone mapping.

Adding a new rating zone

First, search for the relevant zone mapping type in Zone mapping (under the Invoices section of eCargo Web).

You can then add a new zone - this will be different for each of the mapping types.

Select an existing zone, or create a new one. For address zone mappings, all you will need to specify is the city or suburb which maps to the zone.

The 'All' zone

If a large number of zones use the same rate, you can create an 'All' zone which uses the zone name '*'. Once you have set up the * zone and rates for it, you can create zone cascades which cascade the relevant zones to the * zone. The zones that you cascade to the * zone will all have that rate.

Suburbs with the same name in different regions

You will from time to time come across a suburb name that is used in different regions, for example Frankton is a suburb in Queenstown and Hamilton. When determining which rating zone to use eCargo will always look at the suburb name first, so if there are rates in place for both Queenstown and Hamilton this may be a problem.

To overcome this simply enter both the suburb and city name into the address mapping for the correct zone, for example map Frankton,Hamilton to the Hamilton zone, as illustrated below:

Importing zone master data

You can bulk import master data for your zones in Import Auto Rating Zone Master Data under the Admin section of eCargo Web.

File format

Zone master data needs to be in a .csv (comma separated values) format. CSVs can be created in Excel - just be sure to save the file with a .csv extension.

You should also make sure that there are no spaces before or after values, as these will be interpreted as part of the data.

Text is encoded using windows-1252 (the format preferred by Excel).

The CSV file must be structured as follows (see attachments for an example file):

After you've imported the file, you will be alerted to any errors (such as names not matching the ones in eCargo). Correct the errors in the file, then re-upload it.