...
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.
Example Inventory Item Import file formats
Step 3: Upload an excel document
...
Confirm import
...
Check your import file to see if you have the same Material, Material Type and Colour, to see if BUZ is trying to create the same Inventory Code as an existing one in the system.
Inventory Item Code can't be generated by BUZ
...
| BUZ location | Maximum code |
|---|---|
| Inventory Group | 5 characters |
| Description1 (Material) | M + 3 characters |
| Description2 (Material Type) | T + 3 characters |
| Description3 (Colour) | 1st character of the description + 3 characters |
Description column error
Due to a description column having no data
Inventory Item Code is duplicated in the import list (Duplicate code found in the import list)
...
Manually adding an Inventory Item to BUZ
Settings → Inventory Items → New Item
Manually type the inventory item information into BUZ → Save
...
Deactivating Inventory Items
...
Settings → Inventory Items → Import/Export
Step 1: Download our inventory items template file
Exports the current Inventory Items to an XLSX format spreadsheet.
...
Open the downloaded file → Enable editing → File → Save As → Choose your file location → Save
Step 3: Edit your inventory items file
...
The PkId= Primary Unique Identifier column will already be populated with the unique identifier BUZ has already allocated, this MUST stay the same.
Add the product details to be updated and save the excel document to a new file name
The Operation should be D=Deactivate
Example Inventory Items deactivate import format
...
Highlight the worksheet to upload → Import → Check the correct items are Updating → Save All → Check the message these Items have been successfully modified.
The Inventory items are now deactivated in BUZ.
...
Settings → Inventory Items → Search for Inventory Item → Display
→ Click the Inventory Item link to be Deactivated
→ Archive
BUZ confirmation message
Reactivating Inventory Items
...
Settings → Inventory Items → Import/Export
Step 1: Download our inventory items template file
Exports the current Inventory Items to an XLSX format spreadsheet.
...
Open the downloaded file → Enable editing → File → Save As → Choose your file location → Save
Step 3: Edit your inventory items file
...
The PkId= Primary Unique Identifier column will already be populated with the unique identifier BUZ has already allocated, this MUST stay the same.
Add the product details to be updated and save the excel document to a new file name
...
The Operation should be E=Edit
Example Inventory Items reactivate import format
...
Highlight the worksheet to upload → Import → Check the correct items are Updating → Save All → Check the message these Items have been successfully modified.
The Inventory items are now activated in BUZ.
...
Settings → Inventory Items → Search for Inventory Item → Display
→ Click the Inventory Item link to be Deactivated
→ Activate
BUZ confirmation message
Manually editing an Inventory Item in BUZ
Settings → Inventory Items → Search for Inventory Item → Display
→ Click the Inventory Item link to be edited
→ Edit Details
→ Update the required details → Scroll to the bottom of the screen → Save
BUZ confirmation message
Explanation of Inventory item spreadsheet
...