|
1 | 1 | ==================================
|
2 | 2 | How to import contacts to the CRM?
|
3 | 3 | ==================================
|
| 4 | + |
| 5 | +In Odoo CRM, you can import a database of potential customers, for |
| 6 | +instance for a cold emailing or cold calling campaign, through a CSV |
| 7 | +file. You may be wondering if the best option is to import your contacts |
| 8 | +as leads or opportunities. It depends on your business specificities and |
| 9 | +workflow: |
| 10 | + |
| 11 | +- Some companies may decide to not use leads, but instead to keep all |
| 12 | + information directly in an opportunity. For some companies, leads |
| 13 | + are merely an extra step in the sales process. You could call |
| 14 | + this extended (start from lead) versus simplified (start from |
| 15 | + opportunity) customer relationship management. |
| 16 | + |
| 17 | +- Odoo perfectly allows for either one of these approaches to be |
| 18 | + chosen. If your company handles its sales from a pre |
| 19 | + qualification step, feel free to activate first the lead stage as |
| 20 | + described below in order to import your database as leads |
| 21 | + |
| 22 | +Activate the lead stage |
| 23 | +======================= |
| 24 | + |
| 25 | +By default, the lead stage is not activated in Odoo CRM. If you want to |
| 26 | +import your contacts as leads rather than opportunities, go to |
| 27 | +:menuselection:`Configuration --> Settings`, select the option **use leads |
| 28 | +if…** as shown below and click on **Apply**. |
| 29 | + |
| 30 | +.. image:: ./media/import01.jpg |
| 31 | + :align: center |
| 32 | + |
| 33 | + |
| 34 | +This activation will create a new submenu :menuselection:`Sales --> Leads` |
| 35 | +from which you will be able to import your contacts from the |
| 36 | +**Import** button (if you want to create a lead manually, :doc:`click here <manual>`) |
| 37 | + |
| 38 | +.. image:: ./media/import02.jpg |
| 39 | + :align: center |
| 40 | + |
| 41 | +Import your CSV file |
| 42 | +==================== |
| 43 | + |
| 44 | +On the new submenu :menuselection:`Sales --> Leads`, click on **Import** and select your |
| 45 | +Excel file to import from the **Choose File** button. Make sure its |
| 46 | +extension is **.csv** and don't forget to set up the correct File format |
| 47 | +options (**Encoding** and **Separator**) to match your local |
| 48 | +settings and display your columns properly. |
| 49 | + |
| 50 | +.. note:: |
| 51 | + If your prospects database is provided in another format than CSV, you can |
| 52 | + easily convert it to the CSV format using Microsoft Excel, OpenOffice / |
| 53 | + LibreOffice Calc, Google Docs, etc. |
| 54 | + |
| 55 | +.. image:: ./media/import03.jpg |
| 56 | + :align: center |
| 57 | + |
| 58 | +Select rows to import |
| 59 | +===================== |
| 60 | + |
| 61 | +Odoo will automatically map the column headers from your CSV file to the |
| 62 | +corresponding fields if you tick *The first row of the file contains the |
| 63 | +label of the column* option. This makes imports easier especially when |
| 64 | +the file has many columns. Of course, you can remap the column headers |
| 65 | +to describe the property you are importing data into (First Name, Last |
| 66 | +Name, Email, etc.). |
| 67 | + |
| 68 | +.. image:: ./media/import04.jpg |
| 69 | + :align: center |
| 70 | + |
| 71 | +.. tip:: |
| 72 | + |
| 73 | + If you want to import your contacts as opportunities rather than leads, make |
| 74 | + sure to add the *Type* column to your csv. This column is used to indicate |
| 75 | + whether your import will be flagged as a Lead (type = Lead) or as an |
| 76 | + opportunity (type = Opportunity). |
| 77 | + |
| 78 | +Click the **Validate** button if you want to let Odoo verify that |
| 79 | +everything seems okay before importing. Otherwise, you can directly |
| 80 | +click the Import button: the same validations will be done. |
| 81 | + |
| 82 | +.. note:: |
| 83 | + |
| 84 | + For additional technical information on how to import contacts into Odoo CRM, |
| 85 | + read the **Frequently Asked Questions** section located below the Import tool |
| 86 | + on the same window. |
| 87 | + |
| 88 | +.. seealso:: |
| 89 | + |
| 90 | + - :doc:`manual` |
| 91 | + - :doc:`from_emails` |
| 92 | + - :doc:`website` |
| 93 | + |
| 94 | +.. rst-class:: text-muted |
| 95 | + |
| 96 | +| Written by Geoffrey Bressan (Odoo) |
| 97 | +| Proofread by Samuel Cabodi (Odoo) |
0 commit comments