...
| Table of Contents | ||
|---|---|---|
|
Adding Inventory Items
To watch the video on How to add new Inventory Items click here.
Inventory Item Import
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 ****NOTE limit your upload number of lines to lots of 5000 inventory items.
The values can then be edited in the spreadsheet. Columns to the left of the Operation column cannot be deleted and additional columns cannot be inserted. If additional columns are required these need to be to the right of the Operation column.
The PkId is the Primary Unique Identifier for the row in the database so this should not be changed or deleted and do not copy this when duplicating the row to create a new item. It must be blank when Operation = A and contain the exported value for Operation = D
The Operation should be Blank, A(Add item) or D(Set item Inactive).
Before the import can be done it's good to have all all referenced data such as Materials, Material Types, Price Grids, Cost Grids, Discount Grids imported. For details on importing this data refer to Inventory Settings
Inventory Item Code & Description
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
****NOTE limit your upload number of lines to lots of 5000 inventory items.
Select the file being edited which by default is in Downloads Folder but this may vary depending on browser settings.
Once file is selected the Upload button will show. Click to confirm file upload of selected file.
Step 4: Import the updated options layout template file
Choose Sheets from the list to be imported and validated. The list shows those sheets recognised by the Sheet (tab) Name.
Maximum of 4 Inventory Groups can be imported at one time. To select multiple sheets press Ctrl key while selecting.
Add colour if not found? Selecting this option means that colours not found in the database will be added. Material and Material Type must be added prior to importing as these and Price Grids, Discount Codes are validated as already existing in the database.
Once imported the validation screen is displayed.
Confirm import
To see a list of items and save click arrow on left. The Save button is at the bottom left of list.
Import Error Messages
If there are errors in the imported data there is a separate error section below the valid data section and the Save button will be disabled. To see a list of items and save click arrow on left.
Duplicate PKID error/ Code already exists in database
This happens when the Inventory Item is already loaded to BUZ this includes any deactivated Inventory items and has a PKID, these Items will need to be removed from the list.
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
The Inventory Group ADFABRICSANDCOLOUR is more than 4 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)
The same data has been duplicated in Description fields Part 1, Part 2 & Part 3. → Remove the duplication and upload again.
Manually adding an Inventory Item to BUZ
...
Exports the current Inventory Items to an XLSX format spreadsheet.
...
Step 3: Edit your inventory items file
****NOTE limit your upload number of lines to lots of 5000 inventory items.
Edit your items spreadsheet.
...
Exports the current Inventory Items to an XLSX format spreadsheet.
...
To watch the video on how to edit Inventory Items click here
****NOTE limit your upload number of lines to lots of 5000 inventory items.
Edit your items spreadsheet.
...