Importing items
Updated:
Import items and opening stock from Excel or CSV: check first, then import; existing items are skipped.
Open Inventory in FiattoIn this article
Via Purchasing → Inventory → More inventory actions → Import (/dashboard/voorraad/importeren) you import items and opening stock from an Excel or CSV file. You check first; only then is anything imported. Anyone who may edit inventory can import.
Steps
- Click Download template (CSV) and fill in at least the name per row. Other columns are optional: item number, unit, category, barcode, description, reorder point, reorder quantity, maximum, standard cost, sales price, supplier, location, opening stock and cost price.
- Choose the file (.xlsx, .xls or .csv) and click Check. You see how many items are new, which are skipped and which rows have an error, plus unknown or duplicate column headers.
- Fix the errors in your file and check again: as long as there are errors, nothing is imported.
- Click Import … items. Items with opening stock immediately get a stock posting.
Tips
- A row whose item number or barcode already exists is skipped, so importing the same file twice posts nothing twice.
- Supplier and location must already exist (the supplier unambiguously), and the category must be one of the fixed categories; otherwise that row gets an error.
- A cost price is only allowed together with opening stock; it values that opening stock.
- Column headers in English or Dutch are both recognised; at most 5,000 rows per file.
- Then continue in managing inventory.