Odoo Help


This community 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.


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

Christopher Hart
on 9/11/14, 1:57 PM 1,813 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 Yelizariev
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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 9/11/14, 1:57 PM
Seen: 1813 times
Last updated: 3/16/15, 8:10 AM