Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I have imported multiple contacts and sub-contacts (e.g. invoice address, delivery address,..) into ODOO.
I realised that my import had errors and need to delete certain invoice and delivery addresses. However, i can only do through lookup's in Excel.
Is there any possibility to export the records in .csv and mark the External ID i want to delete with the import functionality ?
You can not delete the records while importing, but what you can do is do the lookup in Excel and add a column "Active" to your spreadsheet. For the incorrect/duplicate records set this to false. When you import the file these records will be archived in Odoo and you won't see them again unless you specifically search for archived contacts.
If you really want to delete the records, you could overwrite the name of the contact in Excel to, for example, "Delete 1", "Delete 2", etc. Import the file and then search in Odoo in Contacts app for "Delete", select all records in list view and click Action > Delete.
When you export the contacts from Odoo make sure you have selected "i want to update data" so that the first column contains the external ID of the record in Odoo. If you then import the data, the existing records will be overwritten.
As a footnote to Mr. Mens' response, at least in Odoo Ent. 17, instead of True and False, you need to use 1 and 0. His answer helped me!!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Nov 24
|
2480 | ||
|
1
Nov 24
|
3382 | ||
|
1
Oct 23
|
4153 | ||
|
3
Dec 23
|
21949 | ||
|
0
May 21
|
8596 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
I made a custom field on the list view of contacts with created on date, then created custom filter for created on date and deleted them by multiselect checkbox. You need studio for this method.