Articles on: Matching Column

Variant Group & Variant Option Field (Product Options)

Its primarily used for Add feed when products in the feed have variations such as size, color, etc.

Variant Group

How to use the Variant Group field? (✔️ Add )

Variant Group is NOT a compulsory field. It supports multiple columns. For example, you can scroll to the last part and refer.

A variant group is made to manage a group of products that are together under the same name and that will have several common attributes but some variation.

The above example contains clothes in different sizes and quantities. But products with the same Var ID can be assigned to the Variant Group and Variant Option as Size. So, it can be listed as a single product.

There is only available one setting in this field which is:

1. Auto sort

It will sort out the variant group before importing. When unable the toggle button will not sort out the variant group.

2. Merge variants into existing products

When the toggle is on, it will merge variants with existing products, and you need to select the same group for the merging process.

For example: There are three scenario how this options works, please understand it well.

Scenario 1

Using the same title from feed and store to merge it but the product identifier as SKU

Scenario 2

Using the same SKU from feed and store to merge it but the product identifier as barcode

Scenario 3

Using the SKU and title from feed and store to merge it but the product identifier as SKU and since the same SKU already exists in the store, the merge could not be completed.

3. Merge variants will tagged with

When the new variants merge, you can add a tag to check which variants have merged.

Variant Option 1 / 2 / 3✔️ Update ✔️ Export

Variant Option will be used when there is a Variant Group field. So when you set the Variant Group field, you must set the Variant Option field as well.

Variant Option supports custom text formatting , allowing you to map multiple columns and add extra text as needed. To know more on custom text formatting can refer here . You can refer to the example below:

There are a few settings for this field which are:

1. Option Name

It will create the name for the variant option referring to the feed file, which has different attributes for a group of variants: Size or Colour.

When your feed Option column is according to the image below, you can use Mapping and enter the field name. If it uses the fixed value, then it can be chosen as a fixed value and enter the Option name.

To learn more on How to replace option name with comma

2. Case Convert

It will help you to convert the text between different letter cases easily.

For example:

this is a SAMPLE
All lower case: this is a sample
All upper case: THIS IS A SAMPLE
Titleize case: This Is A Sample
Clean up all HTML tags: Remove all HTML tags using this option

3. Find

Find for multiple words or phrases separated by commas. The search matches any part of the words, supports wildcard (*) and regular expressions. You can test your regular expression at this link: https://regex101.com/

For example: (Find: *man) will include - woman, manicure etc from the feed file.

Example of regular expression: To remove all links from the description field, enter <a href=.?>,<a id=.?>,</a>

4. Replace with

Replace the words or phrases used with Find above, separated by a comma.

For example: word1,word2. (Auto-matched with Find) It will replace your store word from auto-match with find. To replace the words with the column name, use {{title}} and place the column name inside the bracket {{}}

If your feed file contain multiple value in one column for variant option as the below image.

To make it as separated option, you may contact us for the further assistance.

For example of error could happen: Option 1 & 2 do not fill in the same name. It will occur an error. Avoid using the same name for the option. It will prompt an error and check via the changes log.

For example Variant Group supports multiple columns:

From the above image, can see that two different columns want to group it. So, the Variant Group Field is mapped with VAR ID and VAR ID2.

Please have a look at the demo file attached below for more information on Variants.

Note: Variants can only be grouped correctly if all variants of a product share the same consistent value in the Variant Group field. If the grouping column (for example, description or item name) differs between variants, the system cannot merge them. In such cases, the feed must be standardized so all variants use an identical group identifier.

Download Demo Store

5. Remove Default Title (✔️ Export)

By enabling this option, the default title will be removed and set to blank.

For example: Some of your variants might not have the option name, which will cause the default title to be removed and turned blank.

Important Notes for Grouping Variants Correctly

To ensure variants group together into one product during the Add or Update process, make sure of the following:

• When Merge variants into existing products is enabled and using Title as the merge rule, the product titles in the feed must match the Shopify product title exactly. Any differences (such as measurements or attributes added to the title) will cause Stock Sync to treat them as separate products.

• If titles cannot match exactly, use a consistent identifier instead (SKU or barcode) as the merge rule, as long as those values already exist in Shopify and uniquely identify the base product.

• When grouping multiple variants, ensure all related rows in the feed share the same Variant Group value. If details like length or width are in the title, move them into Variant Option fields instead.

Updated on: 28/05/2026

Was this article helpful?

Thank you!