Purpose
This procedure is used to import Carrier delivery costs and charges.
Note: For additional details on creating upload files see the notes HERE.
Data Input
Step 1 – File Upload
Location
Nominate the Location which is the point of origin of the deliveries i.e. where items are being sent from.
Carrier
Nominate the Carrier the costs and charges are for.
Upload File
Select the spread sheet file you wish to upload, by clicking Browse. This assumes you have access to the file with the carrier costs/charges from the browser you are currently using.
Return to the Top
Step 2 – Review details
The cost/charge entries of the file selected are displayed so that you can review the data and confirm that you have selected the correct file before you continue.
Click Submit to submit all the details.
Return to the Top
Spread sheet format
The spread sheet must be in a csv format.
The first row of the spread sheet must be a heading row. It does not matter what the headings are, as long as they are meaningful to you e.g. you could have ‘Region’, ‘Area’ or ‘County’.
The columns required are:
| Column | Name | Additional Details |
| A | Cost Code | This may be a postcode or area name depending on how costs are defined for the carrier. |
| B | Cost Area Name | Describes the cost area |
| C | Carrier Charge | The rate the customer is billed for freight delivery |
| D | Carrier Cost | The cost to you for freight delivery |
Updating
Once you click submit, the rows on the spread sheet are validated. If no invalid data is detected, the carrier cost entries are updated to the Carrier Cost file.