c2c-oerpscenario team mailing list archive

[Steffi Frank <344562@xxxxxxxxxxxxxxxxxx>]

I do agree with jdetaeye: 
it is absolutely necessary to ensure an uniqueness in the product form – not only in the database through an ID. Normally in ERP systems you find a ‘code’ which is unique and a column ‘name’ . Fabien: your example ‘lots of companies with the same name” is right. But even here you should ensure that through code the uniqueness is guaranteed!

Fabien, let me comment your blueprint:
“You have several cases where you can have different products with the same name.” 
Yes, same name but different codes! If the same product (code and name) is listed e.g. in product.tree while ‘choosing product in sales order line’ – how to ensure the user chooses the “right one”? You have to have ALL fields in the product.tree to be able to identify the differences

“A product has been desactivated (not deleted). It's not visible in the system but you want to create another one visible with the same name”
Sorry, but this will never be standard in industrial companies! If a product is deactivated it means: this product with all its parameters and configs is no longer produced/sellable/to purchase. A similar product would be created with new code and/or name to ensure the correct history in reporting and statistic. 

“You import products from another software where you have several products with the same name”
Sorry, I wonder if there is any serious ERP application where you will find products with same name AND code….

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/344562

Title:
  product: uniqueness of product name isn't guarantueed

Status in OpenObject Addons Modules:
  Invalid

Bug description:
  
  It is possible to create multiple products with the same name and/or code. 
  There seems to be no way to garantuee uniqueness of the products.

  This may work well internally within Open ERP, but creates big trouble when creating sales orders or purchase orders for such duplicate items:   
     customer:  "I want to buy 10 pieces of part X"
     open erp:  "oops, I have 3 parts all called X. Which one do you want?"  :-)

  I am using the GTK Client on version 5.0.0