Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Odobritve
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Estate Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
Pomoč

Is there an easier way to import contacts within a company than doing it one by one?

Naroči se

Get notified when there's activity on this post

This question has been flagged
contactsimporting
9 Odgovori
8022 Prikazi
Avatar
Andrew Castillo

I need to import several contacts, lets say one company has 2 contacts. And other company has 3 contacts; How do I add these contacts to their company without doing it one by one? Since each company has 3 or more contacts. Is there a faster way for doing it? 

0
Avatar
Opusti
Chris TRINGHAM

When you say "company" do you mean a vendor (supplier) / customer?

Andrew Castillo
Avtor

I mean customer contacts.

Andrew Castillo
Avtor

I mean the contacts you set within a Company.

Avatar
Ermin Trevisan
Best Answer

Export your contacts and reimport them with the corresponding company relation.

 

Step 1: Import the contacts of type "Company":

Step 2: Edit your contact file and remove all contacts of type "Company", rename the field containing the related company name of the contacts to "parent_id"



Step 3: Import the edited file:


For reasons of data integrity, I would not check "Create if doesn't exist", but rather correct the import file, if it contains invalid data. But it's up to you, if you check it, you can save Step 1 and import all contacts at once, but you may have incorrect companies saved then (for example when your import file contains typos).

This is the result after successful import:



Enjoy!

1
Avatar
Opusti
Andrew Castillo
Avtor

How do I establish the company relation?

Ermin Trevisan

Do manually enter such a contact as a company contact and export it.

Andrew Castillo
Avtor

Still, I have to add the contacts manually?

Ray Carnes (ray)

Manually enter a Company. Manually enter a Contact for that Company. Export the Company. Export the Contact, including the Company (Related Partner field). This process will help you understand how to create your own files for importing Contacts attached to Companies.

Avatar
David Gee
Best Answer

thank you for your input, but isn't there a easier way, I have multiple thousand companies plus contacts to enter.

0
Avatar
Opusti
Ermin Trevisan

I have updated my answer, so it should be easy even for thousands of contacts.

David Gee

thank you Ermin!


De : Ermin Trevisan <trevi@twanda.com>
Envoyé : mardi 25 août 2020 16:13:45
À : David Gee
Objet : Re: Is there an easier way to import contacts within a company than doing it one by one?
 

I have updated my answer, so it should be easy even for thousands of contacts.

Sent by Odoo S.A. using Odoo.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
How do I know what field to import in to?
import contacts importing
Avatar
Avatar
1
jan. 24
2494
importing contacts. Getting blocking error: Contacts require a name at multiple rows
contacts
Avatar
Avatar
Avatar
2
okt. 25
821
Blocking Errors
contacts
Avatar
Avatar
1
okt. 25
686
O18 EE: Completely unknown email addresses in the contacts?
contacts
Avatar
Avatar
Avatar
2
okt. 25
852
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y'
importing
Avatar
Avatar
Avatar
3
jul. 25
3173
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now