Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
7 Odgovori
4791 Prikazi

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
Opusti
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
Opusti
Avtor

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

Avtor

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

Avtor

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
Opusti
Avtor Best Answer

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

Avatar
Opusti