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.
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
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
