This article explains how to fix the issue if you have mistakenly added child item(s) under the wrong parent SKU.
When you are adding your data in StoreAutomator, you should group your items according to their type or variations at the beginning of this process and this has to be based on your local categories because, if you have a parent/child relationship, categories always come from the parent sku and so, different types of items cannot be included under one parent sku. One parent sku can have one type of item with minor differences such as size, color but to do this you have to create your local category tree accordingly.
For example; If you have a local category tree as below,
Clothing
---- Men
---------Shirt
---------Pants
---------T-Shirt
You cannot just create a Parent sku for Men and add all types of items under this parent because these items are different. If you want to create parentage, they must be separated. For shirt groups, it will be different, for pants parent sku will be different and for T-shirts, parent sku will be different. You can include your child items and all the variation options of those items such as size, color etc. under appropriate parent sku according to their types.
Q: What if you add a pant child item under T-shirts’ parent sku how do you fix this?
1- Make the child item of pants as a “single”. See the screenshot below for an example. You only need to provide “productdata.sku” and “parentage” fields.
2- You will need to save the file and upload it into StoreAutomator by clicking the upper arrow icon on the right corner of the screen (). The sku will be turned into a single item. (Note, if it is more than one sku, you will just add them into the template)
3- Assign a pant child item to the pant parent sku if this parent exists in StoreAutomator. In this case, you should check the variation type by clicking the edit icon of parent sku > click variations tab and click the “add variant” button.
4- After hitting the “Add Variant” button, another box will pop up and you will be able to see how the variation types had been created for this parent sku.
This means, when you fill out the variation_types columns, you type exactly the same as you see on this screen. First, it will be “Size” and then “Color” which will be separated by a comma. And of course, variation_options will be in the same array as variation types.
If it was “color”, then “size”, you have to type “color, size” into the template for variation_options
What you need to be able to include child item to an existent parent sku:
productdata.sku
parent_sku
parentage
variation_types
variation_options
If you are at the beginning of the process and if you still haven't created a parent sku for pants, then you have to create the parent sku with necessary data and add a child item under this one.
Or another case can be that you may create a parent sku with different types of items in it which means that you can use this parent sku for only one type of item and you have to turn to single the other types (as explained above) and create new parent skus for those other types.
NOTE: For more details on creating parent sku and import as bulk please see the link below:
https://support.storeautomator.com/hc/en-us/articles/4406849824146-Bulk-Product-Import-Fields