Difference between DatabseID and ExternalID in Odoo importing

Question

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.

Chris TRINGHAM · 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
Wh

Related Posts	Odgovori	Prikazi
Importing Sales and Purchase orders Importing	2 avg. 24	1585
How do you add direct attributable cost to an asset... Odoo	0 okt. 22	796
How to get view type in Odoo 8 Solved Odoo	3 maj 25	4907
Report Actions Button(ir.actions.report) and Domain Odoo v15	3 avg. 24	5771
eBay Error ebay Odoo	0 maj 24	1377

This question has been flagged

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