Postage is also configured with two worksheets in the spreadsheet - PostalRegions and PostalCharges. The former defines the areas to which delivery
is available and sets any other parameters (e.g. minimum value of an order to qualify). The PostalCharges worksheet defines the actual charges
which will be made for each region, based upon the weight of a package. This sheet matches the way this information is presented by Royal Mail and Jersey Post,
in order to make it as easy as possible to update.
The PostalRegions worksheet contains the following columns:
- Country - The Country (or CountryGroup) to which this PostalRegion applies
- Code - Unique code identifying this region e.g. UK001, UK002, EUR001
- Description - A (customer visible) description of this region, and the type of delivery service it represents, e.g. "UK 1st class post", "Courier"
- BaseCost - The base cost (to the customer) of this region, e.g. if there is a charge of £5.00 before the weight of the package is considered, enter 5.00. Can be set to 0.
- ValueLimit - The maximum (retail) value in GBP of a package to be sent to this region, e.g. 17.99 if exporting from Jersey VAT-free (under VAT exemption limit regulations). Set to 0 in all other circumstances.
- Active - Is this postal region currently active and available for use? y or n
- MinimumOrderValue - The minimum (retail) value of orders which qualify for this type of delivery. E.g. to set up "free delivery on orders over £10.00" this would be set to 10.00. Set to 0 by default.
The PostalCharges worksheet contains the following columns:
- Code - The code which identifies the PostalRegion to which this band applies e.g. UK001, UK002, EUR001
- From - The minimum weight of a package which falls into this bracket, in grams, e.g. 100
- To - The maximum weight of a package which falls into this bracket, in grams, e.g. 159
- FixedPrice - The price applied to this particular bracket in GBP, e.g. 0.99
- PricePerKG - The price per kilogram of weight applied to this bracket, e.g. 4.00
Previous topic:
Hierarchy
Next topic:
Countries and Country Groups