How to replace BoM lines with import

Question

Hello,

I had to re-import multiple BoM with 1 replaced BoM line product. When the import is done, the old BoM line product is still there.
The columns of my import file (which works fine) :
External ID Reference Product/External ID Quantity BoM Type Operation Type BoM Lines/External ID BoM Lines/Component/External ID BoM Lines/Quantity
For now the only solution I've found is to :
DELETE FROM mrp_bom_line WHERE product_id = 'XXX'

Tony · Accepted Answer

Did you reuse the external id of the old bom line or did you add the new product on a new line? You should reuse the old bom line id. That should replace the old product

Derick David · Answer

Activate Debug mode  use open view to open the tree view for Bom lines model use group by product and delete those

Tuan Bui VKS · Answer

The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.
Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to replace BoM lines with import (bis) import mrp bom lines replace	1 huhtik. 25	1303
BOM Import on Variants import mrp variant bom datamigration	2 lokak. 23	2457
Subcontracting Product with multiple BoM mrp bom	0 tammik. 25	1071
BOM with some item quantity which not depends of the whole quantity to produce Ratkaistu mrp bom	1 kesäk. 25	4808
How to show BOM matrix with quantity of used product? mrp bom	0 helmik. 19	3993

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!