Hi James:
I don't think the product id field was ever intended to be used
interchangeably with such identifiers as SKUs. My understanding of the
data model is that the product id is to uniquely identify the product
within the OFBiz domain only. That is how I have always used it. When I
needed to associate SKUs or other identifiers (for example I use ISBNs),
I use the ID's tab within the Catalog Manager.
Maybe someone who did the original data modeling could comment.
Regards,
Ruth
James McGill wrote:
Product identifiers in our industry are commonly longer than 20 characters.
id and id-ne fields are defined as 20 character fields for all the databases
I have looked at, and there seems to be some tight binding to the 20
character length in forms and screen templates. We are wondering how much
work we would need to do, in order to change Product id's to id-longs. That
sounds pretty big at first glance, since there is so much going on with
Product in so many applications. Another option would be to standardize
some kind of SKU and cross reference that to a domain-specific product ID
but that would be much less convenient for the users.
Please advise.
