I want import bom product in mrp module.
I have an excel file that contains the final product name and the item name and product code.
for import I need to manually insert the product IDs and units of measure ID from product.product and product.uom into the Excel file that this is very time consuming.
The function must be written to read the product name, code and unit of measurement from the excel file and create it directly in the database using code so that there is no need to find any external product IDs.
I put a wizard that takes the bom file from the user and a button import.
Help me write the import function. Thanks