Skip to main content

Import

Title Widget Widget Description
Import

image.pngimage.png

Available in:

  • Order entry
  • Quotation entry

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.

Validation Explanation
Item number

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)
Status If the product is Locked, this is recognised as a problem.
Valid sales quantity If adherence to sales quantities is Mandatory and violated, this is recognised as a problem.
Listing If the product is not listed and the Customer has a closed listing, this is recognised as a problem.
Batch 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.

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

Action buttons
Name Function Visibility
Import XLS

In the information window: Opens a dialog for file selection.

In the problem window: Imports the products that have no problems.
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.
FAQ

 

Release