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

  1. Select your name at the bottom of the sidebar.
  2. Select Data Import.
  3. On the Item catalog card, select Download template. The file items_template.xlsx downloads.
  4. Fill in one item per row from row 3. Use the second sheet to pick a unit that matches each category.
  5. Save the file.
  6. 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.