Articles in this section

Configure product settings

Important

The NetSuite saved searches included with this D2C template are managed by the Celigo bundle (ID 81289). When Celigo releases a bundle update, any changes made directly to these saved searches will be overwritten, which can break your integration flows. Before making any changes to a template saved search, clone it first and use the cloned copy in your flow. Do not modify the original template saved searches directly. This ensures your customizations are preserved when the bundle is updated. To clone a saved search in NetSuite: open the saved search > click More > select Copy.

The product and inventory settings control which items are exported from NetSuite, how they are priced in Shopify, and how inventory levels are tracked. Access these settings in the integration tile under Settings > Product.

A2.png

Product export settings

A21.png

Setting

Description

Unique title for each Shopify product

Enable to prevent a new Shopify product from being created if a product with the same title already exists. Turn this on when product titles serve as unique identifiers in your catalog.

Sync published scope from NetSuite to Shopify

Enable to sync the published scope (web, global) from the NetSuite item record to Shopify during product sync. Disable to leave the Shopify published scope unchanged when product records are updated.

Add GST/VAT to item price

Enable to add GST/VAT to the item price before writing it to Shopify. Use this for markets that require tax-inclusive pricing on the storefront.

Pricing settings

Setting

Description

NetSuite price level to sync product price

Select the NetSuite price level to use as the Shopify product or variant price. For example, select "Online" if you maintain a dedicated price list for your Shopify store.

NetSuite price level to sync compare at price

Select the NetSuite price level to use as the Shopify compare-at price (the crossed-out original price displayed on sale items).

NetSuite currency to sync product price

Select the NetSuite currency used to resolve the product price during export. Choose the currency that matches your Shopify store's primary currency.

Sync price lists per market from NetSuite to Shopify

Enable to sync per-market prices from NetSuite price lists to Shopify market price lists using the priceListFixedPricesAdd mutation. Map the price lists per market before enabling this setting.

Choose NetSuite and Shopify price lists details

Map each Shopify market ID to its corresponding NetSuite price level or price list ID for per-market pricing sync. Add one entry per market to link Shopify markets to the correct NetSuite pricing data.

Choose any of these Shopify markets (RegionsB2BRetailPOS locations, and Company locations), NetSuite currency, and NetSuite price level fields. The compare-at-price field is optional. Once you make the selections, save the settings, and run the NetSuite item to Shopify product (add or update) and NetSuite matrix item to Shopify product (add or update) flows to sync price lists from NetSuite to Shopify. For more information about price lists per market in Shopify, see Shopify Markets pricing.

Virtual variations settings

Setting

Description

Enable virtual variations

Enable when non-matrix NetSuite items need to appear as Shopify variants (for example, when a group of non-matrix items shares a logical parent-child relationship in NetSuite without using the matrix item type). When enabled, also configure the identifier field below.

NetSuite field identifier for variation parent item

Enter the internal ID of the NetSuite item field used to identify the variation parent. Required when virtual variations is enabled. Enter the field ID (not the label) as it appears in the NetSuite schema.

Metafield settings

Setting

Description

Specify your Shopify metafield components for products and variants

Map each NetSuite item field to a Shopify metafield (namespace and key) to write item field values to Shopify during product sync. Ensure the required metafield definitions already exist in Shopify before setting up this mapping.

Enter the values in the Namespace.Key.Value format, where Value is the NetSuite Field ID.

To know more about these fields, refer to Metafields.

The following four checkboxes appear under the Operation setting allows you to handle all possible configurations from a single location:

  • Sync as product metafield for simple item: Check this box to sync product metafields for simple items. The earlier mapping functionality that supported syncing of metafields for simple items is still functional. If you want to use this setting, select the checkbox.

  • Sync as variant metafield for simple item: Check this box to sync variant metafields for simple items.

  • Sync as product metafield for matrix item: Check this box to sync product metafields for matrix items. The earlier mapping functionality that supported syncing of metafields for simple items is still functional. If you want to use this setting, select the checkbox.

  • Sync as variant metafield for matrix item: Check this box to sync variant metafields for matrix items. If you have already used the previous setting for syncing variant metafields, this checkbox is selected by default.

Locations mapping

The location mapping under Settings > General is used by the inventory sync, fulfillment, and inventory transfer flows. It supports both 1:1 and many-to-1 mappings, allowing multiple NetSuite locations to map to a single Shopify location for inventory aggregation.

For information about location mapping, see Map NetSuite locations with Shopify locations.