Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
2 Vastaukset
247 Näkymät

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
Hylkää
Paras vastaus

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
Hylkää
Tekijä Paras vastaus

Thanks so much.  You all are always very helpful!

Avatar
Hylkää