Skip to Content
Menu
This question has been flagged
2 Replies
271 Rodiniai

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.


Portretas
Atmesti
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.

Portretas
Atmesti
Autorius Best Answer

Thanks so much.  You all are always very helpful!

Portretas
Atmesti