On Sale Order Lines, it is rendered the product_template.name and the English Translation of product name instead of the current translation

[Andres Calle (TRESCLOUD)]

On OpenERP 6.0.4, running on Ubuntu 12.04 32bits, python 2.7, Postgres 8.4, with Sales module installed.

When working will multiple languages (lets say English and Spanish), if user's language is Spanish, after the user creates a new product by duplicating an existing one (click on duplicate on product form and change the name). Then, when the users create a sales order with that product specific product the sale order line gets a wrong product description!... the product description corresponds to the english translation instead of the spanish translation.

Right now we tried correcting this by use of the module base_translation_copy but this one is not working.

So far we found a temporary solution by the following SQL query (we already had several hundreds of products affected) which should work when only one language is considered important (in my case only spanish was considered important). Maybe we should put this in the scheduler like the base_translation_copy module was supposed to work.

UPDATE public.ir_translation
SET src = value
WHERE name = 'product.template,name'
AND type = 'model'
AND res_id != 0
AND lang = 'es_ES'

UPDATE product_template
SET name = name_template
FROM product_product
WHERE product_template.id = product_tmpl_id
AND name_template != name

It gets worst when copying or renaming objects due user dont imputing english translation

Best Regards,

Andres Calle
<email address hidden>
TRESCLOUD Cía Ltda