I have large Contacts data that contains information about subcontacts (delivery/invoice) all in one row. Is it possible to import it directly into odoo and make it create a main contact from lets say column 1-3 and a invoice-subcontact linked to the main contact over the Reference from column 4-5 as well as an delivery-subcontact also linked to the main contact with the reference from 6-7?
Example:
Reference | Name | Address | Invoice (Name) | Invoice (Address) | Delivery (Name) | Delivery (phone) |
D55939 | MainContact | MainContactAddress | InvoiceSubcontactName | InvoiceSubcontactAddress | DeliverySubcontactName | DeliverySubcontactPhone |
If that's not directly possible, what would be a working approach to solve this issue?