I have "Service for Resale" items: Item1, Item2, Item3, Item4
One of the orders with Item1 gave me an error during import: "The itemRef element contains a reference that is not unique" I thought that was weird, so I put Item1 in search box in NetSuite. Strangely, it listed both Item1 and Item2. When I search for Item2, it still lists both. Those items are somewhow connected but I could not find out how or why.
Both items cost the same, they are from the same vendor, they have different internal ID and names. They are not subitem of anything, and they don't have any related/corelated items.
Why either name refers to both items? Is this something I overlook or an internal database issue? Item3 and Item4 are fine. If there is a quickfix can someone please help so I can import my transactions properly.
Edit: I found couple other items. One thing they have in common is the length of the item name. Problem arises when the first 32 characters of the item name are identical. Looks like NetSuite compares the first 32 characters of the item names, even though we are allowed to put longer item names. I hope someone will tell me I am wrong.
thank you