Importing and Exporting Data | Getting Started

Learn everything you need to grow your business with Odoo, the best open-source management software to run a company, at www.odoo.com/slides.
In this video, learn how to import and export data in Odoo! We will cover exporting information and selecting different options to export. Then we will move on to importing information and using export-compatible data and sample import templates.
0:00 - Introduction
0:44 - Contacts App (List View)
1:21 - Action Button - Export
1:55 - Update Data - Import Compatible
2:24 - Export Options
3:14 - Export File
3:54 - Favorites - Import Records
4:23 - Template Importing
4:51 - Importing File
5:21 - Processing the Import
6:31 - Tips and Tricks
6:45 - Import Test
6:54 - Conclusion
Other lessons related to this video:
-Navigate in Odoo : • Navigate in Odoo | Get...
-Chatter Basics : • Chatter Basics | Getti...
-Odoo Discuss : • Odoo Discuss: Direct M...
-Odoo Discuss: Direct Messages & Voice/Video Calls : • Odoo Discuss: Direct M...
-Odoo Discuss: Channels | Getting started : • Odoo Discuss: Channels...
-Odoo Calendar : • Odoo Calendar | Gettin...
Need more information about Odoo apps?
www.odoo.com/documentation/user
Discover Odoo, schedule a demo, or start your own Odoo revolution for free (no credit card required), at www.odoo.com.

[@muhammadfaisal_1995]

The Analytic accounts on Journal Entries importation gave me a real thought time.

[@roysukamto1297]

Great information, thank you for sharing. One question: if we want to import product with variant do we have to import the product template (product/product) and the product (product/product template)

[@Trashpanda_404]

Thanks for all of the videos brother! We have the same weird dry sense of humor, so it makes watching these awesome. Great dry minds think alike? 🤔 🤣
The one thing that Odoo makes SO confusing; When you select the dropdown arrow on the right of the field name, sometimes it shows repetitive fields from the hierarchy or other child fields in other tables.
Do have one question; I have approx 40k products to import. How could I import all of the data at once? Should I just connect directly to the database itself? Expanded the table for additional fields, and know the mapping/structure is 100%. Have tested a handful of items on upload, so I’m not worried about that. Plus I made a backup god forbid something is wonky.

[@butirpadi]

after export to excel, then input the update data, then import to database, but it differrent database (duplicate database from first db) why it can not replace existing data, but create new data.?

[@brunorocha2317]

Since the database is different the External ID is also diferent so you end up creating new fields and dont update the current ones

[@omermuhammad2933]

is there anyway to input data to odoo from Linkedin?

[@ener-top]

i dont have the export option, what can i do

[@brunorocha2317]

Is on the Settings menu for your user, something like Allow export

[@realadnoh]

you also NEED to be in listview - IDK why this is designed in such an unusual way, but only there you can export

[@MouseTrack]

Check favourites tab...