Shopify Order Import SKU Lookup Error

Description: 

For the Shopify Order Import and Item Mass Update flows, the Integration App looks for the SKU of an item in NetSuite by searching for the SKU in the ItemID field. The following error may occur when more than one match is found: "A mapping error occurred. More than one match for "[["itemid","is","OZ-SE-VCA- 1037"],"AND",["isinactive"," is","F"]]" for the record type "item"."

This is a NetSuite issue where the ItemID and Vendor code match and the search returns all the items. In this example, NetSuite returns two results.

To resolve this issue, use the Name (Internal) in the mapping for the SKU. 

1. Go to Flows > Order.
2. Click the Field Mappings icon in line with Shopify Order to NetSuite Order Add.
3. Select the gear-like icon for field settings and do the following:

   

4. Click Save.