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
Ensure 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:
Go to Data Services from your site's main menu and select ADD SERVICE. Choose Split Variants and select Add.
(optional) Give the service a name and define a custom column prefix. Both are optional customizations. Now select Add.
Select Add Split Column.
Select the source column that you want to merge for your variants. This is usually the
parent_idor theitem_group_idcolumn.In Delimiter, define the character to separate the content in the source column. The comma (
,) is present in the Delimeter field by default.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.
Select Save.
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:
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:
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:
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:
Go to Data Services in your site's main menu and select the settings cogwheel.
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.