Apparel Add-on - SKU/Parent SKU fields

Print Page | Close Window

SKU/Parent SKU fields

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart Add-on's
Forum Name: Apparel Add-on
Forum Description: All topics concerning the use of the Apparel Add-on
URL: https://forum.productcart.com/forum_posts.asp?TID=4053
Printed Date: 21-November-2024 at 12:17pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: SKU/Parent SKU fields

Posted By: MaiBritt
Subject: SKU/Parent SKU fields
Date Posted: 06-October-2010 at 2:49pm

Importing Sub Products: The first two fields to map when importing sub product are SKU and Parent Product SKU.

Are these two fields supposed to contain the same data?

If so, Why?

If not, What goes into the SKU field.

The import works with these two fields populated equally, however, the Price differential is not showing up.

I do not understand how the parent/child relationship is made.

-------------
Bob

Replies:

Posted By: ProductCart
Date Posted: 07-October-2010 at 1:57am

SKU is the part number, which is often unique for each sub-product (e.g. apparel items of different colors and sizes).

For more information on how the Apparel Add-on is structured, please refer to the documentation. Please see:
http://wiki.earlyimpact.com/apparel_add-on/apparel_add-on#technical_notes_troubleshooting - http://wiki.earlyimpact.com/apparel_add-on/apparel_add-on#technical_notes_troubleshooting

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: MaiBritt
Date Posted: 07-October-2010 at 10:30am

Wow, that is some response.

A SKU is supposed to be unique by definition, can anyone explain how product cart works without it being unique?

I have been back and forth through the Wiki documentation. It is too often ambiguous or inaccurate to be considered anything close to reliable.

(I did get the differential to show up).

Any help would be appreciated.

-------------
Bob

Posted By: Greg Dinger
Date Posted: 07-October-2010 at 10:41am

<<<A SKU is supposed to be unique by definition>>>

Yes, and that is precisely what the Apparel add-on does. It's really not that hard, but you have to understand the concept of subproducts.

Say you have a shirt that has 3 colors and 3 sizes. That means you will eventually have 9 subproducts.

Each product option may have a code associated with it. So let's say we have these 3 colors that each have a 2-digit code

Red=rd

White=wh

Blue=bu

Then there are 3 sizes:

Large=lg

Medium=md

Small=sm

The parent product will be, for this example "abc123".

When you generate subproducts, you are provided an option as to how to generate the SKUs associated with those subproduct.

One of those options is to append the product options codes to the parent SKU in order to make the subproduct SKU unique. As such, a large red shirt would have SKU "abc123rdlg".

Does that help? Maybe with that understanding, go back and look at the subproduct generator tool and see if this makes more sense now.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: MaiBritt
Date Posted: 11-October-2010 at 1:05pm

Thanks you for the response.

The above makes perfect sense. What puzzles me is our sub product import .xls sheet has the same data in the SKU andParent Product SKU fields.

We are not using the Batch Create Sub Products, just the Import Sub Products option.

Is PC reconfiguring the SKU data during the import process?

Should I (Can I) reconfigure it before importing?

-------------
Bob

Posted By: Greg Dinger
Date Posted: 11-October-2010 at 1:38pm

While I know the APP application well, and as you can see I can explain the internal structure of how the data is stored, I have not personally used the import feature for subproducts. I don't have a precise answer for this question. I doubt PC itself is at fault. I suspect you have the data in your import spreadsheet coded incorrectly.

There is a WIKI article on this topic, or possibly Hamish or EI will reply with a better response.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Guests
Date Posted: 11-October-2010 at 2:10pm

MaiBritt wrote:

Thanks you for the response.

The above makes perfect sense. What puzzles me is our sub product import .xls sheet has the same data in the SKU andParent Product SKU fields.

We are not using the Batch Create Sub Products, just the Import Sub Products option.

Is PC reconfiguring the SKU data during the import process?

Should I (Can I) reconfigure it before importing?

Hi Bob, are you using the Export for Reimport option? There was an issue there where the sub-prod SKUs were all the parent product SKUs, but I believe this was fixed in 4.1 or 4.11.

Posted By: MaiBritt
Date Posted: 11-October-2010 at 3:05pm

No, however I think the person who figured out the data fields and possibly the data to go in them did use the re-exprt to answer some of our questions. Importing the two fields with the same data works, but it does not make any sense to me.

-------------
Bob