Customizing ProductCart - Apparel Addon Fields

Print Page | Close Window

Apparel Addon Fields

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=1641
Printed Date: 22-April-2025 at 5:14pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Apparel Addon Fields

Posted By: rmeinhart
Subject: Apparel Addon Fields
Date 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