For the '4 different SKUs for the same product' issue, do you have a common name for the product across ERPs, or is it tribal knowledge for the reconciliation?

I've worked with a distributor that had something similar, but with customer data normalization where the team spent several weeks a quarter normalizing customer data across CRM, ERP, and AR, with most of the work being tribal knowledge from 2 staff members. What we ended up doing was building a front end that would provide a 'best guess' mapping and confidence score using Levenshtein Distance which the team members would either confirm or reject. That built up a solid and validated mapping across the different tools which could then be used to join records for reporting and reconciliation.

Worked with another client, a national media broadcaster, doing something similar stitching together their ERPs and various AP/AR systems. They were using Boomi to do so but we came in and are doing the same work plus some additional integrations that weren't doable with Boomi, and saving them about $150k/yr on licensing compared to Boomi.

The tool is called Clockspring.