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

관련 게시물	답글	화면
How to import BOM with some shared components? 해결 완료 import bom bom_import	1 5월 22	7490
How to import BOMs with variants as component using plain text? import variant bom component	2 12월 24	7502
Bill of Materials BoM Bulk import import bom importing bom_import	1 1월 22	3648
Import-Compatible Export export import bom bom_import	1 2월 19	4473
BOM Import on Variants import mrp variant bom datamigration	2 10월 23	2393

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!