Before you start
- You need User Management to open Data Import, and Add on Items.
- Import suppliers first. See Import suppliers from Excel.
- "Your master list of materials and equipment. BoQs, purchase orders, and stock all refer to these items." A file holds up to 150 items.
Steps
- Select your name at the bottom of the sidebar.
- Select Data Import.
- On the Item catalog card, select Download template. The file items_template.xlsx downloads.
- Fill in one item per row from row 3. Use the second sheet to pick a unit that matches each category.
- Save the file.
- On the Item catalog card, select Bulk upload and choose the file.
Result
A message shows how many items were created, and the card's badge changes to "Done" with the number of records. Select Open Items to see them.
Next: Import opening stock.
If something is different
- "Bulk upload failed": nothing was imported. A common cause is a unit that does not belong to the category. See Bulk upload failed with errors in my Excel file.
- From the Items page: on Catalog & Inventory › Items, Download template gives the template ("Template downloaded") and Bulk upload takes an .xlsx or .xls file under 500 KB. Both need Inventory Management and Add on Items; rows for items you already have are updated, which also needs Edit on Items. The message "Bulk upload complete: [number] created, [number] updated." shows. Row errors open "Bulk Upload Failed: [number] Error(s) Found". "File must be under 500 KB (use fewer rows to avoid timeout)" or "Upload timed out. Try a smaller file or fewer rows.": split the file.
