Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
1 Vastaa
167 Näkymät

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
Hylkää
Tekijä

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


Paras vastaus

You can delete it by sql query

Avatar
Hylkää