Hello
Alec,
Following are the few thing you can make sure,
-
The Billing Address Is Not Linked to the Company
- When importing, the billing address must be a separate row and linked to the parent company using the external ID (or database ID) of the company.
-
Missing Address Type (Type: Invoice)
- The column "Type" (Field: type) must be set to "Invoice" for billing addresses.
- Similarly, for a shipping address, you must set "Type" to "Delivery".
-
The Address Is Overwriting Instead of Adding
- If the imported address doesn’t have a unique "Name" or "External ID", Odoo may overwrite existing addresses instead of adding new ones.
Also, you can import both billing and shipping addresses for a contact (company or individual) in one go. Odoo allows multiple addresses per contact as long as they are structured correctly in the import file.
Example:
| External ID | Name | Parent ID (External ID) | Type | Street | City | Country |
|---|
company_1 | ABC Ltd. | | | | | |
address_1 | Billing | company_1 | Invoice | 123 Bill St. | New York | US |
address_2 | Shipping | company_1 | Delivery | 456 Ship Ave. | New York | US |
How the above Works:
- The company itself (ABC Ltd.) is imported first.
- Billing (Invoice) and Shipping (Delivery) addresses are added as separate contacts but linked to the company.
- The "Parent ID" column ensures that Odoo assigns the addresses to the correct company.
- Each address has a unique External ID (address_1, address_2) to avoid overwriting.
Also, avoid following mistakes while importing:
-
Missing "Parent ID (External ID)" → The addresses won't link to the company.
-
Duplicate External IDs → Each address must have a unique External ID.
-
Not specifying "Type" → Odoo won’t categorize them as Billing or Shipping.
If this helps, please upvote the answer! 🚀
