Deleting a product doesn't delete record in product_template table

Hello James,

This is a not a bug this is a normal behaviour of the tiny for product, as per product template is main class in terms of the coding.
when we create any product a product templates is also created as according to the tiny specification define for product and product template as may be you can defined the various variant based on the template so this is the main purpose of the template.

Regards,
MGA

Hi,

Thanks for the quick reply. I noticed that the menu for Product Templates will only available after installing product_variant_multi module. Is there a way to delete a product template when I have only the product module installed? The only menus available under products are:

Configuration
  Products Categories
  Packaging
  Units of Measure
    Units of Measure Categories
    Units of Measure
  Prices Computations
    Prices Types
    Pricelists Types
Products by Category
Pricelists
  Pricelists
  Pricelist Versions
Products

As earlier stated, deleting a product by going to the products list (clicking the last available item in the above list) and deleting it from there still leaves a record in product_template.

Hello,

"Product Templates will only available after installing product_variant_multi module" this is because the product_variant_multi module enables the Product Template menu actually Product Template is a Base Object for the Product and it comes from the Product module sit self.

Product is Inherits Product Template and use the properties of the Product Templates.

when you create an Product according to inheritance definition it create a 2 records
1. Product - store attributes which is specially defined in the product
2. Product Template - store attributes which is defined in Template

so, ow when we read Product it reads 2 Object
1. Product + 2. Product Template

Now, you are going to delete a Product, of course it will not delete the Product Template. and you can able to delete the Product because Category is not a field of Product Objects actually it comes from the Product Template. so if you want to Delete the Template first you have to delete all links to Template "in terms of database relations" but there is no special way to delete Product + Product Template if you delete Product

Regards,
MGA

Then... which is the correct way for deleting a product category in openerp?

I get alway the message:

null value in column "categ_id" violates not-null constraint
CONTEXT: SQL statement "UPDATE ONLY "public"."product_template" SET "categ_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "categ_id""

"which is the correct way for deleting a product category in openerp?"
You have to create window action related to model "product.template" and to view "product.template.product.tree".
Then create menu item linked with this window action.
After opening the list of templates you can delete them and then delete categories.