I've looked into this issue specifically for piping, as it happens. From my perspective one of the issues with 'solving' this is basically: https://xkcd.com/927/

At the place I worked we had 3 different supplier databases, each one having been introduced to replace the last, which was never fully phased out.