Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How to delete a product that has moves?

on 5/8/13, 1:01 PM 1,826 views

I have defined some products with the wrong kind of Uom. The only way I found out is to define a product with the good Uom is to define a new product with the good Uom.

The problem is now I cannot delete the wrong product because there are product moves involved.

I first have to delete the involved product moves.

But the product moves cannot be deleted because they are not in the draft state.

How to end this float of new problems?

How to troubleshoot this (maybe also some quotations and orders in process) and set the product move to draft state?


Francesco OpenCode

--Francesco OpenCode--
| 5 7 9
Grottaglie, Italy
--Francesco OpenCode--

Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese

Francesco OpenCode
On 5/8/13, 1:10 PM

You can't do this. You can only set the active value of product to False so OpenERP doesn't show it to you and doesn't consider it in the function but keep it in the database.

I hope you are wrong. If your are right suggestion is ok. An other thing as a workaround is to rename the product in reserve 1/2/3/etc and reuse it in the future. I wait some time for answers from others before accept this as "the" answer.

on 5/9/13, 6:07 AM

Hi, never delete record in openerp when id is present in an other table, else you will have some errors if you do not delete records which have the id present, can you check all tables to find this id ?, use active field, it is made for that. Bye

Cyril Gaspard (GEM)
on 5/11/13, 9:13 AM

@GEM "active field" Is this a software tool plug in windows linux or a method to be sure or something else?

on 5/12/13, 6:15 AM

@toni, active field is a fields.boolean in a lot of class, if the field is set to True, the record will be invisible in the list view, this is just a filter in the view made by openerp, record is again in postgresql tables, you can refind its in the view by doing a manual filter in the list view with active = True. bye

Cyril Gaspard (GEM)
on 5/14/13, 5:27 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 5/8/13, 1:01 PM
Seen: 1826 times
Last updated: 3/16/15, 8:10 AM