Skip to Content
This question has been flagged
OdooodooimportingImportingImportingissue
1 Reply
1636 Views
Avatar
Ajji

Hey, I am importing some data in odoo let say Products, Now while importing I am getting multiple select options for that filed and among them two are Database ID and External ID,

Can anyone please clear this difference, which one to choose when and why and their major differences so that it will be understandable.

Thankyou in advance and looking to get a best answer.

Avatar
Discard
Avatar
Chris TRINGHAM
Best Answer

The field ID is set by Odoo and is an integer.  As far as I know you can't set it.  This is also how database tables are linked.

The External ID can be set during import, and is designed for linking to an external system (e.g. you import your data from SAP Business One).  Or you assign your own sequence.

If you don't set an External ID, Odoo will assign one when you first export the data, and it contains a random set of numbers and letters such as __export__.product_template_24_d30bc908

When exporting and importing you must use the External ID (and cannot change it)

Avatar
Discard
Related Posts Replies Views Activity
Importing Sales and Purchase orders
Importing
Avatar
Avatar
2
Aug 24
1391
How do you add direct attributable cost to an asset...
Odoo
Avatar
0
Oct 22
796
How to get view type in Odoo 8 Solved
Odoo
Avatar
Avatar
Avatar
3
May 25
4758
Report Actions Button(ir.actions.report) and Domain
Odoo v15
Avatar
Avatar
Avatar
Avatar
3
Aug 24
5398
eBay Error
ebay Odoo
Avatar
0
May 24
1213