Freight - Alphanumeric Postcodes and Postcode Sector Wildcards
Freight Admin – Alphanumeric Postcodes and
Postcode Sector Wildcards
printIQ supports both Numeric and Alphanumeric postcodes in Freight
Admin as well as in address modals. When defining Postcode Sectors in Freight
Admin, you can use an asterisk (*) to denote a wildcard matching string.
The asterisk can only be to the right of the Wildcard postcode.
While spaces in postcodes are managed for alphanumeric postcodes within
printIQ, we discourage the use of other ‘special characters’ in the postcode
entries (be it Postcode Sectors or Postcode field on an address).
Numeric postcodes should never use spaces (*see note in red) .
You can use a wildcard * to represent 0 or more charaters and a ? to represent a single character. Both can be used together. All whitespace will be ignored.
E.g ABC1* indicates any postcode that starts with ABC1 will be applied.
E.g DEF??? indicates any postcode that starts with DEF and then has exactly 3 more characters following will be applied.
When setting up numeric postcode sector ranges in Freight
Admin, enter the ‘From’ and ‘To’ values and click the ‘+’ to add.
This range will be applied to all postcodes between 6420 and 6445
inclusive.
For an individual numeric postcode, enter the postcode into the
‘From’ field only. If the ‘To’ field is blank, it will use the ‘From’ value
there too.
Manages Postcode 6450 only.
For a Wildcard entry, replace the last n characters
with an asterisk (*)
This will apply to any postcode that begins with ‘652’
The above additions will look like the following in the Postcode
Sector definition…
Alphanumeric postcodes are managed in much the same way, but there
are a couple of things to be aware of.
- Alphanumeric postcodes do not
use the ‘To Postcode’ field. As soon as an alphabetic character is entered the ‘To
Postcode’ field is deactivated. Either a specific postcode or a Wildcard
postcode must be entered
- When
checking freight rates, spaces entered both in the Postcode Wildcard and
the Postcode field on the address are ignored.
In the above image, address postcodes entered as SW34xx, SW 34 xx
and S W3 4xx are all caught by this postcode wildcard.
Any Post Codes starting with SW33 are also catered for by the
‘Sw33*’ entry above along with the specific postcode SW3 5D11.
Once
the Post Code Sectors have been created, they can now be attached to Freight
rules to create Route.
And
required routes added to the bottom of the screen
Case Study:
How to add multiple wildcards based on the "Rate Card"? As Freight companies group their postcodes under zones and metric.
Rate Card sample:
Steps to set up Price based on Zone and Metric size. ( Setting up a few of the Postcode Areas as individual Postcode Sectors in IQ.)
- Set up two postcode sectors- Zone A and Zone B.
- Add the Sectors to the appropriate Rates and add a base price and number of days
- In PostCode Sectors Zone A, add the appropriate post code zones.
In this case, PostCode sectors A zone is: BR and TN. - Replicate on what you did in step 3, to add the WildCard Post Codes to the sector but just add a few PostCode as a sample.
Like so. - Then click export.
- Your CSV file will look like so:
- Copy all the postcode area in Zone B and paste it in excel, then format the excel so it looks like so.
- Import the excel back.
Zone A
Zone B - Now you have pricing and turn around time set up for those post code ranges.
Related Articles
Freight - Linking Postcodes to Countries
Introduction Freight calculations are based on rules relating to the ‘Origin’ and ‘Destination’ Post Codes. When shipping internationally we need to be able to distinguish between post codes for different countries. For the countries that have the ...Freight – Creating a freight pricing spreadsheet
Step 1. On the manage freight screen, Click on the template button. This will export the template spreadsheet for you to add all of your freight pricing information into. (See screen shot below) When you open the exported spreadsheet there are ...FREIGHT - How to MANUALLY Update Freight Pricing
To adjust the freight rates manually, go to the Admin menu at the top of the screen and choose Freight>Manage Rates. Use the 'search' options to locate the rates you want to adjust. In this example I am looking to adjust the rates used for ...Shipping/Freight - Carton Selector on Dispatch Record
Introduction On a delivery record, we have a field showing the default cartons selected for the job to be packed into: This is designed to provide the user a quick lookup of defined cartons that the product will fit into. This refers back to the ...Freight - 3rd Party Shipping
Introduction 3rd party shipping allows printIQ to use ‘Customers Supplied Credentials’ for shipping rates and services. Essentially the shipping is being booked on and invoiced directly to the customer from the freight provider. When a 3rd party ...