Skip to Content
Menu
This question has been flagged
3 Replies
7733 Views
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
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. 

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
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
Related Posts Replies Views Activity
3
Nov 22
15093
2
Oct 22
1641
1
Aug 20
3164
0
Sep 19
1982
1
Mar 15
30211