Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
bom_importbom_lines
3 Vastaukset
783 Näkymät
Avatar
Marc Albert Bautista

When importing a product that includes a variant in its name (e.g., '.9% SODIUM CHLORIDE (GREEN)'), Odoo does not recognize the variant properly. What steps should be taken to ensure that Odoo correctly identifies and assigns the product variant during import? I already used BoM Lines / Components / External ID 

Error Sample :  No matching record found for external id '.9% SODIUM CHLORIDE (GREEN)' in field 'BoM Lines/Component'






Avatar
Hylkää
Avatar
Andry Ang
Paras vastaus

Hi Marc,

It seems you deleted your post previously.

  1. Export the product variant with fields:
    1. Display Name
    2. External ID
  3. Inside your working spreadsheet, add a sheet just call it "Product Master". Copy and Paste your exported product variant here.
  4. Now, back to your sheet1 where your BoM data is.
    1. add a column on right side of the Product, name it Product / External ID
    2. add VLOOKUP formula to get the EXTERNAL ID from "Product Master" sheet into the column
    3. add a column on right side of the BoM Lines/Component, name it BoM Lines / Component / External ID
    4. add VLOOKUP formula to get the EXTERNAL ID from "Product Master" sheet into the column
    5. ensure no #N/A found, if there is any meaning your product master is somehow not right.
    6. Save your file
  6. Back to Odoo, click on the import and choose the file and sheet you want
  7. Now, you will see there are multiple columns:
    1. Product -> don't import this 
    2. Product / External ID -> choose the corresponding Odoo field - as your screenshot.
    3. Quantity -> choose the corresponding Odoo field - as your screenshot.
    4. BoM Type -> choose the corresponding Odoo field - as your screenshot.
    5. Company -> choose the corresponding Odoo field - as your screenshot.
    6. BoM Lines/Component -> don't import this
    7. BoM Lines / Component / External ID -> choose the corresponding Odoo field - as your screenshot.

You should be able to import by this.
It seems to me that you don't have internal reference set. If you have, then you can import it easier.

Avatar
Hylkää
Avatar
Nikul Vasar
Paras vastaus

You may use internal referance code of the product during import.

Avatar
Hylkää
Avatar
Marc Albert Bautista
Tekijä Paras vastaus

This is the sample data and error I am getting 

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Parts List to BOM Tranformation
bom_import bom_lines
Avatar
2
heinäk. 16
5748
Issue with Importing Child Components in BOM Using Database IDs in Odoo 18
bom_import
Avatar
Avatar
1
tammik. 25
1138
Duplicates in BOM component lines
saas bom_import bom_lines BOM
Avatar
0
jouluk. 23
1393
How can I convert the value of a BOM line from the product name to its internal code when importing a product's BOM? Ratkaistu
bom_import
Avatar
Avatar
Avatar
2
lokak. 23
2409
How to update component quantity in BOM (Ver15) Ratkaistu
mrp bom bom_import bom_lines
Avatar
Avatar
Avatar
Avatar
4
huhtik. 22
3029