Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odgovori
252 Prikazi

I imported Product Vendor data into Product Variants instead of Products and it caused this issue.  I deleted all the duplicates in the Variant records, but we haven't found a way to regenerate this field to get the correct data.  Note the Internal Reference is the correct part number, but the number in the Name field is incorrect on all those records for AV037 variants.  Does anyone have a solution?  Thanks.


Avatar
Opusti
Best Answer

Hi,

Option 1: Export and import

Export all product variants with fields: external id, product_tmpl_id/name, attribute_value_ids, and name.


In Excel/Sheets, rebuild the Name by concatenating Template Name + Variant Attributes.


Import back into Odoo, mapping byexternal id


Option 2: Server action

Settings > Technical > Actions > Server Actions.

Model: Product Variant (product.product)

Action To Do: Execute Python Code

Code:

for product in records:

    new_name = product._get_combination_name()

    if new_name:

        product.name = new_name


Hope it helps.

Avatar
Opusti
Avtor Best Answer

Thanks so much.  You all are always very helpful!

Avatar
Opusti