Re: Need some expert help...
I've converted my share of pickups to 3-4 wire and it's never fun and I do agree with what freefrog suggests.
If there is hum like a coilsplit and it's similar to the tone of a tele bridge pickup it's series out of phase. Start off by swapping the red and green wires. See if you've got the same DC resistance as before and solder the pickup in. The output should increase and you've got your hum cancellation back as series out of phase is notorious for hum like a coilsplit. I knew one guy who liked the tone so much I had to figure out a way to make a push pull option for it. I'm not even joking. He would be like "hey man can you give me that Jimmy Page tone out of this guitar too".
I remember when I was figuring out how to charge magnets this guy put a pickup together with whatever unicorn elixir alnico he went with and forgot to charge his magnets but I'm sure this isn't the case but still something worth bringing up for total reassurance as there is the rare case of companies shipping magnets that aren't charged.
Before soldering the pickup in be sure to measure the DC resistance across each coil.
yellow / red - should give you one reading - lets say a 9.1k
green / black - should give you another - lets say 9.5k
if your DC resistance is approximately 18.6k - start off with the suggestion of swapping out the red / green wire
now the problem with just DC resistance alone is whether or not the pickups coils are correct. Standard series in our case. Or series out of phase both will give the same reading. Inductance is how I spot this but it's changing two wires around and if we know what we're doing this is no big deal... like our bass players sock color when we play live. After a long day you can even test a pickup from the jack which I hate doing but this is one of the two or three actually useful times to do it and if you know the inductance of the pickup is say 8H and wired into the guitar it reads 5H sort of area you mixed two wires up.
One real world example of series out of phase is if you swapped a black and white wire on a seymour duncan for whatever reason. Where the north start and finish mix up.
This means
white - to the pickups volume pot (les paul)
black is soldered with white - coilsplit - whether we're using it or not
and the rest of the pickup wired normally
You'll notice on guitarelectronics.com the pickup color codes have two names
starts (outer wires)
finishes (inside wires)
like below
View attachment 102693
and I'll end off with this quick and insightful video