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

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to import BOM with some shared components? Ratkaistu import bom bom_import	1 toukok. 22	8430
How to import BOMs with variants as component using plain text? import variant bom component	2 jouluk. 24	9028
Bill of Materials BoM Bulk import import bom importing bom_import	1 tammik. 22	4375
Import-Compatible Export export import bom bom_import	1 helmik. 19	5160
BOM Import on Variants import mrp variant bom datamigration	2 lokak. 23	3403

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!