Historical Shipment Upload
The 'Historical Shipment Upload' feature allows you to import shipments executed outside of the TMS into the G2Mint platform, ensuring all records are centralized.
Last Updated: Jan 2026
Applies to:
Shippers, Brokers, Carriers
Common Scenario(s)/Challenge (s):
For users who have shipments from previous TMS's or other systems and want to combine all shipment activity into 1 place for record keeping purposes and reporting.
If you are looking for any actions to be taken on these shipments such as tracking, then you would use the standard Shipment Upload feature.
Solution Overview:
The Historical Shipment Upload feature will allow customers to input Historic Shipments that have already been rated and awarded with a carrier outside of the G2Mint platform. This will be useful for customers who are coming over from another TMS or other applications and want all of there data in the system.
How it works?
- All shipments uploaded using this feature will automatically default to a status of 'Delivered'
- Every shipment uploaded using this feature is flagged as an Historical shipment. This is a field available on the Shipment grid, allowing users the flexibility to include or exclude these shipments from their custom views.
How to Upload Historical Shipments:
1. Go to the Shipments Grid
2. Click on the Quick Actions drop down and choose 'Upload Historical Shipment Data'
3. Export the template file
4. Fill in the template required fields and save the file to your PC
5. Click in the Upload your spreadsheet file area, locate your file and upload
Fields Included (Required Only): Refer template for all fields as there are 160+ fields that can be included in the upload.
*If you do not have specifics for a required field, you must enter some text in the field for the upload to to process. Text must be provided in ALL required fields. (Example: If you do not have Commodity information, in the field put N/A or 'No Commodity')
*Address book and contact looks ups will not apply on the historical upload. All required fields must be populated in order for a successful upload.
|
Field Name |
Required? |
Description |
| Account Name | Y | The account name should match any one of your client shipper accounts OR your main Client Account |
| Name | Y | This is the BOL # or shipment ID of your choice |
| Pickup Expected Start Date | Y | |
| Pickup Location | Y | Any name or description of your location |
| Pickup Address1 | Y | Proper address must be entered |
| Pickup City | Y | Proper city name |
| Pickup State | Y | Use 2 digit state codes |
| Pickup Postal | Y | Standard postal codes |
| Pickup Country | Y |
Use US or CA or MX |
| Delivery Location | Y | Any name or description of your location |
| Delivery Address1 | Y | Proper address must be entered |
| Delivery City | Y | Proper city name |
| Delivery State | Y | Use 2 digit state codes |
| Delivery Postal | Y | Standard postal codes |
| Delivery Country | Y | Use US or CA or MX |
| C1 Unit Type | Y | This is the handling unit type of your commodity . The entry here must match a handling unit available on your account (e.g. Pallet(s) etc.) |
| C1 Units | Y | |
| C1 Unit WeightNet | Y | |
| C1 Unit WeightUOM | Y | Unit of Measure should be LB |
| C1 Commodity Description | Y | |
| BillTo Location | Y | |
| BillTo Address1 | Y | |
| BillTo City | Y | |
| BillTo State | Y | |
| BillTo Postal | Y | |
| BillTo Country | Y | |
| BillTo Telephone | Y | |
| BillTo Email | Y | |
| Carrier Name | Y | The carrier name must match the name of the carrier set up on your account under Engage>Account |
| Total Cost Amount | Y | Note: The template includes additional option fields for cost breakdowns (Linehaul, FSC, Accessorial) along with charge breakdowns (costs plus mark ups). |