Odoo Help


How to add « external-id» column to product.template.product.tree?

Pascal Tremblay
on 10/2/14, 1:16 PM 3,923 views


I already have « database id » and « code » columns in my product.template.product.tree view. I'm very happy of this.

But I would also want an « external id » column. How could I make it?

An idea?



On 10/13/14, 2:38 PM

The external_id is stored in a separate table from product.template.   The separate table is ir_model_data.

So you cannot just add it to your existing tree view definition.

To make the external_id to show in your tree view you must:

  • Make a view in the database for the product_template table joined to the ir_model_data table to get the external_id.  (Join on the res_id and model fields and get the external_id from the "name" field).
  • Create a model of the columns that are returned from the view.  This would be the same as the product_template model plus the external_id.
  • Then make a tree view that uses that model. 

So you'll have  few steps to do to get that to show.

It is much simpler to just use the export option and select the "id" column which will cause the external ID to be exported. Then view it in a spreadsheet. 






Pascal Tremblay

--Pascal Tremblay--
| 5 3 7
Alma, Canada
--Pascal Tremblay--

Pascal Tremblay
On 11/15/14, 7:13 PM

<field name="default_code"/>

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: 10/2/14, 1:16 PM
Seen: 3923 times
Last updated: 3/16/15, 8:10 AM