--- title: "Apparel Add-on: Relationship between Parent and Sub-Products" description: "Apparel Add-on: Relationship between Parent and Sub-Products" --- [Skip to content](https://productcart-kb.nsource.com/kb/apparel-add-on-relationship-between-parent-and-sub-products#main-content) [![pc\_logo](https://productcart-kb.nsource.com/hs-fs/hubfs/pc_logo.png?width=162&height=75&name=pc_logo.png)](https://productcart.com/) Open main navigation Close main navigation - - [Contact Support](mailto:help@productcart.com) [Contact Support](mailto:help@productcart.com) How can we help you? - There are no suggestions because the search field is empty. 1. [ProductCart Help Center](https://productcart-kb.nsource.com/kb?hsLang=en) 2. [Advanced Technical Articles](https://productcart-kb.nsource.com/kb/advanced-technical-articles?hsLang=en) March 5, 2024 # Apparel Add-on: Relationship between Parent and Sub-Products In the ProductCart Database, both the parent product and its sub-products are saved to the "products" table.   ##### pcProd\_Apparel The value in this field of the "products" table must be 1 for Apparel products and 0 for Sub-Products.   ##### pcProd\_ParentProd The relationship between N sub-products and their unique Parent Product is handled by the "pcProd\_ParentProd" field in the "products" table. The field holds the unique ID of the parent product. The value is that of the "idproduct" field for the parent product, in the same table. The Parent Product should always have: - pcProd\_Apparel = 1 - pcProd\_ParentProd = 0 A sub-product should always have: - pcProd\_Apparel = 0 - pcProd\_ParentProd = ID of Parent Product   ##### Options used If the product is a sub-product, the option groups (e.g. "Color") and option attributes (e.g. "Red") assigned to it are stored in the "pcprod\_Relationship" field. Let's assume that the field contains the string: 6\_9\_11 - 6 = ID of the parent product - 9 = ID of the first "option group/option attribute" combination (e.g. "color/red"). The id refers to the "idoptoptgrp" field in the "options\_optionsGroups" table. - 11 = ID of the second "option group/option attribute" combination (e.g. "size/large"). Here too, the id refers to the "idoptoptgrp" field in the "options\_optionsGroups" table. - [Managing Your Products](https://productcart-kb.nsource.com/kb/managing-your-products?hsLang=en) - [Managing Orders](https://productcart-kb.nsource.com/kb/managing-orders?hsLang=en) - [Managing Customers](https://productcart-kb.nsource.com/kb/managing-customers?hsLang=en) - [Getting Started](https://productcart-kb.nsource.com/kb/getting-started?hsLang=en) - [Apparel Add-On](https://productcart-kb.nsource.com/kb/apparel-add-on?hsLang=en) - [Upgrading ProductCart](https://productcart-kb.nsource.com/kb/upgrading-productcart?hsLang=en) - [Change Logs](https://productcart-kb.nsource.com/kb/change-logs?hsLang=en) - [Store Settings](https://productcart-kb.nsource.com/kb/store-settings?hsLang=en) - [Security](https://productcart-kb.nsource.com/kb/security?hsLang=en) - [Shipping Options](https://productcart-kb.nsource.com/kb/shipping-options?hsLang=en) - [Payment Options](https://productcart-kb.nsource.com/kb/payment-options?hsLang=en) - [Tax Options](https://productcart-kb.nsource.com/kb/tax-options?hsLang=en) - [Advanced Technical Articles](https://productcart-kb.nsource.com/kb/advanced-technical-articles?hsLang=en) - [Pages](https://productcart-kb.nsource.com/kb/pages?hsLang=en) - [What's New In ProductCart](https://productcart-kb.nsource.com/kb/whats-new-in-productcart?hsLang=en) - [Marketing](https://productcart-kb.nsource.com/kb/marketing?hsLang=en) - [How To's](https://productcart-kb.nsource.com/kb/how-tos?hsLang=en) - [Google Analytics](https://productcart-kb.nsource.com/kb/google-analytics?hsLang=en) - [QuickBooks Sync](https://productcart-kb.nsource.com/kb/quickbooks-sync?hsLang=en) - [Default](https://productcart-kb.nsource.com/kb/default?hsLang=en) - [Configurator](https://productcart-kb.nsource.com/kb/configurator?hsLang=en) - [SEO](https://productcart-kb.nsource.com/kb/seo?hsLang=en) - [Mobile Commerce](https://productcart-kb.nsource.com/kb/mobile-commerce?hsLang=en) - [Troubleshooting](https://productcart-kb.nsource.com/kb/troubleshooting?hsLang=en) - [Customizing Your ProductCart Store](https://productcart-kb.nsource.com/kb/customizing-your-productcart-store?hsLang=en) - [ProductCart Apps](https://productcart-kb.nsource.com/kb/productcart-apps?hsLang=en) - [Hidden Topic](https://productcart-kb.nsource.com/kb/hidden-topic?hsLang=en) - [Reports and Exports](https://productcart-kb.nsource.com/kb/reports-and-exports?hsLang=en) [![ProductCart Logo](https://productcart-kb.nsource.com/hs-fs/hubfs/pc_logo.png?width=200&height=93&name=pc_logo.png "ProductCart Logo")](https://netsourceinc.com) NetSource Commerce, Inc. **|** Headquarters - 3700 South Pine Avenue, Ocala, FL 34471 **|** Tel [(800) 709-3240](tel:+8007093240) **|** Fax (352) 401-0353 [mailto:help@productcart.com](mailto:help@productcart.com) Copyright © 2026, NetSource