Merge all product variants into one parent item
Merge all product variants into one parent item using the Merge Variants service in Productsup.
If you have child variants in your import feed, you may wish to purely work with parent items and summarize the child variants into one parent item. You can do so using the Merge Variants service.
Note
Make sure you have set a product identifier to use this service.
For example, your import data source may look like this:
parent_id | child_id | size | color |
---|---|---|---|
1 | 1-1 | XS | green |
1 | 1-2 | S | green |
1 | 1-3 | L | blue |
2Â | 2-1 | XS | red |
2 | 2-2 | M | yellow |
You would merge on the parent_id column, meaning that the data for all variants with the same parent_id will be summarized. You can choose whether to automatically remove duplicates of each merged column (here we are removing them). After applying the merge variants service, your output could look like this:
parent_id | child_id | size | color |
---|---|---|---|
1 | 1-1,1-2,1-3 | XS,S,L | green,blue |
2 | 2-1,2-2 | XS,M | red,yellow |
Add the Merge Variants service
In order to add the Merge Variants service, you should:
Navigate to your site
Navigate to Data Services on the left-hand tab
Click add service
Add the merge variants service
Give the service a name (if desired)
Define a custom column prefix (if desired)
Click add
Click add merge column
Select the source column on which you want to merge your variants (this is usually the
parent_id
or theitem_group_id
column)Select the delimiter which separates the content once it is merged
If you wish you can disable Concat unique by selecting the button, in which case duplicates will not be removed from the merged fields
Click save

You can add multiple instances of this service by repeating the above process.
Edit an existing Merge Variants service
In order to edit settings for your Merge Variants service, you should:
Navigate to your site
Navigate to Data Services on the left-hand tab
Click on the settings wheel
Delete an existing Merge Variants service
In order to delete your Merge Variants service, you should:
Navigate to your site
Navigate to Data Services on the left-hand tab
Click on the settings wheel
Scroll to the bottom of the page and click remove this service