NetSuite SKU and Storefront SKU in NetSuite Connector

SKUs (Stock Keeping Unit) are used by storefronts to identify items. During product sync, NetSuite Connector uses the SKU as unique identifier to match items in the storefront to the corresponding item in NetSuite. The SKU value on an item record is stored on a field in NetSuite and this field needs to be defined in the Product Mappings. When NetSuite Connector retrieves an item from NetSuite, it uses the value in the mapped SKU field to find a matching item in the storefront. The SKU values need to match one-to-one between the storefront and NetSuite.

It's important for the product field SKU to be properly set up in both product mappings and order mappings. The best practice is to make sure the SKU fields match in both order mappings and product mappings. The SKU field is usually mapped to itemId. However, use of the following fields has also been observed:

• displayName

• upcCode

• vendorName

• ProductID

• mpn

• externalId

• NsExternalId

• SKU

Custom fields can also be used. See the following sections for the procedures on setting and verifying the SKU field:

• Setting the SKU Fields in NetSuite Connector

• Verifying NetSuite SKU Matches the Storefront SKU

General Notices