Import outer packaging

This import reads a CSV file with the packaging units of your articles – single piece, inner pack, carton and pallet – and stores dimensions, EANs and the number of units per packaging as attributes of each article. The warehouse uses these values, for example to know how many units fit into a carton or onto a pallet.

Before you start

• Your user needs the permissions for the import and for the outer packaging import – ask your administrator.
• The articles already exist in your catalogue with the item numbers used in the file. Rows with unknown item numbers are skipped.
• The target attribute fields exist (see the table below). The standard fields for length, width and height are created automatically if your company does not have them yet. All other fields – for example units-per-ct – must exist as attribute fields with exactly this slug, otherwise their values are not stored.

Step by step

1. Open Catalogue › Import › Product Outer Packaging (Katalog › Import › Artikel Umverpackung).
2. Click Choose file and select your CSV file.
3. Click Absenden (submit).
4. The message "N Zeilen wurden eingelesen" tells you how many rows were imported.

File format

• CSV file with semicolon as separator.
• The first line is a header and is skipped.
• One row per article and packaging unit. An article with four packaging units therefore has four rows.

Column	Content
1 (A)	Item number
3 (C)	EAN of the packaging unit
4 (D)	Unit: Stck, PCE, CT or PA (PCE, CT and PA may also be lower case)
7 (G)	Number of units per packaging
15 (O)	Length
17 (Q)	Width
18 (R)	Height

All other columns are ignored.

Which attributes are written

Unit in column 4	Meaning	Attributes (slugs)
Stck	Single piece	length, width, height
PCE	Inner pack	units-per-pce, ean-units-pce, pce-length, pce-width, pce-height
CT	Carton	units-per-ct, ean-units-ct, box-length, box-width, box-height
PA	Pallet	units-per-pa, ean-units-pa, pa-length, pa-width, pa-height

Empty cells do not overwrite existing values.

Good to know

• The import only finds articles of your own company by their item number.
• The file is deleted after the import.
• For all other article data, use the flexible import templates.

Message	Cause	Solution
Bitte eine CSV-Datei hochladen.	The file is not a CSV file	Save the file as .csv with semicolons and upload it again
Da ist ein Fehler aufgetreten!	The upload failed	Upload the file again
N Zeilen wurden eingelesen, M nicht: …	Some rows could not be saved; the message lists the first item numbers with the reason	Check the values of these rows (e.g. numbers in the dimension columns)
Die Datei konnte nicht verschoben werden!	The file could not be stored	Contact X-Sitter support