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-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:

  1. Navigate to your site

  2. Navigate to Data Services on the left-hand tab

  3. Click add service

  4. Add the merge variants service

  5. Give the service a name (if desired)

  6. Define a custom column prefix (if desired)

  7. Click add

  8. Click add merge column

  9. Select the source column on which you want to merge your variants (this is usually the parent_id or the item_group_id column)

  10. Select the delimiter which separates the content once it is merged

  11. If you wish you can disable Concat unique by selecting the button, in which case duplicates will not be removed from the merged fields

  12. Click save

merge.png

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:

  1. Navigate to your site

  2. Navigate to Data Services on the left-hand tab

  3. Click on the settings wheel

Delete an existing Merge Variants service

In order to delete your Merge Variants service, you should:

  1. Navigate to your site

  2. Navigate to Data Services on the left-hand tab

  3. Click on the settings wheel

  4. Scroll to the bottom of the page and click remove this service