Sync item from NetSuite to BigCommerce

Whenever an item is created or updated in Netsuite, the integration app syncs the information from NetSuite into BigCommerce. The flow supports both simple and matrix item types. In the case of Matrix Items, the parent matrix item is exported as BigCommerce Product while the child matrix items are exported as variations for the same product in BigCommerce. However, Assembly, Kit Item types are not supported by this flow.

When you run the "NetSuite Item to BigCommerce Product Add/Update" flow, you can select a start date to pull the historical data. On the pop-up window, you can either select:

• Automatic: Choose this option to process and sync data from the last flow run time.
• Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.

Before you sync an Item from NetSuite to BigCommerce, you must sync product categories from BigCommerce to NetSuite. For instructions, see Importing Product Categories from BigCommerce to NetSuite.

Sync simple Items from NetSuite to BigCommerce

1. In NetSuite, create a new item or find an existing item.
2. Under the "eTail" tab, select the ETAIL CHANNEL as BigCommerce & provide appropriate values for the rest of the BigCommerce Specific fields like Item Category, Store, etc.
3. Save the Item record.
   
   
4. In integrator.io, navigate to the Settings page for the BigCommerce - NetSuite integration app and under Product, click the Run button for the NetSuite Item to BigCommerce Product Add/Update flow.
5. Once the flow is successfully completed, verify that the item is exported to BigCommerce in the 'Products' section.
   
   

Advanced settings

• NetSuite Saved Search for syncing item details: The drop-down list displays the saved search pertaining to item export that is created in NetSuite. Select the desired saved search from the list. Click Refresh to fetch the items that have not been imported from NetSuite to BigCommerce.
• NetSuite price level for syncing product price: Lets you choose the NetSuite price level to be used for exporting the price to Bigcommerce.
• NetSuite currency for syncing product price: Lets you choose the NetSuite currency to be used for exporting the price to Bigcommerce.

Notes:

• This flow supports only Matrix items with up to 5 variation options. 
• This flow is only supported by the standard (previously "premium") or premium (previously "enterprise") edition of the integration app.

Sync matrix items from NetSuite to BigCommerce

NetSuite Matrix Items are exported as Product variations in BigCommerce. The parent Matrix item is exported as BigCommerce Product while the child Matrix items are exported as variations for the same product in BigCommerce. The data flow supports Inventory matrix items and Assembly matrix items (Simple, Lot Numbered, Serialized) and also supports exporting a single NetSuite Matrix item to multiple BigCommerce stores.

The NetSuite Item to BigCommerce Product Add/Update flow also supports a feature "Virtual Variations" which allows you to create Product Variations in BigCommerce from Non-matrix items in NetSuite. For more information, see Setup parent-child relationship without NetSuite's Matrix Item functionality.

Creating BigCommerce Variation Themes

1. In NetSuite global search box, type "New Celigo BigCommerce Variation Themes" or navigate to Customization -> List, Records, & Fields -> Record Types and find the custom record "Celigo BigCommerce Variation Themes".
2. Create a new theme by providing a name (example Size - Color). For each Variation Option (aka attribute), provide an Option Name & Option Id and you can provide up to five options in a single variation theme.
   • Option Name -> Corresponds to BigCommerce Option Label. For example any label such as Color, Size, Length, or Width.
   • Option Field Id -> Should be the internal id of the corresponding Matrix Option Field in NetSuite.
     Example: If a NetSuite Matrix Option field "Color" (internal id: custitem_color) is set up to include all the option values for color, then you need to provide the value of this field as custitem_color.

You can set up as many variation themes as you would like for your products and once a variation theme is created, you can assign the same one on as many products as you would like.

Select a variation theme on the NetSuite matrix Item 

1. In NetSuite, similar to the steps you took to export a simple item, an additional field "BigCommerce Variation Theme" under eTail -> BigCommerce should be populated on the Matrix Parent in addition to all the other field, eTail Channel, "BigCommerce Stores" etc
2. Save the Matrix item record.
3. In integrator.io, navigate to the Settings page for the BigCommerce - NetSuite Integration app and under Product, click the Run button for the NetSuite Item to BigCommerce Product Add/Update flow.
4. Once the flow is successfully completed, verify that the item is exported to BigCommerce in the 'Products' section.

IMPORTANT: Assume that you have already created a majority of items in BigCommerce and ran the NetSuite Item to BigCommerce Product Add/Update flow. The integration app while syncing matrix items to BigCommerce always create 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 that has 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.

FAQs

How to map BigCommerce custom fields to NetSuite custom Item fields during Item export?

We expect you to create custom Item fields in NetSuite for the custom fields present in BigCommerce. Ideally, the custom Item field in NetSuite should have a name that you will be able to identify on the Mapping screen.

The following image describes the custom fields (Size and Color) created in BigCommerce.

The following image describes the Item custom fields (Custom Field 1 value and Custom Field 2 Value) created in NetSuite for the custom fields present in BigCommerce. We recommend that you add the custom fields to the NetSuite Saved Search that you use for executing the NetSuite Item to BigCommerce Product Add/Update flow.

The Item custom fields, when created in NetSuite, are available on the Mappings screen. You can use these fields to export Item information from NetSuite to BigCommerce. You will have to map the BigCommerce custom fields manually using the syntax custom_fields.<field name>. For example, custom_fields.Size. Here, the part which is next to “.” is considered as the name of the Custom field in BigCommerce.

How to discard custom fields when exporting records from NetSuite?

By default, in NetSuite, if the custom field/field is empty, the field value gets automatically deleted in BigCommerce. However, if you want to prevent this, then on the Mappings window, click the gear icon for that field and select the Discard If Empty checkbox. This will discard the desired field and the existing value in BigCommerce remains unaffected. In addition, you may also choose to configure a default action if required.