Mockup with sample data. Not the final design; nothing here is saved. See empty, loading and error states
Intake / Wohnform Keller GmbH

Map columns

31 columns
  1. Upload
  2. 2Map columns
  3. 3File check
  4. 4Import

You do this once. Next time, files from this supplier import without this step.

Columns in the file

23 mapped, 8 not used

Supplier column Sample values Maps to Value transformation
Art.-Nr. WK-20931, WK-20932 Suggested Matching key
EAN 4029384756109 Suggested Matching key
Bezeichnung Sideboard Carlo Eiche 160 cm Suggested
Warengruppe Sideboards, Wohnzimmertische Suggested 3 values, see Product groups
Breite mm 1600, 1200 Suggested 1600 becomes 160 cm
Hoehe mm 820 Suggested 820 becomes 82 cm
Tiefe mm 420 Suggested 420 becomes 42 cm
Farbe Eiche Sonoma, Weiß Suggested
Material Spanplatte, Melamin Suggested Becomes 2 values
Gewicht 48,2 Suggested Becomes 48,2 kg
Schubladen 3 Suggested
EK netto 214,90 Suggested Becomes 214,90 €
Bild-URL https://img.wohnform-keller.example/20931_1.jpg Suggested Images are downloaded from the link
Lieferzeit 2–3 Wochen No matching field None
Lagerbestand 14 No matching field None
15 of 31 columns shown

First article after mapping

Row 2

Sideboard Carlo Eiche 160 cm WK-20931, EAN 4029384756109
Breite
160 cm
Höhe
82 cm
Tiefe
42 cm
Farbe
Eiche Sonoma
Material
Spanplatte, Melamin
Product group
SideboardsWarengruppe “Sideboards”
Each value keeps its file cell as the source.

Matching keys

1. Manufacturer SKU
Column “Art.-Nr.”
2. EAN
Column “EAN”

Product groups

From “Warengruppe”

Supplier valueRowsYour product group
Sideboards188
Wohnzimmertische131
Speisetische93

File

File
Supplier
Wohnform Keller GmbH
Uploaded
Julia Kramer, today 13:58
Rows
412
Columns
31
Header row
1