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

Hi there, I'm new to Odoo and need some help. I accidentally created a product along with some associated stock moves. Now, I'm trying to delete the product to clean up the database, but Odoo only allows me to archive it—deletion is blocked.

When I attempt to delete the product, I receive the following error:

Validation Error: The operation cannot be completed.  Model: 'Stock Move' (stock.move),  Foreign Key:'Product' (product_id)

So I went to the Inventory module to delete the related stock move, but that too is blocked. The error message says:

Invalid Operation: You cannot delete product moves if the picking is done. You can only correct the done quantities.

I’d really like to remove this product entirely and start with a clean database. Could anyone guide me on how to safely delete the product and its related records, even if the stock move is in a "done" state?

Thanks in advance for your help!

Avatar
Discard
Author

Hi Himani, Can you please explain further. Pretty new to Odoo, not sure how to do this.


Best Answer

You can delete it by sql query

Avatar
Discard