This question has been flagged
3 Replies
6528 Views
productdeletecategory
Avatar
calvin ma
When delete product category, it shows:

error:
The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead. Model: Product Template (product.template), Constraint: product_template_categ_id_fkey

Is there a way to delete an empty product category completely?



Avatar
Discard
calvin ma
Author

Thank you Chris! Thank you for your kindly answer. Your answer solves the problem that cannot delete the product categories. ( Need to delete the Archived products first, then delete the product categories). And thanks to Niyas, you point out the problem. 

Avatar
Chris TRINGHAM
Best Answer

You can delete product categories that aren't used. However, if products have been archived rather than deleted then the count will be 0 (see below) but you still cannot delete the category, so it's better to create another category for archived products.

It's possible to select archived products in the Product List and group by product category:


To check whether there any active products for any category:

Avatar
Discard
Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

The product category that you tried to delete is referenced in some another tables, that's why you are not able to delete the product category.

So if you really need to delete this product category, you have to delete it from the places where it is referenced, as per the error message that you get the product category is used in the table product.template , so you have to remove it first and then delete the product.


Or easily instead of deleting you can set Archive the record, which brings almost same functionality of delete.


Thanks
Avatar
Discard