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	9892
How to import BOMs with variants as component using plain text? import variant bom component	2 12月 24	10578
Bill of Materials BoM Bulk import import bom importing bom_import	1 1月 22	5322
Import-Compatible Export export import bom bom_import	1 2月 19	6350
BOM Import on Variants import mrp variant bom datamigration	2 10月 23	4351

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！