콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
1 회신
303 화면

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!

아바타
취소
작성자

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


베스트 답변

You can delete it by sql query

아바타
취소