Odoo Help


Managing 2 references for a product

Kibong Moon
on 12/9/14, 1:37 AM 828 views

Is there any way to keep 2 references for a single product?

The use case is like this:

1. A company have managed product numbers to identify products.

2. At some point of time, that company changed the numbering system.

3. However, still many customers request quotation based on the old numbers.

4. Internally the company manages product inventory, purchase, etc. based on new numbers.

5. So we need to keep old and new numbers as references for product at the same time.

If it is supported out of the box by Odoo, can you provide instruction on how to?

If it's not, then how much effor would be needed and can you provide a overall explanation on how to implement it?

Thanks in advance.




Atchuthan - Technical Consultant, Sodexis Inc

--Atchuthan - Technical Consultant, Sodexis Inc--
| 5 5 8
Puducherry, India
--Atchuthan - Technical Consultant, Sodexis Inc--
Passionate coder in Python/Odoo(formerly known as OpenERP).

Contact me via GMail: atchuthantu@gmail.com via Skype: atchuthan_skype
via Linkedin: http://in.linkedin.com/in/atchuthantu
Atchuthan - Technical Consultant, Sodexis Inc
On 12/9/14, 2:16 AM

Try these steps

1. Add a new field 'old_code' or something.
2. Change name_get and name_search function of product.product with old_code also.
3. Show field in TREE view of products
4. Modify search view for product name.
        <record model="ir.ui.view" id="product_product_search_form_view_inherit">
            <field name="model">product.product</field>
            <field name="inherit_id" ref="product.product_search_form_view" />
            <field name="arch" type="xml">
                <field name="name" position="replace">
                    <field name="name" string="Product"
                        filter_domain="['|','|',('name','ilike',self),('default_code','ilike',self),('old_code','ilike',self)]" />

Kibong Moon
On 12/9/14, 3:56 AM

Thanks a lot, Atchunthan!

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/9/14, 1:37 AM
Seen: 828 times
Last updated: 3/16/15, 8:10 AM