Odoo Help


Best structure for ERP Service

John Baldwin
on 11/21/13, 6:48 AM 2,416 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

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

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: 2416 times
Last updated: 3/16/15, 8:10 AM