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?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
784
Views
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 |
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
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
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.
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.