跳至内容
菜单
此问题已终结
2 回复
266 查看

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.


形象
丢弃
最佳答案

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.

形象
丢弃
编写者 最佳答案

Thanks so much.  You all are always very helpful!

形象
丢弃