Zedonkopedia

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.

From Product Costings dropdown menu select [ BOM Import]
Select [Download Template] to download .csv template file

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.

Previous Article Product Costing - Data Import - Validation Errors
Next Article Product Costing - Data Import - Update BOMs