Create additional virtual variation options

In a variation theme, the VIRTUAL VARIATION feature provides out-of-the-box five variation options. If required, you can manually create additional variation options and make small changes to the Celigo item export saved search as explained below.

Note: This article is generic across all NetSuite integration apps however, this document explains creating additional variation options for BigCommerce - NetSuite integration app. 

Create an additional variation option

1. In the NetSuite global search, type in Celigo <eCommerce application> Variation Themes. For example, Celigo BigCommerce Variation Themes. You will be landed on the Celigo BigCommerce Variation Themes List page.
2. Click New Celigo BigCommerce Variation Themes, and you will land on the Celigo BigCommerce Variation Themes page where the available options are displayed.
3. Click Customize > Customize Form.
   
   
4. Click Fields.
5. Select the required field you want to display in the BigCommerce Variation Theme or create a new field.
6. To create a new field. Click New Field.
   
   
7. In the LABEL field, provide a name. For example, Option 6. In the other fields, provide the details as required. 
8. Click Save.
9. Now, go back to the Fields tab and select the newly created field checkbox.
10. Click Save.
    
    
11. Once these details are saved, navigate to the NetSuite item to which you want to add this field as a virtual variation.
12. Click eTail as shown in the screenshot.
13. Click BigCommerce.
14. Hover over the BIGCOMMERCE VARIATION THEME dropdown and click +. The new field appears in the Celigo BigCommerce Variation Themes form.
    
    

Similarly, create another field with the name Option 6 (Field Id). Once the field is created and saved, group the field with the VariationOption 6 field created previously.

To group a field:

1. Go to the Field Groups.
2. In the Label field, type Variation Option 6.
3. Click Add.
4. Click Save. 
   
   
5. Navigate to the Fields tab.
6. For the field Option 6 (Field Id), select the Field Group as Variation Option 6.
7. Click Save.
   
   

Once the setting is saved, you can see both the fields Option 6 (Name) and Option 6 (Field Id) in the form as shown below.

Add field to the Celigo BigCommerce Item Export Saved Search

1. Go to Celigo BigCommerce Item Export Search saved search.
2. Go to Results > Columns.
3. In the Columns dropdown, search and select Formula (Text).
4. In the Formula field, enter CONCAT(CONCAT({CUSTITEM_CELIGO_BGC_VARIATION_THEME.<field id of option name>}, ‘--’ ), {CUSTITEM_CELIGO_BGC_VARIATION_THEME.<field id of option field>}). 
5. In the CUSTOM LABEL field, make sure that the format of the label name is Variation Theme Option X.
6. Click Add.
7. Click Save.

IMPORTANT: Assume that you have already created most items in BigCommerce and ran the NetSuite Item to BigCommerce Product Add/Update flow. The integration app while syncing matrix items to BigCommerce always creates duplicate items in BigCommerce and will not update the existing items that you have already created in BigCommerce. Whenever you export a new item in NetSuite with a parent and child relationship, the integration app will always create a new product option in BigCommerce based on the variation theme configuration set in NetSuite for this item and ignores the existing product options in BigCommerce. The SKU, its different variants, and its variation theme setting in NetSuite will always be imported together. To overcome this creation of duplicates issue, we recommend you create an item in NetSuite with the same variation themes and options as created in BigCommerce, and sync the product id map to NetSuite so that duplicates are not created and existing ones are updated.