Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
660 Vistas

So I can see I need to create a contact within a company to add a delivery and invoice address. However, can I import new customer with invoice and delivey addresses? Or do I need to make seperate imports?

Avatar
Descartar
Autor

Ok but how do I tie the contacts to the company? I can see a child external id, but not a parent external id

I might be getting you wrong, but, the tying part is based on the columns 'Name' and 'Related company'. If they hold the same value and are in subsequent order, you should be good to go.

Autor

That makes sense, but ive been trying to import all kinds of things all day and I have found that I need to use very specific fields, mostly external id’s. However, figuring out which ones are the ones I need are difficult to identify. So if I create the customers first, then using the name is creating an error.

Mejor respuesta

You can import both from one file, when structuring it correctly. That 'correctly' part is described - with your actual use case as an example - here in the documentation: https://www.odoo.com/documentation/18.0/applications/essentials/export_import_data.html#import-one2many-relationships

Your file should look like this (most crucial parts bold and italic):

Name Is a company Related company Address type Customer Supplier Street
House Sales Direct 1

1 0 104 Saint Mary Avenue
Yvan Holiday 0 House Sales Direct Contact 1 0 104 Saint Mary Avenue
Jack Unsworth 0 House Sales Direct Invoice address 1 0 227 Jackson Road
International Wood 1

1 0 748 White House Boulevard
Sharon Pecker 0 International Wood Invoice address 1 0 755 White House Boulevard

Avatar
Descartar
Mejor respuesta

Hi,


Please refer to the following for importing the customers and vendors.

https://www.cybrosys.com/blog/how-to-import-customers-and-vendors-in-odoo-17


Hope it helps

Avatar
Descartar