Product Costing - Data Import - BOM Import

Add Raw Materials to Existing Products in bulk using the Import Template. Mandatory fields for adding Raw Materials to existing Products are Product ID, Sizes, Our Reference or Raw Material ID and Colour.

Important: You can include the same raw material on more than one row, as long as each row has a different Material Type.

If that raw material is already on the product costing, its existing lines are overwritten to match the rows in your file.

If the same raw material appears more than once with the same Material Type, you will receive a duplicate row error.

To fix it, give each row a different Material Type or remove the repeated row.

#From Product Costings dropdown menu select [ BOM Import]

#Select [Download Template] to download .csv template file

Tip: All mandatory columns need to be completed on the .csv template in order to add Raw Materials to Products

#Mandatory fields for adding Raw Materials to existing Products are Product ID, Sizes, Our Reference or Raw Material ID and Colour.

#Complete .csv file

#1. Product ID: Enter the Product ID to allocate Raw Materials against when the Import is performed

#2. All Sizes/Sizes: Enter "All Sizes" if you are looking to allocate Raw Materials within the Raw Materials Tab and to All Product Sizes.

#3. Enter each Product Size if you are looking to allocate Raw Materials within the Sized Raw Materials Tab and to each respective Product Size.

#4. If BOM Material Types have been created within the System Settings, enter these here.

#5. Our Reference or Raw Material ID: You can use either the "Our Reference" or the "Raw Material ID" to allocate Raw Materials to corresponding Products.

#6. Colour: Enter the Raw Material Colour/ Variant you wish to allocate to corresponding Products.

#7. Quantity: Enter the per unit consumption up to 3 decimal spaces for each Raw Material or the Sized Raw Material. Please ensure to write with "." instead of ",".

#8. Enter any Notes for each Raw Material to populate within the Comments field.

#From Product Costings dropdown menu select [BOM Import]

#Drag and Drop .csv file to import data back it into Zedonk

#Select [Next]

#You see all columns that will be imported

#Uploaded .csv is now validated and is ready for import

#Select [Import Data] if all looks correct

#SUCCESS!

#Your Raw Materials have now been added to your Products

#OR

#If you're on the Validation screen but some records have errors

#1. Click on the Error

#If either of the records of the Product ID, Sizes (only for sized Raw Materials), Our Reference/Raw Material ID or the Colour do not match exactly as these have been created in Zedonk - will result in an Error.

#As you see above, the Colour on the csv file is entered as "Bluee" and on Zedonk the Raw Material Colour is "Blue". This has therefore, resulted in an error. In which case, you can fix this on the csv file and import it back in.