Importing and Exporting Data | Getting Started

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:

Need more information about Odoo apps?

[muhammadfaisal_]

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

[roysukamto]

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_]

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.?

[omermuhammad]

is there anyway to input data to odoo from Linkedin?

[ener-top]

i dont have the export option, what can i do