Hi,

In Odoo, you cannot directly delete a product if there are related stock moves, especially if the moves are in a “done” state, because this would break the integrity of your inventory and accounting records. The system enforces this via foreign key constraints on the stock.move model. For stock moves that are done, Odoo only allows correction of quantities, not deletion. Essentially, the available options for a stock move in this situation are:

    Correct the done quantities: Adjust the move via an inventory adjustment or a reversal to set the stock levels back to zero.

    Cancel future moves: Only moves that are not done can be canceled or deleted.

    Archive the product: While this does not remove it from the database, it prevents it from being used in future transactions.

If you need a clean database, the safest approach is either to revert the done stock moves using inventory adjustments and then delete the product (only possible if all related moves are undone) or, in a development/testing environment, manually remove the records via a database script. In a production environment, directly deleting done moves is strongly discouraged because it can corrupt stock and accounting data.

Hope it helps.

You can delete it by sql query