Use virtual variations in eBay

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 setup 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 eBay. The NetSuite Item to eBay Item Add/Update flow allows you to create virtual variation items. The integration app allows you to use the SUBITEM OF field or a custom field where you specify the parent of an item to create the parent-child relationship needed for an item record in NetSuite.

Note: If you decide to use a custom field for creating a virtual variation relationship, the custom field must be a drop-down field similar to the SUBITEM OF field. 

Configure Settings

1. Login to your integrator.io account
2. Select the eBay - NetSuite integration app tile.
3. Go to Settings > Product.
   
4. In the Map Variation Specifics setting, map a eBay Variation Specific Label such as Color, Finish, Width, and so on to a NetSuite Field Id. The NetSuite Field Id can be viewed by clicking on a field name in NetSuite.
5. Check the Enable virtual variations box
6. Enter the Field Id value of the NetSuite field where the parent of an item is specified in the NetSuite field identifier for variation parent item setting.

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.

Configurations Needed in NetSuite

You need to enable the IS VIRTUAL VARIATION checkbox in the eTail tab of item record for all the items for which you want to establish the parent-child relationship in NetSuite using the virtual variation functionality. This should be done for both the parent as well as the corresponding child items. In addition to this, the “Subitem Of” field on the child item record should be populated with the parent item record.

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 eBay 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 eBay Item Map UE User Event with Bundle ID as 170343 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 in the Virtual Variation field as mentioned in the NetSuite field identifier for variation parent item field under Settings > Product > General > Map Variation Specifics of the integration app.

   Note: You can leave the value in the Virtual Variation field blank if you are using the standard SUB ITEM OF field.
   

6. Click Save.
7. Repeat actions described in steps 4, 5, 6 for all records types you wish to use for creating virtual variations.

Use the Item Export Flow for Real and Virtual Matrix Items

It is possible to map a conditional statement within the 'Map Variation Specifics' to pick between the 2 fields based on the type of matrix.

• Create a new custom field which source from custitem_color for matrix items and custitem_virtual_color for virtual variation items and add that field in Variation Specific Setting mapping in IO. 
  • Use the formula as: CASE WHEN {custitem_celigo_ virtualvariation} = 'T' THEN {custitem_virtual_color} ELSE {custitem_color} END. 

Display images for matrix children from child item

This feature enables you to view the image related to a child item on eBay instead of restricting you to view only the image related to a parent item.

To display images for matrix children from the child item, and not the parent item, you need to update the Celigo eBay Item Export Search saved search in NetSuite.

1. Edit the Celigo eBay Item Export Search saved search in NetSuite.
2. In the Results tab, add a record using one of the following methods to create the virtual variation:
3. If you want to hardcode a specific variation theme as a varying option for images,
   1. Add a new row to the results.
   2. Select Formula (Text) as the Field type.
   3. Enter the variation theme in the Formula column. For example, 'Color'.
   4. Select the Custom Label you want to assign the virtual variations to. For example, VariationSpecificName.
   5. Click Save to add the record to the saved search results.
   
   The saved record will be added to the Results tab in the Celigo eBay Item Export Search saved search, as shown below:
   
4. If you do not want to hardcode a variation theme as a varying option for images,
   1. Add a new row to the results.
   2. In the Field type, select the field that will govern among all variation theme options which variation theme needs to be used as a varying option for images. For example, Primary Variant is the example of a custom field that has been used in the saved search that will govern which varying option for images needs to be selected for every item individually.
   3. Select the Custom Label you want to assign the virtual variations to. For example, VariationSpecificName.
   4. Click Save to add the record to the saved search results.
      The saved record will be added to the Results tab in the Celigo eBay Item Export Search saved search, as shown below: