Goal
Safely update part of an existing item, set its primary storage location, and create new items with a controlled opening quantity.
For whom / where
Shop owner, Warehouse team
·
Admin Hub, Mobile & scanner
Check first
- Every row has a unique SKU.
- The file is saved as CSV.
- For the location, use either exactly one column with one of these aliases: lagerort, lagerplatz, storage location, location, or bin — or, for each active level, its own column named after the level name from settings.
- Values you want to change are present in the matching columns.
How it works
- Open CSV import under Procurement.
- Upload the CSV file and also review the normalized planned storage location in the preview.
- The preview lists the detected columns and warns if the file has no stock column.
- A missing stock column and an empty stock cell have the same meaning: stock remains unchanged for existing items.
- Other supplied fields such as name or minimum stock are still updated for existing items.
- The supplier name from the “Supplier” column is always created and linked to the item; the purchase price from the “Purchase price” column is optional and stays empty if none is given.
- Case and any leading or trailing spaces in the supplier name are ignored, so “Klimatec Handels GmbH” and “ klimatec handels gmbh ” are matched to the same supplier without renaming the one first created; spaces inside the name still count.
- Separate trimmed location segments with / and order them like the active levels in Settings; without custom configuration, use Aisle/Shelf/Bin.
- For three levels, use A/03/B; for four levels, use A/03/2/B. In general, enter A first, then 03, followed by optional numbered intermediate levels, and B last.
- Alternatively, add one column per active storage location level, headed with the level name from settings, for example Aisle, Shelf, and Bin; without custom configuration these are Aisle, Shelf, and Bin. All level columns must be present, or no storage location is recognized.
- If all level cells in a row are empty, the storage location stays unchanged; if only some are empty, the row is invalid and skipped. If both formats are in the file, the Storage location column wins.
- A missing location column or empty location cell means: leave the primary location unchanged.
- A location change is allowed during an active cycle count; its saved Cycle Count snapshot, posting baseline, and already claimed line remain unchanged.
- The / character is reserved and not escaped: a / inside a level value therefore cannot round-trip losslessly through the CSV location field.
- A new item without a stock value is created with stock 0.
- Start the import only when the preview shows the expected new and updated rows.
What happens next?
The partial import changes only supplied values; stock and location remain unchanged when missing, new items start with stock 0 without a quantity, and a supplied location becomes primary.
If it does not work
- The preview warns about missing stock: This is safe for an intentional partial update; existing stock remains unchanged.
- Stock was not changed: Check whether the stock cell was empty or the stock column was missing.
- The storage location is invalid: Check for empty segments and the expected number and order of levels.
- Level columns are not recognized as a storage location: Check that all level columns are present and their headers exactly match the level names from settings.
- The storage location is duplicated: The whole row is skipped so no partial update remains.
- A level value contains /: This known round-trip limit is not escaped; use / only as the separator.
- A row is skipped: Check the SKU, number format, and duplicate SKUs in the file.
- Supplier shows up in the list, but the item detail says “No supplier”: the name comes from old free text that was never linked. Select the supplier in the item detail, or re-import the CSV with the “Supplier” column.