Best Method for Child Products - Inventory

**stitchez** · 05-28-2012, 05:41 PM

Thanks in advance for the help.

I am doing a inventory update and need some help for 2 remaining columns in excel.

Child Products (Sku's)
Media Gallery

"Child Products" column needs to be added to parent row only. The format ( Child Sku,Child Sku,Child Sku,....) if the child product belongs to the parent.
Since each product has a different amount of children i am not sure how to run this function.

*Media Gallery* column is a little bit trickier.
This also goes under the column of the parent product.
If the size is any of the following - Med, 7, 7.5, 2XL, NoSize
Then in the parent column for that child, it needs to put the sku followed by -A,-B,-C. It gets a image name of "Sku-A.jpg,Sku-B.jpg,Sku-C,jpg" Each sku that matches will have Images A,B, and C.

For example in the phote below is how it should look ( i manually entered the values )
Column F - Size of the product
Column G - SKU ( 407.... = child ID, 603... = parent ID )
Column H - Parent ID
Column P - Type of product - Simple = Child / Configurable = Parent
Column AF - The Child Skus ( in parent Column )
Column AG - Images based on Size - ( in parent column only )

Image - excel.png

Excel Sheet - Product upload.xls

Thanks again for looking and any help

**Mordred** · 05-28-2012, 06:36 PM

What is the Parent product/Row that you keep referring to? I've looked at both your picture and workbook and I am confused by that phrasing. Also, the cells in AF and AG columns are for what? You want your sku, Parent ID (whatever that is),type of product, child sku, and image all in one cell? The references you have are showing formulas

Please Login or Register  to view this content.

Can you clarify a little better?

**stitchez** · 05-28-2012, 06:47 PM

Column P defines the parent from child products
the value "simple" is a child product
The value "configurable" is the parent for the products above.

Column AF is the column that need to be generated. I did that formula you see to show what the value is suppose to look like. Child sku's of the parent

AG is where the image name needs to be defined like the formula I added
3 image names per sku that match the size.

**MarvinP** · 05-28-2012, 09:54 PM

Hi stitchez,

We do a lot of problems for people and most of the time it is to undo cells like your AF Column. Excel works best if a single peice of information is in a single cell. When you append them together and separate them with a comma, it goes against the way Excel was meant to work. I believe you need to look at AutoFilter or Pivot Tables to get to what you want. I think you are asking a question that makes your problem harder instead of easier.
Look at http://www.contextures.com/xlautofilter01.html to see if you can use this topic.

**stitchez** · 05-28-2012, 10:07 PM

Originally Posted by MarvinP

Hi stitchez,

We do a lot of problems for people and most of the time it is to undo cells like your AF Column. Excel works best if a single peice of information is in a single cell. When you append them together and separate them with a comma, it goes against the way Excel was meant to work. I believe you need to look at AutoFilter or Pivot Tables to get to what you want. I think you are asking a question that makes your problem harder instead of easier.
Look at http://www.contextures.com/xlautofilter01.html to see if you can use this topic.

How would filtering help?

**MarvinP** · 05-29-2012, 12:34 AM

I think you should look at some of the Office Excel Templates that deal with inventory. They might give you ideas on how to do your problems easier.
http://office.microsoft.com/en-us/te...2D74af9673427b