Skip to Content
This question has been flagged
1 Reply
1368 Views
Avatar
J C

In our current system (CE 10) we have imported 10 000 products through the import excel function of Odoo. But as we realize now there is more info needed in the product card than our initial import. Info like Vendors and prices of those vendors (in the inventory tab of the product template). Basically it needs a second import where we could only import that part of the product card (without overwriting or creating new articles). It's basically an add function where the new import fills those empty fields of the already existing products...

I've tried several ways but Odoo always creates new articles or overwrites old ones with other info, even with the external IDs respected.
What would be the best way to do this with such a massive database without messing it up??
​

Thanks

Avatar
Discard
Avatar
Waleed Ali Mohsen
Best Answer

As I understand from your question, you imported product data and then you found that you missed some data and want to import it.

So you can export the product with their Ids and then remove all fields which you want to update and add other missing fields to the sheet and import it. Ids field will be used to identify if to create new or update exists one.

https://www.odoo.com/documentation/user/10.0/general/base_import/adapt_template.html

Here you are a useful youtube video for Odoo import export tricks:

https://www.youtube.com/watch?v=PEp3JFWYxVw

Avatar
Discard