Add many articles from a spreadsheet
Validate a CSV or Excel file, correct row errors and create many articles in one upload.
Prepare the spreadsheet
- Open Inventory, select New Article, then select Bulk Upload.
- Choose Excel or CSV and select Download Template. Keep the template's column headings.
- Add one article per row. Give every article a unique article number and a name. Fill the other columns when they apply.
- For Excel, place embedded images in the first column. CSV files cannot include images.
Names entered for new categories, subcategories, units and projects are created during the upload. A subcategory needs its category in the same row.
The spreadsheet holds article details only. It has no quantity, location or price column, so an upload creates articles without stock. Afterwards, add the stock at its location and enter any price by editing the article.
Which columns and values does the file need?
A CSV file needs all 12 template columns: article number, name, description, category, color, height, width, length, unit, subcategory, project and minimum quantity. An Excel file needs the first 10 columns of its template: image, article number, name, description, category, color, height, width, length and unit. Subcategory, project and minimum quantity are optional there. A cell can stay empty, except for the article number and the name.
Height, width, length and minimum quantity must be whole numbers of 0 or more. Within one file, duplicate checks ignore upper and lower case, so AB-1 and ab-1 count as the same article number. A number already in your inventory only counts as a duplicate when its capitalization matches exactly, so check for numbers that differ only in case before you upload.
Is there a limit on rows or file size?
Hakomi sets no limit on the number of rows. A very large file can still fail to upload. If it does, split it into smaller files.
Validate and create the articles
- In Bulk Upload Articles, keep the file type set to Excel or change it to CSV to match the file.
- Select Click to browse or drag the file into the dialog.
- Select Validate File. The preview counts rows that are ready, need review or are duplicates.
- If any row has an error, select Download row errors if you want to save the reported row numbers and messages. Correct the spreadsheet, select Remove file (the X), choose the corrected file and select Validate File.
- When every row is ready, select Create Articles. The dialog closes after the articles have been created.
Why is Create Articles unavailable?
You need a clean validation preview. Fix every row error and duplicate article number, select Remove file (the X), choose the corrected file and select Validate File.
What if an article number already exists?
Use a different article number. If an archived article already uses that number, restore that article or choose another number for the new article.
Which file should I use?
Use Excel when rows need embedded images. Use CSV for text-only imports. Download a fresh template after switching the file type so its columns match the selected format.