Seems odd that the wiring for for valve wouldn’t work. For me those worked great.
The connector in the harness is normal drc connector. Lots of variations available , so it is tricky to find the right one.
The one I have in this enclouser is DRC22-40PA
Can be found at mouser: DRC22-40PA TE Connectivity / DEUTSCH | Mouser Finland
Also the one that is in the harness(should not be needed): DRC26-40SA TE Connectivity / DEUTSCH | Mouser Finland
And pis for those connectors: