...
Settings → Inventory Items → Import/Export
...
Step 1: Download our inventory items template file
Exports the current Inventory Items to an XLSX format spreadsheet.
Step 2: Copy your inventory items into the template
...
For items that are made up of Material, Material Type and Colour the Code and Description are automatically created using a concatenation of the their descriptions and the column headings get have an * (astrix) on the end to indicate this, if it is desired to not use the default then remove the * from the heading.
Step 3: Upload an excel document
...
Once imported the validation screen is displayed.
Import Error Messages
...
Each Group has to be saved individually, there is no Save All option.
Step 5: Import the updated options layout template file
Explanation of Inventory item spreadsheet
...