Skip to Content
Menu
This question has been flagged
1 Reply
2638 Views

Hi all !

I recently discovered that if i want to update my products without losing Qty on Hand & Forecasted Qty i need to have same External ID and name in my CSV and DB when i import.

The trouble is that in my DB i have some products that don't have any External ID, if i export them, set manually an External ID (e.g __custom__.product__0001) it will create a duplicata of the product and lose Qty on hand & Forecasted Qty.... How can i make this work fine ? 

Avatar
Discard

During export external id will be generated for the records created from ui: https://www.youtube.com/watch?v=VKpepIjraMs

Best Answer

External ID is created on export if it doesn't exist already, you need to export products and check ( I want to update data (import-compatible export)) if you need to import them back to Odoo. Once you export, Odoo will export all selected products with selected fields and generate the external ID for all records which doesn't have one. Then you can update the fields you want to import them again to Odoo.

Another solution is to use Database ID (ID) rather than external ID.

Read more about external ID and Database ID here:

Export and import data — Odoo 15.0 documentation

Avatar
Discard
Related Posts Replies Views Activity
1
Dec 19
1479
1
Jan 24
6003
1
Jun 21
1746
1
Jul 20
1641
2
Jul 20
4879