when importing new items to an existing sales order i receive the following error "Ambiguity error on logical key multi-match.". how can i avoid this error

AI generated answer (using internal Slack threads):

The "Ambiguity error on logical key multi-match" error typically occurs when you are trying to add multiple line items of the same item to an existing sales order via CSV import. This ambiguity arises because NetSuite cannot determine whether you want to update an existing line item or add a new one. To avoid this error, you need to obtain the Line IDs from the original order and then, in your CSV, add Line IDs to the new line items that do not match the existing Line IDs from the order. For instance, if your order already has:

LINE ID   |    ITEM
1               Item X
2               Item Y
3               Item Z

And you want to add another line with Item X, you'll need to set the Line ID for that row in your CSV to 4 (or 5, 6, 7, etc., just not the existing line IDs). However, if you encounter the error 'The record has been deleted since you retrieved it', the solution is to not map the line id during the import. This error usually occurs when you are doing an add and update, or just update import. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******