BigCommerce Virtual Variations | Setup Parent-Child Relationship Without NetSuite's Matrix Item Functionality

In general, NetSuite supports creating a parent-child relationship between items using NetSuite's native Matrix Item functionality. This feature allows you to leverage the virtual variation functionality by Celigo to set up a parent-child relationship between the Inventory (Matrix & Non-Matrix), Assembly (Matrix & Non-Matrix), and Kit Items without using the matrix item feature in NetSuite.

Using this feature, items set up as virtual variation items in NetSuite can be exported as regular Matrix Items in BigCommerce. To support this feature, the NetSuite Item to BigCommerce Product Add/Update flow has been enhanced to accommodate creating virtual variation items. As part of this feature, the Integration App allows you to use the SUBITEM OF field or a custom field where you specify the parent of an item for creating the parent-child relationship needed for item records in NetSuite. Note that if you decide to use a custom field for this purpose, the custom field must be a drop-down field similar to the SUBITEM OF field and cannot be a text field.

For more information about creating virtual variation options, see Create additional virtual variation options.

Prerequisites for the Virtual Variation functionality

1. Configure the Product Settings
   In the Product section, go to Settings > Product and select a value in the NetSuite Saved Search for syncing Item details drop-down list. Now, select the Enable virtual variations checkbox which in turn displays the NetSuite field identifier for variation parent item field. Enter the Field Id value of the NetSuite field which you wish to use for defining the parent of an item.
   
   Note: By default, the value parent is displayed in the NetSuite field identifier for variation parent item field as a parent is the Field Id value of the SUBITEM OF field in NetSuite. You can change it to the Field Id value of the NetSuite field where you specify the parent of a virtual variation item.
   
   
2. Configurations Needed in NetSuite
   You need to make the following changes in NetSuite to use this feature:
   1. Enable the IS VIRTUAL VARIATION checkbox for all Item record in NetSuite.
      You need to enable the IS VIRTUAL VARIATION checkbox in the eTail tab of the item record for all the items for which you want to establish the parent-child relationship in NetSuite using the virtual variation functionality.
   2. Create or select appropriate BigCommerce VARIATION THEME
      You need to create or select the appropriate BigCommerce VARIATION THEME in NetSuite for every Parent item record for which you want to use the virtual variation functionality. 
      
      
3. Modify Script to Support Information Sync When a Child Item is Edited in NetSuite
   The saved searches in NetSuite only validates the changes directly made into the parent item record. To ensure that the Integration App also syncs any changes made into child item from NetSuite into BigCommerce you need to use the following steps:
   1. Login to your NetSuite account.
   2. Go to Customization > Scripting > Scripts. The scripts page is displayed.
      
      
   3. Search for the Celigo BigCommerce Item Map UE User Event with Bundle ID as 119235 and click Deployments. The Script Deployment page is displayed.
      
      
   4. Click Edit against RECORD TYPE.
      
      
   5. Click Parameters sub-tab and enter the same value as mentioned in the NetSuite field identifier for variation parent item field in Advanced Settings of the Integration App.
      
      
   6. Click Save.
   7. Repeat steps 4, 5, 6 for all record types you wish to use for creating virtual variations.

Running the Item Data Flow with Virtual Variation Functionality
Set up the virtual variation item in NetSuite and Product settings in the Integration App as explained in the aforementioned section. To run the data flow from this section, go to Flows > Product, click 'Play' button. It may a take few minutes for the flow to run and show you the status of the flow.

Once the status is displayed as Completed, validate that the NetSuite record is exported to BigCommerce and the parent item record is displayed with all child items in it.