Hi Mike,
Apologies for a delayed response. The copy-paste functionality works just as you are thinking. Once you see the IDs, after pasting in either of the columns, Click on Save. If there is a duplicate product id, it might show error and remove it but rest will be saved. Once you get the “product updated successfully” message, you can click on ‘Search’ button and it will show the products perfectly. I hope this answers your query.
Let me know if you still face any issues.
Regards,
Ankit