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.
|
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. |
|
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 (Regions, B2B, Retail, POS 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. |
|
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. |
|
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:
|
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.