Importing articles via CSV
Bring in your article master data in one go: mandatory columns, German number formats, opening stock via the import file — and one pitfall with negative values.
Anyone who already has their article master data in Excel or a legacy system imports it via CSV: under Settings → "Import/Export", the "Import" tab, "Import type" = "Articles". From Excel this works via "Save As" → "CSV UTF-8"; the fact that Excel sets semicolons as separators in the process is fine. Only the Admin may run the import.
The columns
Four columns are mandatory:
skuis the article number; in Gantway it is no longer changeable after creation, and duplicates are caught. During import it is mandatory because it serves as the key for detecting duplicates; when creating articles manually it is optional.nameunitis the unit, e.g. "pcs" or "lm"typeis the article class, eitherstueckgutorverbrauchsmaterial
Optional: manufacturer, supplier, order_url, purchase_price/sale_price as well as initial_stock, where a positive value directly creates an opening stock posting. The import understands German number formats ("1.234,56").
The import itself is included in all plans; the inventory page for maintaining articles belongs to Pro and Premium.
Process: preview first, then commit
Before writing, the import shows a preview with all recognized rows and errors (missing mandatory columns, duplicate SKUs). Nothing is committed until you confirm, so a faulty file can be uploaded and checked without risk.
Auch bekannt als: CSV import, import articles, data migration, Excel, opening stock.