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

Another example:

If you want to clear html tags can use Clean up all HTML tags.

3. Find



Find multiple words or phrases separated by a comma. Search will match any word to find any part of the word, including *



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

The Find field also supports regular expressions

For example: To remove all links from the description field, enter

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 support@stock-sync.com 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.

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.

Updated on: 29/11/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!