Uploading Manifests in CSV Format
Manifests can be manually uploaded in a CSV (comma-separated values) manifest format. This format is intended to be easier to create and modify by-hand using standard spreadsheet software (e.g., Numbers or spreadsheet).
Note: AMU downloaded manifests should work as-is but will require adding the 'work_area' column.
File Requirements
The first row of the CSV file must contain the column names.
The file must be saved as a CSV file.
The Work_Area column must contain a route number (names are not allowed).
-
The following columns are required (they can appear in any order):
recip_street
recip_city
recip_state
sid
stop_type
work_area
The full set of optional columns includes:
Field |
Description |
recip_street |
Street address, e.g., 123 Main St. |
recip_street2 |
Apartment or suite number (optional). |
recip_city |
City name. |
recip_state |
Two-letter state code. |
recip_zip |
Postal code (optional, but recommended). |
recip_name |
Recipient’s name (optional). |
recip_phone |
Recipient’s phone number (optional). |
sid |
Shelf ID for deliveries. |
stop_type |
Must be either delivery or pick-up. |
work_area |
Route number as defined in GroundCloud®. |
stop_inst |
Additional stop instructions (optional). |
total_pkgs |
Number of packages for the stop. |
ready |
Pickup start time in a 24-hour format (e.g., 15:30). |
close |
Pickup end time in 24-hour format (e.g., 19:00). |
Creating a Blank Route (If Needed)
Go to the Routes page in GroundCloud.io.
Click + Add Route in the upper-right corner.
Enter the Work Area name to match the manifest file.
Select the correct terminal. If you need to add a terminal, refer to this article.
Configure the stop priority and driver settings as needed.
Click Submit to create the route.
Uploading the CSV File
Go to the Manifests page in GroundCloud.io.
Click Upload P&D Manifests to open the upload popup.
Click Choose Files and select the manifest file from your computer.
Select the correct terminal from the dropdown list.
Click Continue to begin processing.