Yeah, ProductCategoryRole might be a good model for multiple manufacturers as well, but in a way it would be nice if it were more directly associated with a Product... so I can see that being a possible way to go as well. I guess it depends on how it would actually be used by the people and the automated processes... Is this something that anyone actually has a need and scenarios for right now?
-David Adrian Crum wrote:
I'm looking over David's suggestion of using ProductCategoryRole. Multiple manufacturers could be handled that way - then just ignore the manufacturer field in Product.So, we could have a Product Category called "XYZ Manufacturing Products" then the products they manufacture could be linked to that category. The company itself can be linked to the category through the party ID in the role of manufacturer.Manufacturers and Suppliers are different parties, btw. A supplier could provide the same part from several manufacturers.Chris Howe wrote:Technically, I would think you should make them two separate products and then relate the two products as equivelents. But of course that depends on how detailed the company wants to be. Aside from making them two seperate products, you could treat the manufacturers as seperate suppliers for the same generic product. However, I can think of an example where the current structure is limiting. When the manufacturer or product line is acquired by another company. --- Adrian Crum <[EMAIL PROTECTED]> wrote:There are many examples of standard products thatcan come from multiple manufacturers. If I have a hardware store and I sell 3/4 inch galvanized pipe tees, they could come from three or four different manufacturers. Should I have a separate 3/4 inch galvanized tee product for each manufacturer? I hope not! I used the example of electronic components the lasttime this was discussed - the same holds true there. It IS a limitation. It will come up again, and when it does, I'll continue to make the same suggestion. Chris Howe wrote:why would you have more than one manufacturer forthesame product? wouldn't that make it a different product? I agree that it would be better for amoregeneric product role setup, but if all the rolesareaddressed AND it's not limiting, why go throughthetrouble of refactoring? --- Adrian Crum <[EMAIL PROTECTED]> wrote:I know about the manufacturer field in the Productentity. What do you do if there is more than one manufacturer for a product?That's the limitation that brought forth my original suggestion. Why have a dozen different entities linkingproductsto a dozen different party roles? We could have one entity that linksproductsto any party - regardless of their role. So, one entity could link a product to one or moresuppliers, one or more manufacturers, one or more product managers, etc.Itseems more flexible to me. Chris Howe wrote:The manufacturer is desribed in the Productentity.The only other relationship to a product that Icanthink of is the supplier and that is desribed intheSupplierProduct entity. Having a productmanager,again is probably managed easiest by putting the product into a productCategory and managing the productCategoryRoles on that. Outside of those relationships, can you think of another thatwouldhave to do with a product? --- Adrian Crum <[EMAIL PROTECTED]> wrote:I had suggested some time ago aProductRelationshipentity - where a product can be related to a party, such as a manufacturer.Wouldsomething like that meet your needs? Al Byers wrote:I think I have a need for a ProductRole thatmirrors the ContentRoleentity. I want to associate a manager with aproduct. Is there anotherway to do this? If not, should I just createsuchan entity for thiscustom use or should it be something to proposefor general use?-Al
smime.p7s
Description: S/MIME Cryptographic Signature
