Articles in this section

Set up virtual variations without NetSuite matrix items

Dev Chidipi
Updated

Virtual variations let you export NetSuite items as a BigCommerce product with variations without using NetSuite's matrix item feature. You define the parent of each item with the SUBITEM OF field or a custom field, and the NetSuite Item to BigCommerce Product Add/Update flow exports the parent as a BigCommerce matrix product with the children as its variations. Virtual variations work with inventory items and assembly items, matrix and non-matrix, and with kit items. This article is for integrator.io users and NetSuite administrators who manage item variations in NetSuite.

Turn on virtual variations in the integration app

  1. In the integration app, go to Settings > Product > Product.
  2. For NetSuite Saved Search for syncing item details, select the item saved search.
  3. Select Enable virtual variations.
  4. In NetSuite field identifier for variation parent item, enter the field ID of the NetSuite field that defines each item's parent. The default, parent, is the field ID of SUBITEM OF. If you use a custom field instead, it must be a list field like SUBITEM OF, not a text field.
  5. Select Save.

Set up the items in NetSuite

  1. On each item that's part of a virtual variation, on the eTail subtab, select IS VIRTUAL VARIATION.
  2. On each parent item, select a BIGCOMMERCE VARIATION THEME. To create one, see Create a variation theme.

To add more variation options, see Create additional virtual variation options.

Sync changes made to child items

The item saved search detects only changes made directly to a parent item. To also sync changes made to child items, set the parent field on the item map script deployment for each item record type you use.

  1. In NetSuite, go to Customization > Scripting > Scripts.
  2. Find the Celigo BigCommerce Item Map UE user event script from bundle ID 119235, and select Deployments.
  3. Select Edit for a record type.
  4. On the Parameters subtab, enter the same value as in NetSuite field identifier for variation parent item in the integration app.
  5. Select Save.
  6. Repeat steps 3 through 5 for each record type you use for virtual variations.

Run the item flow

  1. In the integration app, go to Flows > Product.
  2. Select Run for NetSuite Item to BigCommerce Product Add/Update.

When the run completes, the parent item appears in BigCommerce as a product with all of its child items as variations.