Product Catalog - design
We are facing an issue in designing a particular solution in Microsoft commerce server2002 Catalgos module.
Each product can be under the combination of any of the following category
1.Brand
2.Type
3.Pack
The relation between the product and the categories are
product to brand is 1:1
product to Type is 1:M
product to Pack is 1:M
Product A belongs to { Brand A , Product Type A and pack Type A }
Product B belongs to { Brand A , Product Type (A&B) and pack Type A }
Product c belongs to { Brand B , Product Type (A&B) and pack Type A }
I am having two solution in designing the follwing Requirements in Commerce server
Ist Solution :
By keeping the Brand(A,B,C) , Product Type(A,B,C) and Packtype(A,B,C) as category
and assign the product to the respective categories.
Limitation that i am facing:
If i am searching via Product type i am not able to identify which Brand or Pack type a product belongs to. Here i have to explicitly search from the search option available from the
2nd Solution :
By keeping Product Type and Packtype as properties (Multiple choice option) in Product Definition and assigning the product to the Brand(A,B,C) category;
Limitation that i am facing:
For Business user this is hard for him to search He needs to give explicitly give the corresponding "Brand","Product Type" and "Packtype" to find the particular product.
Please Suggest me a solution which will help me in displaying all Brands,Product Type,PackTypes and its Product details in Bizdesk and in Site.
