Articles in this section

Sync items from NetSuite to BigCommerce

Gogula R Bhavana
Updated

The NetSuite Item to BigCommerce Product Add/Update flow creates and updates BigCommerce products from your NetSuite items, so you manage your catalog in NetSuite. It exports simple items as products, and matrix items as a product with variations. This article covers preparing items in NetSuite, running the flow, the item settings, custom field mappings, and removing items from your storefront. It's for integrator.io users and NetSuite administrators who manage the BigCommerce catalog.

Prerequisites: Sync your BigCommerce product categories to NetSuite. For steps, see Sync product categories from BigCommerce to NetSuite.

Supported item types

  • Simple items: Exported as BigCommerce products.
  • Matrix items: The parent matrix item is exported as a BigCommerce product, and its child matrix items as variations of that product. Inventory matrix items and assembly matrix items (simple, lot numbered, and serialized) are supported, with up to five variation options. You can export one matrix item to several BigCommerce stores.
  • Virtual variations: Lets you export NetSuite items that aren't matrix items, including kit items, as a product with variations. For details, see Set up virtual variations without NetSuite matrix items.

Other assembly items and kit items aren't supported unless you set them up as virtual variations.

Item settings

The item settings are in Settings > Product > Product.

  • NetSuite Saved Search for syncing item details: The saved search for the items to export. To load items that aren't exported to BigCommerce, refresh the list.
  • NetSuite price level for syncing product price: The NetSuite price level used for the BigCommerce price.
  • NetSuite currency for syncing product price: The NetSuite currency used for the BigCommerce price.
  • Enable virtual variations and NetSuite field identifier for variation parent item: For details, see Set up virtual variations without NetSuite matrix items.

Sync a simple item

  1. In NetSuite, create an item or open an existing one.
  2. On the eTail subtab, in ETAIL CHANNEL, select BigCommerce.
  3. Under BigCommerce, complete the BigCommerce fields, such as BIGCOMMERCE ITEM CATEGORY and BIGCOMMERCE STORES, and save the item.
  4. In the integration app, go to Flows > Product, and select Run for NetSuite Item to BigCommerce Product Add/Update. To include historical changes, choose a start date. For details, see Choose a start date for a delta flow.

When the run completes, the item appears under Products in BigCommerce. Afterward, the BigCommerce product ID to NetSuite item (update) dependent flow writes the BigCommerce product ID back to the NetSuite item.

Sync a matrix item

Matrix items need a variation theme, which tells the integration app which NetSuite matrix option fields become BigCommerce product options.

Create a variation theme

  1. In the NetSuite global search, enter New Celigo BigCommerce Variation Themes.
  2. Enter a NAME for the theme, such as Size Color.

  3. For each variation option, up to five, enter:

    • OPTION 1 (NAME), OPTION 2 (NAME), and so on: The BigCommerce option label, such as Color, Size, Length, or Width.
    • OPTION 1 (FIELD ID), OPTION 2 (FIELD ID), and so on: The internal ID of the matching NetSuite matrix option field. For example, if the matrix option field Color has the internal ID custitem_color, enter custitem_color.
  4. Select Save.

You can create as many variation themes as you need, and assign one theme to as many items as you need.

Export the matrix item

  1. In NetSuite, open the parent matrix item.
  2. On the eTail subtab, complete the fields for a simple item, and under BigCommerce, select the BIGCOMMERCE VARIATION THEME.
  3. Save the item.
  4. In the integration app, go to Flows > Product, and select Run for NetSuite Item to BigCommerce Product Add/Update.

When the run completes, the product and its variations appear under Products in BigCommerce.

Note: The flow doesn't update products that you created directly in BigCommerce. When it exports a NetSuite item with a parent and children, it always creates a product with options based on the item's variation theme, and ignores existing product options in BigCommerce, which creates duplicates. To avoid duplicates, create the item in NetSuite with the same variation theme and options as in BigCommerce, and sync the product ID map to NetSuite so that existing products are updated.

Map BigCommerce custom fields

BigCommerce custom fields aren't listed automatically in the item flow's mapping. To export them, create a custom item field in NetSuite for each BigCommerce custom field, with a name you can recognize in the mapping. Add the NetSuite fields to the item saved search, and then map each one to custom_fields.<field name>, where the part after the period is the name of the custom field in BigCommerce. For example, map the NetSuite field for size to custom_fields.Size.

Keep BigCommerce values when NetSuite fields are empty

By default, if a NetSuite field is empty, the flow deletes the matching value in BigCommerce. To keep the BigCommerce value instead:

  1. In the integration app, go to Flows > Product, and select Mapping for NetSuite Item to BigCommerce Product Add/Update.
  2. Select Settings for the field's mapping.
  3. Select Discard if empty, and set a default action if you need one.
  4. Select Save.

Use more than one price level

The item flow exports one price level. To send prices from more than one NetSuite price level, create an item saved search that returns each price level in its own column, and map those columns.

  1. In NetSuite, go to Lists > Search > Saved Searches > New, and select Item.
  2. Add criteria if you need them.
  3. On the Results subtab, select Remove All, and add a Name column with the Group summary type.
  4. For each price level, add a Formula (Currency) column with the Maximum summary type, a custom label, and a formula that returns that price level's unit price.
  5. Enter a search title, and save the search.

For example, this formula returns the unit price of the Bottle Price price level in Australian dollars:

case when {pricing.currency} = 'AUD' and {pricing.pricelevel} = 'Bottle Price' then {pricing.unitprice} end

Adjust the formulas to your price levels and currencies. If you want a fallback when one price is zero, use a mapping expression such as this one, which uses the online price when it's greater than zero and the variant price otherwise:

{{#compare variants[*].[OnLine (Variant)] ">" "0.00"}}{{variants[*].[OnLine (Variant)]}}{{else}}{{ variants[*].[Price (Variant)]}}{{/compare}}

Remove an item from your storefront

The integration app doesn't delete items from BigCommerce. To take an item off your storefront, make it unavailable:

  1. In NetSuite, open the item.
  2. On the eTail subtab, under BigCommerce, set PRODUCT AVAILABILITY to disabled, and save the item.
  3. Run the NetSuite Item to BigCommerce Product Add/Update flow.

Note: Don't remove BigCommerce from the item's ETAIL CHANNEL. That stops the flows from updating the item and doesn't remove it from BigCommerce.

Item sync limitations

  • BigCommerce product metafields aren't synced, and product-level metafield updates aren't supported. Only the standard product attributes are exported from NetSuite.
  • HTML code isn't supported. The integration app sends values to BigCommerce exactly as it receives them from NetSuite.
  • If the saved search truncates a long field value, the flow gets the full value from NetSuite and syncs it. This works only when the saved search column contains the custom field name, not a formula.