Import products with variants and BOM from a different Odoo database

Question

What is best procedure to export products along with associated variants and Build of Materials from one database and import them into a different/fresh V10 Community version database.
The export from the existing database includes that databases export id #'s which don't exist in the new database.  I can import the products without the export id's and let the new database assign new item numbers but then I don't know how to import the variants and BOM so the associations are maintained.
Thanks

Tony · Answer

Some fancy excel or python work is needed here
Import all unique variant and their values eg Variant: Colour, Values: Black, Red, Green Export alll variant values with their new external ids Import all products and inplace of the name of the variant values, use the external ids of the variants values you just exported. This is a many2one field so you have to import it by seperating the ids with comma. See this  https://www.odoo.com/documentation/16.0/applications/general/export_import_data.html

Gerelateerde posts	Antwoorden	Weergaven
How to import BOM with some shared components? Opgelost import bom bom_import	1 mei 22	9757
How to import BOMs with variants as component using plain text? import variant bom component	2 dec. 24	10504
Bill of Materials BoM Bulk import import bom importing bom_import	1 jan. 22	5272
Import-Compatible Export export import bom bom_import	1 feb. 19	6277
BOM Import on Variants import mrp variant bom datamigration	2 okt. 23	4279

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!