Inventory Items Import Errors
- Allison Derome (Unlicensed)
- Alex Morrisson
How to fix common errors in your Inventory Items import file
Import Error Messages
There is a few reason an import error can occur.
First steps
When an error occurs try the following steps.
If you are Adding, editing and de-activating inventory items in one step attempt the processes individually.
Do one at a time, also for each step remove any columns that are not apart of the process
- De-active the relevant rows then
- Edit the rows that require changing then
- Add the new items.
This way you know where the error occurred.
First only the operations below will work, any other letter or number will return an error
- A - Add,
- E - Edit,
- D - Deactivate
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.
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)
The same data has been duplicated in Description fields Part 1, Part 2 & Part 3. → Remove the duplication and upload again.