Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

How are people leveraging the "Deployment (Dev, Staging, Production)" pattern for Website changes (made using the UI page editor)

Subscribe

Get notified when there's activity on this post

This question has been flagged
communitygitwebsite
1 Reply
4686 Views
Avatar
DJ

I'm looking for a way to have branches for an Odoo installation's stages(dev, staging, production), specifically focusing on changes of the Website, made by website editors using the gui editor and not code. 

I've seen where Odoo.sh and other integrators have used git, but is that just for module/app code? Or would it also handle qweb additions/changes as well. 

It seems to me that I'd want to have some kind of versioning control for the postgres db as that's where I believe the qweb changes are stored.

Am I on track with my understanding?

Thanks for your help/advice.

3
Avatar
Discard
Avatar
S.M Firoz Ahmed ( Daffodil Software Limited )
Best Answer

You are correct that using version control for Odoo is a good way to manage different branches for different stages of your installation. Git is commonly used for version control in Odoo, and it can handle both module/app code as well as QWeb additions and changes.

When you make changes to the website using the Odoo GUI editor, those changes are typically stored in the Postgres database. To version control these changes, you can use git to track the changes in the database.

Here's an example of how you can set up version control for your Odoo website:

  1. Create a git repository to store your Odoo code and database.

  2. Use the Odoo Backup module to export the database from your production server.

  3. Commit the exported database to your git repository.

  4. Set up a development and staging server, and clone the git repository to these servers.

  5. Use the Odoo Backup module to restore the database to your development and staging servers.

  6. When you make changes to your website in development or staging, use the Odoo Backup module to export the updated database and commit it to your git repository.

  7. When you're ready to deploy changes to your production server, merge the changes from your development or staging branch to your master branch, and restore the updated database on your production server.

It is worth mentioning that the above approach is just one way to handle version control for the website changes.

Also, it's important to keep in mind that version controlling the database is not enough, it's also important to version control the files and addons, as well as the custom code that you wrote.

2
Avatar
Discard
Awais Abid

Hi Firoz,
Thank you for providing these details. One question though, what if there are some changes in the ir_attachment table and some image references are added to the website page? How would we handle this :)

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Change domain name of my website in odoo community edition Solved
community domain website odooV13
Avatar
Avatar
1
Dec 22
13138
Alt/Title tags on images (website module) Solved
community seo website 12
Avatar
Avatar
1
Dec 19
7032
What’s the best architecture to manage multi-tenant odoo community setup with white-label support?
community
Avatar
Avatar
1
Oct 25
1711
How do I remove the numbers from the slugs in my blog and blogpost? Solved
website
Avatar
Avatar
Avatar
Avatar
3
Sep 25
2690
Login Website Solved
website
Avatar
3
Oct 25
149265
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now