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_idor theitem_group_idcolumn).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.