Skip to Content
This question has been flagged
importvariantbombom_import10
1 Atsakyti
6320 Rodiniai
Portretas
Rex Thain

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

Portretas
Atmesti
Portretas
Tony
Best 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.
    Import this step in the product template page not product variant page
  • Export the imported products from product variant page with their external ids and import the boms with this ids

    hope this helps
Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
How to import BOM with some shared components? Solved
import bom bom_import
Portretas
Portretas
1
geg. 22
8265
How to import BOMs with variants as component using plain text?
import variant bom component
Portretas
Portretas
Portretas
2
gruod. 24
8725
Bill of Materials BoM Bulk import
import bom importing bom_import
Portretas
Portretas
1
saus. 22
4247
Import-Compatible Export
export import bom bom_import
Portretas
Portretas
1
vas. 19
5067
BOM Import on Variants
import mrp variant bom datamigration
Portretas
Portretas
Portretas
2
spal. 23
3234