Odoo Help

2

How to move products and customers data to a new company?

By
Xiu RDi SL
on 2/8/13, 9:06 AM 1,688 views

We need to create a new company and import all products description and also all customers data.

how to do it easyly?

Thanks,

Enric

1
Abner Galeno Jr.
On 2/8/13, 10:18 AM

I'm only using OpenERP version 7, and since I'm new, I'm not sure if it will be always easy but I have tested exporting from and importing back to OpenERP, and they work fine.

First, make sure to check [✓] the option Allow users to import data from CSV files under

Settings Module -> Configuration -> General Settings -> Import/Export

Now, you can go to the list view of your [old company] products or customers, check [✓] those you would like to copy to the new company, click the [More] button (near print button at the top) and click Export. There will be a lot of field names that you may include, but you can just double click the field names that you want, on the left pane, so that they will included during the export. Just leave all the other default settings and click [Export to File] to download your .csv (comma separate values),

[optional] If you want, you can edit product.product.csv or res.partner.csv in Microsoft Excel and edit them. Last time I used LibreOffice calc, it butchered my CSV file, so I'm sticking with excel for now.

You can now import the .csv file from the old company to your new company, using the same products or partner/customer list view. You can validate your csv file data before you Import and you will even see a preview of the data before you insert or update to the company database.

2
Xiu RDi SL
On 2/11/13, 3:17 AM

Thanks! Very usefull

0

Ahmet Altinisik

--Ahmet Altinisik--
2157
| 8 7 10
ANKARA, Turkey
--Ahmet Altinisik--

http://www.altinkaya.eu

Ahmet Altinisik
On 2/12/13, 4:46 PM

csv export and csv import is the easiest way. You should also export and import related models like bill of materials.

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.

Register

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)

Stats

Asked: 2/8/13, 9:06 AM
Seen: 1688 times
Last updated: 3/16/15, 8:10 AM