SKU/Parent SKU fields |
Post Reply |
Author | |
MaiBritt
Newbie Joined: 03-May-2010 Status: Offline Points: 0 |
Post Options
Thanks(0)
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
|
|
ProductCart
Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
Post Options
Thanks(0)
|
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 |
|
MaiBritt
Newbie Joined: 03-May-2010 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
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
|
|
Greg Dinger
Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
|
<<<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.
|
|
MaiBritt
Newbie Joined: 03-May-2010 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
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
|
|
Greg Dinger
Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
|
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.
|
|
Guests
Guest |
Post Options
Thanks(0)
|
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. |
|
MaiBritt
Newbie Joined: 03-May-2010 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
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
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |