Odoo Help


Where do website builder template modifications get stored in the db?

Christopher Hart
on 9/11/14, 1:57 PM 3,304 views

I've been using the website builder from 8.0 trunk to build an ecommerce site. From time to time I break something when messing around with the HTML editor. When I get a QWeb error message it asks me if I want to reset a few different templates, and if the one that is actually broken is not listed I just do ./opener-server -u module_name and it resets the correct template.

However, I would like to be able to edit the changes directly in the database in cases where there are other modifications  to the template which I do not want to lose. When poking around in pgadmin I cannot seem to find which table stores the changes from the HTML editor.

Specifically, could someone point me to where changes to website_sale.payment template are stored? I have accidentally broken its context by removing the "for id in acquirer" loop so that it cannot render the input field for the payment acquirer.



Ivan Elizaryev

--Ivan Elizaryev--
| 4 3 7
Ufa, Russian Federation
--Ivan Elizaryev--

I tried odoo at the end of 2013. I fell in love in it and have been working with odoo as a freelancer for almost two years. In September 2015 I began operate as a Company and have 5 developers for now.

Ivan, March 2016.

Ivan Elizaryev
On 9/22/14, 6:23 AM

ir_ui_view is a table you are looking for.

To find id of template in ir_ui_view table by template name you have to check ir_model_data table.

In your case is as follows:

select res_id,model from ir_model_data where name='payment' and module='website_sale';

Then you get id of ir_ui_view record. And there is a template in column "arch"

Thank you!

Christopher Hart
on 9/23/14, 1:33 PM

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