# Import

<table id="bkmrk-titel-verf%C3%BCgbar-widg" style="border-collapse:collapse;width:100%;height:143.391px;"><colgroup><col style="width:26.2217%;"></col><col style="width:12.0532%;"></col><col style="width:61.8443%;"></col></colgroup> <thead> <tr style="height:29.7969px;"> <td style="height:29.7969px;">Title</td> <td style="height:29.7969px;">Widget</td> <td style="height:29.7969px;">Widget Description</td> </tr> </thead> <tbody> <tr style="height:113.594px;"> <td style="height:113.594px;">Import</td> <td style="height:113.594px;">[![image.png](https://en.wiki.dedesales.de/uploads/images/gallery/2026-08/dvXWu9yuOTiuJlmg-3zffzb83n0hcetc6-eazimage.png)](https://wiki.dedesales.de/uploads/images/gallery/2025-02/3zFfzB83N0HCETC6-eAZimage.png)

 </td> <td style="height:113.594px;">Available in:

- Order entry
- Quotation entry
 
 </td> </tr> </tbody> </table>

### General

#### General Information

Clicking on the widget opens an information window:

Import product data via Excel. The Excel document must have the following structure:

1. No column headers
2. First column: Item number
3. Second column: Order Quantity
4. Third column (optional): Batch
 

##### Validation

If there are no problems during validation, the products are imported directly. The following validation takes place during import.

<table id="bkmrk-validierung-erl%C3%A4uter" style="border-collapse:collapse;width:100%;"><colgroup><col style="width:27.6786%;"></col><col style="width:72.4405%;"></col></colgroup> <thead> <tr> <td>Validation</td> <td>Explanation</td> </tr> </thead> <tbody> <tr> <td>Item number</td> <td>The item number is checked in DeDeSales. If there is no match, the following additional fields are checked in order:

1. EAN CODE
2. EAN CODE on the packaging unit
3. EAN CODE on the single piece
4. Base item number
5. Customer's item number (DAI)
 
 </td> </tr> <tr> <td>Status</td> <td>If the product is Locked, this is recognised as a problem.</td> </tr> <tr> <td>Valid sales quantity</td> <td>If adherence to sales quantities is Mandatory and violated, this is recognised as a problem.</td> </tr> <tr> <td>Listing</td> <td>If the product is not listed and the Customer has a closed listing, this is recognised as a problem.</td> </tr> <tr> <td>Batch</td> <td>If the product is Batch management required, a Batch is required in the order and no Batch was specified in column 3, this is recognised as a problem.</td> </tr> </tbody> </table>

If one or more problems are detected, a Summary with the identified problems appears. The grid columns are: Line, Product, Error.

##### Action buttons

<table id="bkmrk-name-funktion-sichtb" style="width:100%;"><colgroup><col style="width:25.1641%;"></col><col style="width:54.7046%;"></col><col style="width:20.1313%;"></col></colgroup> <thead> <tr> <td>Name</td> <td>Function</td> <td>Visibility</td> </tr> </thead> <tbody> <tr> <td>Import XLS</td> <td>In the information window: Opens a dialog for file selection.

In the problem window: Imports the products that have no problems.

 </td> <td>  
</td> </tr> </tbody> </table>

##### Import process

1. If a product appears multiple times in the Excel, it is also added multiple times to the Cart.
2. During import, quantities are not cumulated with identical products already in the Cart.
 
<details id="bkmrk-faq-wie-steuere-ich-"> <summary>FAQ</summary>

 </details><details id="bkmrk-release-ab-version-1"> <summary>Release</summary>

</details>