Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
5946 Vistas

I have a structure like this:


ACME

-- ACME East

------ Mark Jones


ACME and ACME East are companies, Mark is a contact at ACME East.


I read at \https://www.odoo.com/forum/help-1/question/multi-level-customer-structure-how-can-i-add-a-subsidiary-to-a-company-record-not-a-contact-i-need-a-grandparent-parent-child-hierarchy-for-my-customer-record-122659 that this structure is supported.


How can I structure my Excel/CSV import files so that I can import thousands of contact and company records?



Avatar
Descartar
Mejor respuesta

Use a file like this:


Note: ID is to uniquely identify the record - it is like a social security number or national identification number for the record [your previous system may already have one] and is needed because you will be importing TWICE.


The first import will create the records without any relationships.

The second import will update the record to add the relationship.


ID is also used if you are importing prior to Go Live and want to do another import at Go Live, so you can UPDATE any record where emails or phone numbers change and ADD any record where new Companies or People are added.


Your first import will be like this:


Note that you are NOT importing the Parent (because it doesn't exist and unless you can sort your file so that all grandparents and parents are before all children Odoo won't find the Parent because it won't be created)


Your second import will be like this:



When you are done with both imports, you will have this:




Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
9
ago 20
7155
1
ene 24
1803
1
ago 24
1654
9
nov 22
10668
1
sept 21
4152