---
title: "Customer portal: How to create orders in bulk from an Excel or CSV file"
description: "Portal users upload a CSV, XLS or XLSX file to create many orders at once. This article covers setup, upload, status follow-up and fixing failed orders in Order imports."
url: https://help.qargo.com/us/articles/879687-customer-portal-how-to-create-orders-in-bulk-from-an-excel-or-csv-file
locale: us
updated: 2026-10-29
---

# Customer portal: How to create orders in bulk from an Excel or CSV file

## Introduction {#h_99f8ecbff0}

Portal users can upload one CSV, XLS or XLSX file to create many orders at once. This replaces entering orders one by one with a form or template. Every order in the file becomes its own order import. Valid orders are created or wait for approval. Failed orders stay in Error with a short reason.

## Prerequisites {#h_6d963c9bb2}

-   A **Super Admin** must switch on **Customer portal order creation via order import** for the customer portal and choose a **File upload format** (see 'Set the file upload format for the customer portal' below). Without a format, no portal user sees the **Upload file** button.

    :::callout{tone="note"}
    The chosen format must be a manual order import source with an active CSV or Excel mapping that is not limited to specific customers. For a custom mapping, contact the **Account Manager**.
    :::

-   The customer portal must already create orders through the order import flow. See [Customer portal - Creating and planning orders shown in customer portal views.](https://help.qargo.com/us/articles/316497-customer-portal-creating-and-planning-orders-shown-in-customer-portal-views) for setup.
-   Portal users must be able to create orders. If the tenant forces template-only ordering, or the customer status is not Approved, **the button is visible but disabled.**

## Use cases {#h_c37c488541}

-   A shipper books dozens of orders a day from a spreadsheet and uploads the file directly, instead of sending it to the transport company to be re-keyed.
-   A transport company asks all portal customers to send orders in one agreed file layout, and the orders arrive without manual entry.
-   A shipper uploads a file where a few rows contain typos. The shipper sees the reason for each failed row and corrects the file without waiting for the transport company.

* * *

## Set the file upload format for the customer portal {#h_81c48ac678}

🎥 This video explains how to configure the settings for the file upload format, and how this works for customers on the portal:

::embed{src="https://watchclueso.com/embed/zcc42n2e5azjbkqg"}

1.  Navigate to **Configuration > Organization settings**.
2.  Open **Customer portal** in the left side menu.
3.  Enable **Customer portal order creation via order import**.
4.  Select the import source in the **File upload format** field. Only manual sources with an active CSV or Excel mapping that are not limited to specific customers are listed.
5.  **Save** the settings.

![](https://help.qargo.com/media/fd10f32d5e4e-image.png)

The **Upload file** button now appears for every customer with portal access.

:::callout{tone="note"}
‼️ One upload format applies to the whole tenant. Every portal customer uploads the same file layout. Clearing the File upload format field hides the button for all customers.
:::

## Upload a file of orders on the customer portal {#h_4117847c4a}

1.  Open **Orders** on the customer portal account.
2.  Click **Upload file**, next to Create order.
3.  Drop a file in the Upload orders dialog, or\
    browse to select it.
4.  Click **Upload** to submit the file.

![](https://help.qargo.com/media/25ff25a2fb41-image.png)

![](https://help.qargo.com/media/ca568dfdb0f4-image.png)

Every order in the file becomes its own order import. Each order is booked on the portal user's own company, whichever customer the file names.

:::callout{tone="note"}
📚 Only CSV, XLS or XLSX files are accepted. Word, PDF and free-format documents go through document scanning instead.
:::

## Follow the status of uploaded orders {#h_f0956f3081}

1.  Open **Orders** on the customer portal account.
2.  Select the **Waiting for approval** tab.
3.  Locate the uploaded orders and read their status.
4.  Read the reason shown next to any order with status **Error**, such as an unknown location or an unknown value. When several reasons apply, the row shows the first one with a count. Hovering over it shows all of them.

![](https://help.qargo.com/media/3b7f5dc6496f-image.png)

Valid rows are created as orders, or wait for approval, depending on the automation setting of the upload format. Failed rows stay in Error with a plain, read-only reason.

:::callout{tone="note"}
📚 Portal users cannot correct a failed order on the portal. The file is fixed and uploaded again, or the transport company fixes the order in **Order imports**.
:::

## Create and fix uploaded orders as a tenant user {#h_9edd4c068f}

1.  Navigate to **Orders > Order imports**.
2.  Locate the uploaded rows. The upload format shows in the Source column and the portal customer in the Customer column.
3.  Click **Create order** on a row that is ready.
4.  Click **Fix order data** on a row in **Error** and correct the issue, for example the location.
5.  **Save** the order.

![](https://help.qargo.com/media/5e9cc4abd572-image.png)

![](https://help.qargo.com/media/c8bcb18c681a-image.png)

![](https://help.qargo.com/media/a1eff8668170-image.png)

::video{src="/media/video/7be481134d2e-2026-10-27-08_16_33.mp4"}

The order is created, and the row no longer shows Error on the portal.

:::callout{tone="info"}
📚 Order capture validation does not block an uploaded order. A broken rule shows in the order verification issues popup when Create order is clicked, and the order still goes through.
:::

* * *

## Troubleshooting {#h_7592e0e212}

| Issue | Resolution |
| --- | --- |
| The Upload file button is not visible on the portal | No File upload format is set, or Customer portal order creation via order import is off. A Super Admin must set both in Organization settings under Customer portal. |
| The Upload file button is visible but disabled | The button stays visible but disabled, with a tooltip, when the tenant forces template-only portal ordering or the customer status is not Approved. |
| A file fails with "Something went wrong, try submitting again" | The file type does not match the mapping of the upload format. Use a file of the same type as the template of the format. A PDF or Word file gives the same message. |
| A row names a different customer than the portal user's company | This is expected. Every uploaded order is booked on the portal user's own company. |
| One row failed but the other rows were created | This is expected. Each order is processed on its own, so one failed row never blocks the rest of the file. |
| A row with a missing value was not marked as Error | The value may have been filled from the customer default. Check the row in Order imports before creating the order. |
| An order that breaks an order capture validation rule was still created | The tenant sees the Order verification issues popup when creating the order from Order imports. |


## Related articles

- [Video - How to create orders in bulk via the customer portal?](https://help.qargo.com/us/articles/892733-video-how-to-create-orders-in-bulk-via-the-customer-portal.md)
- [Customer portal: create orders from templates](https://help.qargo.com/us/articles/685597-customer-portal-create-orders-from-templates.md)
- [Customer portal — Excel and CSV order export — what, why and how.](https://help.qargo.com/us/articles/764910-customer-portal-excel-and-csv-order-export-what-why-and-how.md)
- [Qargo Intelligence (Qi): order scanning](https://help.qargo.com/us/articles/864323-qargo-intelligence-qi-order-scanning.md)
- [How to: Generate invoice XLS/CSV export](https://help.qargo.com/us/articles/211159-how-to-generate-invoice-xls-csv-export.md)
