Skip to Content
Odoo Menu
  • Log ind
  • Prøv gratis
  • Apps
    Økonomi
    • Bogføring
    • Fakturering
    • Udgifter
    • Regneark (BI)
    • Dokumenter
    • e-Signatur
    Salg
    • CRM
    • Salg
    • POS Butik
    • POS Restaurant
    • Abonnementer
    • Udlejning
    Hjemmeside
    • Hjemmesidebygger
    • e-Handel
    • Blog
    • Forum
    • LiveChat
    • e-Læring
    Forsyningskæde
    • Lagerbeholdning
    • Produktion
    • PLM
    • Indkøb
    • Vedligeholdelse
    • Kvalitet
    HR
    • Medarbejdere
    • Rekruttering
    • Fravær
    • Medarbejdersamtaler
    • Anbefalinger
    • Flåde
    Marketing
    • Markedsføring på sociale medier
    • E-mailmarketing
    • SMS-marketing
    • Arrangementer
    • Automatiseret marketing
    • Spørgeundersøgelser
    Tjenester
    • Projekt
    • Timesedler
    • Udkørende Service
    • Kundeservice
    • Planlægning
    • Aftaler
    Produktivitet
    • Dialog
    • Godkendelser
    • IoT
    • VoIP
    • Vidensdeling
    • WhatsApp
    Tredjepartsapps Odoo Studio Odoo Cloud-platform
  • Brancher
    Detailhandel
    • Boghandel
    • Tøjforretning
    • Møbelforretning
    • Dagligvarebutik
    • Byggemarked
    • Legetøjsforretning
    Mad og værtsskab
    • Bar og pub
    • Restaurant
    • Fastfood
    • Gæstehus
    • Drikkevareforhandler
    • Hotel
    Ejendom
    • Ejendomsmægler
    • Arkitektfirma
    • Byggeri
    • Ejendomsadministration
    • Havearbejde
    • Boligejerforening
    Rådgivning
    • Regnskabsfirma
    • Odoo-partner
    • Marketingbureau
    • Advokatfirma
    • Rekruttering
    • Audit & certificering
    Produktion
    • Tekstil
    • Metal
    • Møbler
    • Fødevareproduktion
    • Bryggeri
    • Firmagave
    Heldbred & Fitness
    • Sportsklub
    • Optiker
    • Fitnesscenter
    • Kosmetolog
    • Apotek
    • Frisør
    Håndværk
    • Handyman
    • IT-hardware og support
    • Solenergisystemer
    • Skomager
    • Rengøringsservicer
    • VVS- og ventilationsservice
    Andet
    • Nonprofitorganisation
    • Miljøagentur
    • Udlejning af billboards
    • Fotografi
    • Cykeludlejning
    • Softwareforhandler
    Gennemse alle brancher
  • Community
    Få mere at vide
    • Tutorials
    • Dokumentation
    • Certificeringer
    • Oplæring
    • Blog
    • Podcast
    Bliv klogere
    • Udannelselsesprogram
    • Scale Up!-virksomhedsspillet
    • Besøg Odoo
    Få softwaren
    • Download
    • Sammenlign versioner
    • Udgaver
    Samarbejde
    • Github
    • Forum
    • Arrangementer
    • Oversættelser
    • Bliv partner
    • Tjenester til partnere
    • Registrér dit regnskabsfirma
    Modtag tjenester
    • Find en partner
    • Find en bogholder
    • Kontakt en rådgiver
    • Implementeringstjenester
    • Kundereferencer
    • Support
    • Opgraderinger
    Github Youtube Twitter LinkedIn Instagram Facebook Spotify
    +1 (650) 691-3277
    Få en demo
  • Prissætning
  • Hjælp

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Bogføring
  • Lager
  • PoS
  • Projekt
  • MRP
All apps
Du skal være registreret for at interagere med fællesskabet.
All Posts People Emblemer
Tags (View all)
odoo accounting v14 pos v15
Om dette forum
Du skal være registreret for at interagere med fællesskabet.
All Posts People Emblemer
Tags (View all)
odoo accounting v14 pos v15
Om dette forum
Hjælp

How to import BOMs with variants as component using plain text?

Tilmeld

Få besked, når der er aktivitet på dette indlæg

Dette spørgsmål er blevet anmeldt
importvariantbomcomponent
2 Besvarelser
8787 Visninger
Avatar
Johann Wall

Hi everyone!

I know how to create BOMs by importing plain text excel/csv and it works great. Until one of the components exists with different variants.

Example: We have a product "Paint" with attribute values "red" and "blue", it is a component of any main product.

If in excel/csv I give "Paint (red)" as a component for the main product it will raise an error, same for "Paint (blue)". If I give "Paint" only, odoo will accept but always add the first variant to the BOM. So I'm not able to tell which variant should be taken. If I go with IDs, everything is fine (of course).

