The lane template upload allows you to import multiple lanes at once. This system feature helps reduce the time spent adding individual lanes for a bid. You must fill out a template with the lane data to import to ShipperGuide.
Topics covered in this article:
To download the template file:
On a draft RFP, click >
The lane template file will download and save to your computer.
To format cells:
Open the lanes template file and reference the accepted formats and required/optional fields below while filling out the cells.
Important: In the Procurement Settings, set up to 5 additional fields for each transportation mode which will automatically be added to the lane template file for new bids. Please do not change the column header names, as it will prevent the system from matching the correct fields to upload the lane data.
Column |
Format |
Examples |
Required/Optional |
Default |
|
Lane Id |
Free form text
|
|
Optional |
Origin zip-destination zip-equipment type |
|
Origin Facility Name
|
|
|
Optional |
|
|
Origin Facility Address |
Valid address |
|
Optional |
|
|
Origin City |
Free form text US, Canadian, and Mexico lanes are supported
|
Chicago |
Required |
|
|
Origin State |
Free form text
|
CA or California |
Required |
|
|
Origin Zip |
Free form text |
60601 |
Required
If city and state are specified, a zip code is not required. A zip code will be randomly selected based on the city and state combination. |
|
|
Origin Country |
Free form text
|
US or USA CA or CAN MX or MEX |
Required |
|
|
Dest Facility Name
|
|
|
Optional |
|
|
Dest Facility Address |
Valid address |
|
Optional |
|
|
Dest City |
Free form text
|
Chicago |
Required |
|
|
Dest State |
Free form text |
CA or California |
Required |
|
|
Dest Zip |
Free form text
|
60601 |
Required If city and state are specified, a zip code is not required. A zip code will be randomly selected based on the city and state combination. |
|
|
Dest Country |
Free form text
|
US or USA CA or CAN MX or MEX |
Required |
|
|
Mileage |
Whole numbers |
The mileage calculator automatically calculates miles based on origin, additional stops, and destination zip codes. Otherwise, please enter the mileage. |
||
|
Volume |
A whole number that is greater than 0 |
Required |
||
|
Mode 1
|
Abbreviations |
FTL = Full Truckload IMDL = Intermodal LTL = Less-than-Truckload DRAY = Drayage |
Required if “Mode 2” is empty, otherwise optional
|
|
|
Equipment Type 1
|
Abbreviations |
DRV = Dry Van RFR = Reefer FBE = Flatbed PWR = Power Only TANK = Tanker PNMC = Pneumatics CST = Conestoga DRB = Dry Box FRA = Flat Rack Roll on Roll off = RORO Straight Box Truck = SBT Sprinter = SPR Hotshot = HST |
Required if “Equipment Type 2” is empty, otherwise optional
|
|
|
Equipment Size 1
|
Number / “ft” / “Standard” or “High Cube” |
20 ft Standard 20 ft High Cube 40 ft Standard 40 ft High Cube |
Required if RFP is DRAY
|
|
|
Mode 2
|
Abbreviations |
FTL = Full Truckload IMDL = Intermodal LTL = Less-than-Truckload DRAY = Drayage |
Required if “Mode 1” is empty, otherwise optional |
|
|
Equipment Type 2 |
Abbreviations |
DRV = Dry Van RFR = Reefer FBE = Flatbed PWR = Power Only TANK = Tanker PNMC = Pneumatics CST = Conestoga DRB = Dry Box FRA = Flat Rack Roll on Roll off = RORO Straight Box Truck = SBT Sprinter = SPR Hotshot = HST |
Required if “Equipment Type 1” is empty, otherwise optional |
|
|
Equipment Size 2
|
Number / “ft” / “Standard” or “High Cube” |
20 ft Standard 20 ft High Cube 40 ft Standard 40 ft High Cube |
Required if RFP is DRAY
|
|
|
Notes |
Free form text |
Optional |
||
|
Target Rate |
Set as a flat-rate |
Optional |
||
|
stop_1_city |
Free form text
|
Chicago |
Required (if zip code is not specified) |
|
|
stop_1_state |
Free form text
|
CA or California |
Required (if zip code is not specified) |
|
|
stop_1_zip |
Free form text
|
60601 |
Required (if city and state is not specified) |
|
If you would like to add additional stops, please add up to two more column values for the city, state, and zip of the two additional stops after the column that contains “stop_1_zip”, as seen in the screenshot below. The maximum number of additional stops for each lane is 3.
To upload the template file:
1. After filling out the lane template, save the template as a .csv file.
2. Navigate back to the RFP page. On the Import lanes pop-up window, drag and drop the updated template or click Browse File.
3. All lane details will be uploaded to the RFP. If mileage was not specified and the mileage calculator is enabled, please wait a minute and refresh your screen for the miles to be automatically calculated.
After adding the lanes, you can add and select carriers to bid.
Important: If you are getting an error please ensure the following:
- File Type is .csv: The system only accepts .csv file types. An error message will trigger if the template is not a .csv file.
- All Required Fields must be filled out: If required fields/cells are empty, the import file will not upload your RFP lanes. Please see chart above.
- File must have correct File Formatting: The cells within the lane upload file must matched the required formatting. Please see chart above for reference.
If you are still experiencing issues uploading the lane upload template file, please send a copy of the lane template file to ShipperGuide support at support@shipper.guide.
Comments
0 comments
Please sign in to leave a comment.