Error: Failed to add Walmart Order# 4577399813010. A mapping error occurred. More than one match for "["itemid","is","ABCITEM"]" for the record type "item".'.

The Order Import flow, while creating the order in NetSuite, runs a lookup search for the item whose name is the Walmart SKU (ABCITEM in this case).

 

The NetSuite logic for lookup is tricky in this way that it not only compares the "Item Name/Number", but also compares "Vendor Name/Code".

Documentation of this logic can be found here.

Due to this logic only, if you run a saved search for item in NetSuite, with column "Name" "is" "ABCITEM", it gives you 2 results.

Both the products "ABCITEM" and "ABCITEM_OB" have the same Vendor Name/Code, i.e. "ABCItem"

Resolution: An easy solution for this would be to change the Vendor Name/Code for the item "ABCITEM_OB". Adding even a single trailing character(. or -) to the Vendor Code/Name would solve the issue.