Odoo Help


Change Internal Reference to unique

on 9/30/14, 4:31 AM 1,449 views

How can I change that the Internal Reference of the Products in Warehouse is an unique value?

On 10/3/14, 2:03 AM

Thanks for you answer. I managed to make the value unique by inheriting the product module. This page explains how to write a costum module http://www.pixelite.co.nz/article/adding-additional-fields-using-custom-module-openerp-7.

Here the python file (if someone wants to do the same):

from openerp.osv import fields, osv

class unique_reference(osv.osv):

   _inherit = "product.product"

   _sql_constraints = [
        ('uniq_defaut_code', 'unique(default_code)', "A external reference already exists with this name . External reference must be unique!"),




Ludo - 21South

--Ludo - 21South--
| 2 2 5
Zwijndrecht, Netherlands
--Ludo - 21South--


Ludo - 21South
On 9/30/14, 6:10 AM

You need to add some custom code, inheriting the product module and adding a constraint to the field. That will make it unique, even with a small message telling the user their input should be unique.

By default I don't think there is any module that does this for you, although I would be happy to proven wrong.

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

2 follower(s)


Asked: 9/30/14, 4:31 AM
Seen: 1449 times
Last updated: 3/16/15, 8:10 AM