I’ve done this, just in a different way. It involves several components
1. Custom record for Old Part number and a list/record field for the new part
2. Custom line item field set as list/record pointing to custom record items
3. workflow that triggers when you enter the legacy number and it fills in the new item
If you are simply changing the original item and not creating new ones, this will still work.