Split parent items to create product variants

Split parent items to create product variants in Productsup.

Use the Split Variants service for parent products containing all child variant characteristics in one (1) column. The Split Variants service is useful if you want to have one (1) row for each child variant.

Note

Make sure you have set a product identifier to use this service.

As an example, your import data source may look similar to the following:

parent_id

size

title

1

XS,S,L

t-shirt

2

XS,M

polo-shirt

You can split the size column to output one (1) row per size for each parent ID. After applying the split variants service, your output may look similar to this:

parent_id

size

title

1

XS

t-shirt

1

S

t-shirt

1

L

t-shirt

2

XS

polo-shirt

2

M

polo-shirt

Add the Split Variants service

To add the Split Variants service, perform the following steps:

  1. Go to Data Services from your site's main menu and select ADD SERVICE. Choose Split Variants and select Add.

  2. (optional) Give the service a name and define a custom column prefix. Both are optional customizations. Now select Add.

  3. Select Add Split Column.

  4. Select the source column that you want to merge for your variants. This is usually the parent_id or the item_group_id column.

  5. In Delimiter, define the character to separate the content in the source column. The comma (,) is present in the Delimeter field by default.

  6. In Split mode, select from:

    • Multiply Variants

    • Aggregate Variants

    • Static Variants

    You can add multiple split columns for Multiply Variants. You must add at least two (2) split columns for Aggregate Variants.

  7. Select Save.

split.png

You can add multiple instances of this service by repeating the previous process.

Multiply variants: split mode

This mode lets you select one (1) or more columns that split into new rows for each value.

Before

id

size

color

123

S,M,L

blue,red

Method

The following method uses the multiply variants split mode and splits by size and country:

multiply_variants.png

After

You get the following result:

id

size

color

123

S

red

123

M

red

123

L

red

123

S

blue

123

M

blue

123

L

blue

Aggregate variants: split mode

This mode splits two (2) or more columns into multiple lines, keeping values grouped together, as determined by their position within the data. Select at least two (2) split columns to run this mode.

Before

id

country

food

123

France,Germany,United Kingdom

cheese,sausage,pudding

Method

Using aggregate variants and splitting by country and food.

After

You get the following result:

id

size

color

123

France

cheese

123

Germany

sausage

123

United Kingdom

pudding

Static variants: split mode

Using this mode, you can append and/or prepend a series of static strings to a specific column within your feed. Static variants create a new row for each added static string. The static variants split mode is only available if you selected one (1) split column.

Before

id

title

123

My product is the best

Method

The following method uses static variants while appending the variants Alpha,Bravo,Charlie:

static_variants.png

After

You get the following result:

id

title

123

My product is the best Alpha

123

My product is the best Bravo

123

My product is the best Charlie

Edit an existing Split Variants service

To edit settings for your Split Variants service:

  1. Go to Data Services in your site's main menu and select the settings cogwheel.

Delete an existing Split Variants service

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

  1. Go to Data Services in your site's main menu and select the settings cogwheel.

  2. Scroll to the bottom of the page and select Remove this service.

Import your data

For changes to appear in Data View, import your data again.

Important

This service increases the number of imported products and your count of maintained products. As a result, this also increases your invoice amount.