Apparel Addon Fields

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I need to create a catalog from the ProductCart v3.11a for an EDI system. 

1. I need some clarification on the "products" table fields. Assume the idProduct=8215. If I query on idProduct=8215 AND pcprod_apparel=1, I would get the parent product, correct? If I query on pcProd_apparel=0 AND active=0 AND removed=0 AND pcprod_ParentProd=8215, I should get all of the associated sub-products - Is this correct?
What is the field pcprod_Relationship (8215_2901)... the first part is the idProduct, what does the second number reference?

2. Are the fields idOptionGroupA, Arequired, idOptionGroupB and Brequired relics from previous versions?

3. Should I use options, option_groups and options_optionGroups to extract apparel products?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rmeinhart Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-April-2008 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote rmeinhart Report Post Thanks(0) Quote Reply Topic: Apparel Addon Fields Posted: 20-May-2008 at 10:10am
	I need to create a catalog from the ProductCart v3.11a for an EDI system. 1. I need some clarification on the "products" table fields. Assume the idProduct=8215. If I query on idProduct=8215 AND pcprod_apparel=1, I would get the parent product, correct? If I query on pcProd_apparel=0 AND active=0 AND removed=0 AND pcprod_ParentProd=8215, I should get all of the associated sub-products - Is this correct? What is the field pcprod_Relationship (8215_2901)... the first part is the idProduct, what does the second number reference? 2. Are the fields idOptionGroupA, Arequired, idOptionGroupB and Brequired relics from previous versions? 3. Should I use options, option_groups and options_optionGroups to extract apparel products?
	Bob Meinhart