If a customer sends orders as a file, you can import them into X-Sitter. You upload a CSV or Excel file together with an [import template](/orders/order-import-templates.md). The upload creates an import job that creates or updates the orders and their lines in the background. Under **Import - Jobs** you see the progress of all imports.

![Screenshot: Page "Import Orders" with template selection, file field and preview](/orders/images/import-orders-upload.png)

## Before you start
- Your user needs the order importer permissions: *Upload* to import files, *Import - Jobs* to see the job list. Ask your administrator.
- A saved import template for this file format. See [Order import templates](/orders/order-import-templates.md).
- The SKUs in the file must exist as articles for the client, otherwise the lines cannot be picked. See [Article overview](/products/article-overview.md).

## Step by step

### Upload a file
1. Open **Orders › Upload** (*Aufträge › Upload*). Alternatively click **Use** (*Benutzen*) next to a template in **Orders › Import - Templates**.
2. Choose the **Template** (*Vorlage*).
3. Choose the **File** (*Datei*) – .csv, .xls or .xlsx.
4. Click **Load preview** (*Vorschau laden*) and check the **Preview** (*Vorschau*) on the right: are the columns mapped correctly?
5. Click **Start Import Job** (*Import-Job starten*). You see *Job erstellt* (job created) and the status *In Warteschlange ...* (queued).

![Screenshot: Loaded preview of an order file with mapped columns](/orders/images/import-orders-preview.png)

### Follow the import jobs
1. Open **Orders › Import - Jobs** (*Aufträge › Import - Jobs*).
2. The list shows per job: **Template** (*Vorlage*), **Status**, **created** (*erstellt*), **started** (*gestartet*), **done** (*fertig*) and **File** (*Datei*).

![Screenshot: Import jobs list with jobs in different statuses](/orders/images/import-orders-jobs.png)

## Statuses

| Status | German UI | Meaning |
|---|---|---|
| **Pending** | *Wartend* | The job was created and is waiting to be processed. |
| **In progress** | *In Arbeit* | The job is being processed. |
| **Finished** | *Fertig* | Done. The job shows how many lines were imported. |
| **Failed** | *Fehlgeschlagen* | An error occurred. The job shows the details. |
| **Repeat** | *Wiederholen* | The job is being tried again. |

## What the import does
1. The file is read and its structure (rows or blocks) is recognised.
2. The field mapping of the template is applied.
3. For each order number, an order is created for the client assigned to the template (or your own company if the template has no client). New orders get status *Open*.
4. If an order with the same order number already exists for this client as a manual/imported order, it is updated instead.
5. The stock of the affected articles is recalculated.

New and updated orders appear in the [order overview](/orders/order-overview.md) right away. From there you continue with [creating a picklist](/outbound/create-picklist.md).

## Good to know / Troubleshooting

| Message | Cause | Solution |
|---|---|---|
| *Bitte erst die Vorschau laden* (load the preview first) | You started the job without a preview. | Click **Load preview** first. |
| *Bitte Vorlage wählen oder speichern* (choose or save a template) | No template is selected. | Choose a template or create one. |
| *Template oder Datei fehlt* (template or file missing) | Template or file is missing. | Choose both and upload again. |
| *Fehler beim Anlegen des Jobs* (error creating the job) | The job could not be created. | Try again. |
| **No jobs were found** (*Es wurden keine Jobs gefunden*) | No import has been started yet. | – |

!!!
Rows without an order number are skipped. Make sure the order number column is mapped in the template.
!!!