Integration apps that sync matrix items to an eCommerce platform use a variation theme to map product options (such as size and color) from NetSuite to the platform. By default, the VIRTUAL VARIATION feature provides five variation options. If you need more than five, you can create additional options by customizing the variation theme record in NetSuite and adding corresponding columns to the Celigo item export saved search.
Note: This article uses the BigCommerce – NetSuite integration app as the example, but the process applies to any NetSuite integration app that uses variation themes.
Create an additional variation option in NetSuite
- In the NetSuite global search, type Celigo <eCommerce application> Variation Themes (for example, Celigo BigCommerce Variation Themes).
- On the Celigo BigCommerce Variation Themes List page, select New Celigo BigCommerce Variation Themes.
- On the variation theme page, select Customize > Customize Form.
- Select Fields.
- Select an existing field to display in the variation theme, or create a new one:
- To create a new field, select New Field.
- In Label, enter a name such as Option 6.
- Fill in the remaining fields as needed.
- Select Save.
- Return to Fields and select the checkbox for the newly created field.
- Select Save.
Create the companion Field ID field
Each variation option requires two fields: one for the option name and one for the field ID. Create a second field named Option 6 (Field Id) using the same steps above.
Group the two fields
- Go to Field Groups.
- In Label, enter Variation Option 6.
- Select Add.
- Select Save.
- Go to Fields.
- For Option 6 (Field Id), set the Field Group to Variation Option 6.
- Select Save.
Both Option 6 (Name) and Option 6 (Field Id) now appear as a group in the variation theme form.
Link the new field to a NetSuite item
- Navigate to the NetSuite item you want to update.
- Select eTail.
- Select BigCommerce (or the relevant eCommerce application tab).
- Hover over BIGCOMMERCE VARIATION THEME and select +. The new field appears in the Celigo BigCommerce Variation Themes form.
Add the new field to the Celigo item export saved search
The integration app reads variation data from a saved search. After adding the new field to the variation theme form, add a corresponding column to the saved search.
- Go to the Celigo BigCommerce Item Export Search saved search in NetSuite.
- Go to Results > Columns.
- In Columns, search for and select Formula (Text).
- In Formula, enter:
CONCAT(CONCAT({CUSTITEM_CELIGO_BGC_VARIATION_THEME.<field id of option name>}, '--'), {CUSTITEM_CELIGO_BGC_VARIATION_THEME.<field id of option field>})
Replace <field id of option name> and <field id of option field> with the internal field IDs of the fields you created.
- In Custom Label, use the format Variation Theme Option X (for example, Variation Theme Option 6).
- Select Add.
- Select Save.
Avoid duplicate items in BigCommerce
Important: When the integration app syncs matrix items to BigCommerce, it always creates new items and doesn't update items you already created in BigCommerce. This applies even if you already created most items in BigCommerce and ran the NetSuite Item to BigCommerce Product Add/Update flow. Each time you export a new NetSuite item with a parent and child relationship, the integration app creates a new product option in BigCommerce from the item's variation theme in NetSuite, and ignores existing product options. The SKU, its variants, and its variation theme setting are always imported together.
To prevent duplicates, create the item in NetSuite with the same variation themes and options as in BigCommerce, and sync the product ID map to NetSuite. Existing products are then updated instead of duplicated.