Skip to Content
Menu
This question has been flagged
7 Replies
4335 Views

Hi guys I'm trying to delete a product but when i hit Delete it said this

[object with reference: Change Product Quantity - stock.change.product.qty]

I don't know what to do. Please help.

Avatar
Discard
Best Answer

Hi,

You are getting this error message because, the product you are trying to delete is referenced/used in some other model, you can see the model name in the warning message.

So to delete this record, first of all you have to delete those records which referenced this product. Once you clear those record and click on the delete button of the product, there willl be no issue.


Thanks

Avatar
Discard
Author

Thanks Niyas. By models you meant these stock.change.product.qty ? Where do i find these items? Thanks again

This model seems to be transient model, which does not store data in the table, can you try to delete the same once more and see whether you are getting the same message

Author

I'm still getting the same message. It's not working

Author

Nothing I can do to remove this record. Odoo is so difficult to use.

Best Answer

"So to delete this record, first of all you have to delete those records which referenced this product."

This is Obvious. So… let's delete the stock count for this product: 

"You cannot delete a stock count if it is authorized"

Oeps... so the question here actually is: How to delete an authorised stock count?  Because this is the only reference the product has and without this one deleted, the product can't be removed.

The answer: You cannot delete an authorised stock count. period.

Archiving the product is also not a streight forward option because you cannot upload the same product (ID) to Odoo if there is an archived version of the product.

Shortest solution: Archive the product and re-enter the product with a new ID. Of course this only works if we are talking about one or two products. If you have to manipulate several thousand products. Manipulating the database directly probably will be the only option.





Avatar
Discard
Author Best Answer

What do you mean by transient? I don't know why odoo is hard to use???

Avatar
Discard