@Lucas This script runs when the sales order/quote is saved. Runs on beforeSubmit. Just need to try and get around the usage limit of 1000 units.

What I would do is loop thru the line items first and get the information that you need for the search, which in this case is the item internal id. After collecting the internal ids, do your search once, then loop thru the lines again to update it as needed.

That sounds like an actual plan. Just havent got any idea how to put into practice.