Odoo Help


Best structure for ERP Service

John Baldwin
on 11/21/13, 6:48 AM 2,045 views

I am new to OpenERP and have several clients waiting for me to develop an industry specific ERP solution. I would like to use OpenERP but I am struggling to find the best way to structure my offering. I want to configure and customize the initial set-up to be the same for each client without repeating it on several databases. Yet I would like each client to have their own DB.

Multi-Company set up seems to use one database for multiple clients, which scares me because IF I have an issue with that database all my clients would be down for the duration and possibly all data lost! Scary scenario.

So if some of you OpenERP guru's could suggest the best way to go, I would very much appreciate it.. I'm sure there has to be a way to duplicate the database set-up with all modules installed, I just can't find it.

Ray Carnes
On 11/21/13, 3:39 PM

1) From the login page, click Manage Databases

2) Use the Duplicate menu

image description

Note: The multi-company feature's purpose is for companies that are part of the same group and are sharing specific information with each other (eg. customers list or accounting information for consolidation). Therefore, they need to be in the same database and a "Company" field will exist on records to specify whether a record belongs to one company or another. If the companies you are dealing with are completely independent, you will want to have a different database for each of them.

John Baldwin
On 5/15/14, 6:00 PM

A simple way to duplicate your database to look like the initial one and with all the same modules will be for you to not all the modules you have installed in the initial database (this can be done by going to Settings>>Modules and select clear first then select Installed). Write all this modules here down. Export your database normally and save it somewhere (usb flash disc, external hard drive etc) you can restore on any new OpenERP application then load the same modules you noted from the initial database. some feature might not copy over like user password so you may have to redo those

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

0 follower(s)


Asked: 11/21/13, 6:48 AM
Seen: 2045 times
Last updated: 3/16/15, 8:10 AM