title: Use Excel/VB to create a list of product variations based on list of parent products
body: <p>I am running a Woocommerce shop with the product CSV import suit plugin. I need to first upload a list with parent products and second a list with products variations. Creating the second list is quite labor intensive, so I am looking for a way to automatically generate this list as much as possible.</p>
  
  <p>Here is how a short, simplified list of parent products could look like:
  <img src="https://i.stack.imgur.com/lha04.jpg" alt="enter image description here"></p>
  
  <p>The actual list with parent products would contain many more product characteristics.</p>
  
  <p>And this is how the results with product variations should look like:
  <img src="https://i.stack.imgur.com/5zFPs.jpg" alt="enter image description here"></p>
  
  <p>As you see the can see the product variation (child) inherents all of the products characteristics of the parent product and only one of the size and color variables. It would be nice if a child sku would automatically be generated as well.</p>
  
  <p>I would like the output data (product variations) to be generated in a different worksheet (seperate from the parent product list).</p>
  
  <p>Does anyone have any thoughts how to do this in Excel? I am no Excel wizard, so I hope you can give me some guidance on how to implement your solution.</p>