# How to add orders (bulk upload)

{% embed url="<https://www.loom.com/share/a69128f498134c2fa37b091ffd7578ba?sid=7d6e4779-c5ed-4f7a-b588-6ba5e8f5a798>" %}

The most common way to add orders (pickup and delivery jobs) to your route plan is to import them using a CSV (comma separated values) file. A CSV file is simply a spreadsheet that has a filename ending with .csv. Like any spreadsheet, it can be opened in Excel (MS Windows) or Numbers (macOS). In order to correctly create a route plan, Parcelizer can only accept CSV files in a specific format - you can [download a sample file](https://parcelizer.s3.amazonaws.com/sample.csv?v=4) to see what that looks like.

<figure><img src="/files/3Cjq2ZIfjcRAkjXMsYCL" alt=""><figcaption></figcaption></figure>

To import your spreadsheet and add orders to a route plan, follow these steps:

### Create a Route Plan <a href="#h_c4da38327e" id="h_c4da38327e"></a>

Log in, and navigate to the Route Plans Listing page (<https://dashboard.parcelizer.com/route-plans>). Click the \[New Route Plan] button on the top right.

<figure><img src="/files/6craflnXm12SMQ69A8d9" alt=""><figcaption></figcaption></figure>

After that, the app will prompt you to choose a name (use something descriptive e.g. "Daily Courier Delivery - Tuesday") and delivery date (the actual day that you are going to be making those deliveries).

<figure><img src="/files/QPcn0RiCIUlaYuYausB5" alt=""><figcaption></figcaption></figure>

You are now in the Route Plan module. On the next page, click ( 1 ) \[Add Orders] followed by ( 2 ) \[New Order] > \[Upload] to enter the Upload New Orders screen. Download ( 3 ) \[sample.csv] at the bottom left to see what the data upload file looks like.

<figure><img src="/files/oR6FM0WjfNbkf1TIc8tX" alt=""><figcaption></figcaption></figure>

The sample.csv template comes with the following fields (below) by default. Each row contains information for an individual order (most commonly a package that needs to be picked up and dropped off e.g. an item to be collected from a retail store or warehouse and delivered to the customer's home address, but it could be anything really - flowers, hot food or even cannabis delivery).

| order\_ref                   | Unique reference number (typically an invoice number) that you use to identify the package. If you leave it blank, Parcelizer will automatically generate one for you.                                                                                                                |
| ---------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| user\_group                  | The name of the user group that can view this order. Users belonging to a user group can log in with their email address to view details of all orders tagged with the user\_group name.                                                                                              |
| pickup\_name                 | Name of the customer you are picking up the order from. If you are picking up this order from a warehouse, use "Warehouse" as the pickup name.                                                                                                                                        |
| pickup\_from                 | The earliest time in hh:mm format you need to pick up this order. For example, if you are picking up an item from a store and it only opens at 9 am, put "09:00" in this field.                                                                                                       |
| pickup\_to                   | The latest time in hh:mm format you need to pick up this order. For example, if you are picking up an item from a store and it closes at 5 pm, put "17:00" in this field.                                                                                                             |
| pickup\_address (required)   | The address of the customer you are picking up the order from. Make sure to use a full address that includes a zip code e.g. "111 E 2nd Ave, Vancouver, BC V5T 1B4, Canada". Do not put the unit number or any other information in this field (you can put this in the notes field). |
| pickup\_phone                | Phone number of the customer you are picking up this order from. Remember to include the country code and plus sign e.g. +17789123456 for US/Canada numbers or +6593456789 for Singapore numbers.                                                                                     |
| delivery\_name               | Name of the customer you are delivering the order to e.g. "Helen Mckenzie".                                                                                                                                                                                                           |
| delivery\_from               | The earliest time in hh:mm format you need to deliver this order. For example, if the customer specified that he wanted his package delivered between 3 pm and 5 pm, put "15:00" in this field.                                                                                       |
| delivery\_to                 | The latest time in hh:mm format you need to deliver this order by. For example, if the customer specified that he wanted his package delivered between 3 pm and 5 pm, put "17:00" in this field.                                                                                      |
| delivery\_address (required) | The address of the customer you are delivering this order to. Make sure to use a full address that includes a zip code e.g. "198 W 18th Ave, Vancouver, BC V5Y 2A5, Canada". Do not put the unit number or any other information in this field (you can put this in the notes field). |
| delivery\_notes              | Extra information that might be helpful to the driver e.g. apartment address, customer preference etc go here.                                                                                                                                                                        |
| delivery\_phone              | Phone number of the customer you are delivering this order to. Remember to include the country code and plus sign e.g. +17789123456 for US/Canada numbers or +6593456789 for Singapore numbers.                                                                                       |

### Upload Spreadsheet <a href="#h_c69f217121" id="h_c69f217121"></a>

Drag and drop your spreadsheet onto the shaded area. On the next screen, you'll get to match your spreadsheet's column names with Parcelizer's data fields. If you used the sample.csv as a template, most of the columns should already be correctly matched. If not, look for the field name ( 1) on the left. Click ( 2 ) \[Add Attribute] on the right and click the ( 3 ) \[Add] button to the right of the column name you want to match the data field to. Click anywhere outside the popup to dismiss it.

<figure><img src="/files/1ZfLX7o0QHttVNVZGwHU" alt=""><figcaption></figcaption></figure>

Once you are done, hit \[done] to upload your data. If everything was parsed correctly (no geocoding or validation errors), the orders should show up highlighted with the status `draft` . Click \[Add to Route] on the bottom right to add the orders to the route plan.

<figure><img src="/files/3UfBogTKRuxoUuBJmo5J" alt=""><figcaption></figcaption></figure>

### View Stops on Map <a href="#h_888b23f086" id="h_888b23f086"></a>

If these steps were followed correctly you should see the orders (pickups are shown as circles, deliveries as squares) on the map.

<figure><img src="/files/fu9Y7hqzXH2KBkq5C9qx" alt=""><figcaption></figcaption></figure>

And that's how you add orders to a route plan using the bulk upload feature! If you have any questions about how to make Parcelizer work for you, don't hesitate to contact <support@parcelizer.com>.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.packagelytics.com/quickstart-guide/how-to-add-orders-bulk-upload.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.