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.
Resolution:
To resolve this issue, use the Name (Internal) in the mapping for the SKU.
- Go to Flows > Order.
- Click the Field Mappings icon in line with Shopify Order to NetSuite Order Add.
- Select the gear-like icon for field settings and do the following:
- Click Save.
Comments
This fix worked for us in the current version of the Shopify Netsuite integration app. The flow is Shopify order to NetSuite sales order (add). Our error was returning more than one Item in the item lookup, due to a small number of our SKU Items having a Vendor code that matched a SKU in a separate item. It seems crazy that Netsuite will match Vendor code when you ask it to only match on SKU or "Name" field in netsuite, and also strange that Celigo IA does not already have this mapping set correctly.
We are still having the same issue "A mapping error occurred. More than one match for "[["itemid","is","xxx-xxx-xx"],"AND",["isinactive","is","F"]]" for the record type "item".' and we have the following as out look up filter expression - [["nameinternal","is","{{line_items[*].sku}}"],"AND",["isinactive","is","F"]] which is the solution that was posted, however this is not resolving the issue.
Thanks for sharing the feedback, Jolyon Blazey. We will let our product team know about this and see if we can address this. Thanks!
Please sign in to leave a comment.