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.


data migration from sage to openerp

Selemun N Tesfaezgi
on 7/11/13, 1:22 PM 3,182 views

what are the information needed to migrate data from SAGE to openerp?


AJ Schrafel Paper Corp

--AJ Schrafel Paper Corp--
| 4 5 8
Bronx, United States
--AJ Schrafel Paper Corp--

Exploring OpenERP for business

AJ Schrafel Paper Corp
On 7/11/13, 1:34 PM

you should export all your information from SAGE into a CSV file. You can then change or add column headers so that openERP automatically knows what column to put the data in. Each data type needs to be put in separate CSVs.

For instance - you cannot import partners and sales orders at the same time. you need to upload the partners, then map the ID created in openERP to the partner field in openERP to the sales order CSV you are uploading.

This is pretty simple, but it is not an instant process, you should take some time to learn exactly what the columns in openERP do. Don't assume a column name means what you think it means or that SAGE will export all the columns you need to get your data into openERP seemlessly. Like if you have accounting installed, you must import the partners with the proper AR and AP accounts, or you will be prompted to add that information manually later.

Many partners also offer migration services. It might be worth your time to get a quote from some experienced in migration.

Another option is to use the CSV files, and read them by script. Than you can do additional checking/modifying. And you do not have to edit the CSV-file for the orders, use the ID of SAGE to search the user (have to add a field, like sage_id, to res.partner though).

on 7/11/13, 3:13 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

2 follower(s)


Asked: 7/11/13, 1:22 PM
Seen: 3182 times
Last updated: 3/16/15, 8:10 AM