How can I solve this?

I tried in V10 and V12, same behaviour.


This is an example of a BOM we can import, but for the highlighted column I get an error:

No matching record found for name 'Paint (red)' in field 'BoM Lines' between rows 2 and 4
Get all possible values

product_tmpl_id

product_qty

product_uom_id

routing_id

bom_line_ids/routing_id

bom_line_ids/attribute_value_ids

bom_line_ids/product_id

bom_line_ids/product_qty

bom_line_ids/product_uom_id

bom_line_ids/product_tmpl_id

Main Product

1

Unit(s)

Manufacturing

Manufacturing

Color: red

Paint (red)

1

Unit(s)

Paint

Manufacturing

Color: blue

Paint (blue)

1

Unit(s)

Paint

Manufacturing

False

Bolt

4

Unit(s)

Bolt


0
Avatar
Kassér
Avatar
Ivan Rojas
Bedste svar

Hi Johann, I'm facing the same problem you had back then in 2019 with Odoo 13 CE. Did you get to solve this issue? Can you explain me how? Thanks

0
Avatar
Kassér
Boyan Yordanov

In Odoo 18 I succeeded by importing on two steps:
1. Import BOM definition without Components and Operations
2. Importing BOM Components as second import. I was importing only:
--> BOM [External ID]
--> add column with [Product Variant External ID] and map it to [BOM Lines / Components / External ID]
--> [BOM Lines / Quantity]
--> [BOM Lines / Product Unit of Measure]

I hope this helps!

Avatar
Niyas Raphy (Walnut Software Solutions)
Bedste svar

Hi,

In the Odoo once you activate the product variants features in the database, in the bill of materials form view, a new field named Product Variants will get displayed. Using this field you can do the above case.


Suppose if you have two variants for the product named Paint, with variants  Color Red and Color Green. In the Bill of material form view, In the Product field(product.template) you can choose the Paint and in the field named Product Variant(product.product) choose Paint( Red) or Paint(Green).

Regarding you logic, specified the plain text, not sure how you done it. You can alter the case accordingly.


Thanks

0
Avatar
Kassér
Johann Wall
Forfatter

Thanks for response!

I know how to create in form view and also how to create with import using IDs, but I don't manage to import with plain text. As long as the components have no variants, everything is fine, but since there are variants, I face this problem...

Niyas Raphy (Walnut Software Solutions)

imho didnt understand correct issue, can i know how you are importing the data to the system ? using the default odoo import export option right ?

Johann Wall
Forfatter

Yes, exactly. But I can call the column "product_tmpl_id" and import "T-Shirt" or I call it "product_tmpl_id/id" and import the related id (like "__export__.product_template_51_46199f68").

Niyas Raphy (Walnut Software Solutions)

Here you are specifying the product.template only, use the field product_id in your file and specify the variant in it. You can do one thing, create a BOM with specifying the product variant field and export the records with the fields product.template and product.product .

Johann Wall
Forfatter

But see, for the component I have both, bom_line_ids/product_id and bom_line_ids/product_tmpl_id.

Niyas Raphy (Walnut Software Solutions)

Yes, there will be both, so what is wrong

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Tilmeld dig
Related Posts Besvarelser Visninger Aktivitet
BOM Import on Variants
import mrp variant bom datamigration
Avatar
Avatar
Avatar
2
okt. 23
3264
Import products with variants and BOM from a different Odoo database
import variant bom bom_import 10
Avatar
Avatar
1
jan. 23
6345
Multiple veriants of the same component.
inventory bom component
Avatar
0
dec. 24
1883
Import product variant's média
import variant v15
Avatar
Avatar
Avatar
Avatar
Avatar
6
aug. 24
5750
help with manufacturing in v17
manufacturing variant bom
Avatar
Avatar
1
maj 24
2324
Community
  • Tutorials
  • Dokumentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Oversættelser
Tjenester
  • Odoo.sh-hosting
  • Support
  • Opgradere
  • Individuelt tilpasset udvikling
  • Uddannelse
  • Find en bogholder
  • Find en partner
  • Bliv partner
Om os
  • Vores virksomhed
  • Brandaktiver
  • Kontakt os
  • Stillinger
  • Arrangementer
  • Podcast
  • Blog
  • Kunder
  • Juridiske dokumenter • Privatlivspolitik
  • Sikkerhedspolitik
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo er en samling open source-forretningsapps, der dækker alle dine virksomhedsbehov – lige fra CRM, e-handel og bogføring til lagerstyring, POS, projektledelse og meget mere.

Det unikke ved Odoo er, at systemet både er brugervenligt og fuldt integreret.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now