A walsin part number not found search fails on 109 of our own 1,125 Hong Kong stock codes, and 101 of those 109 sit in one internal register. The register predicts the gap better than the part itself: 14.8% of one register fails to resolve, against 1.8% of the other — an eightfold gap nobody has counted before.
Venatech Limited, an authorised Walsin distributor in Hong Kong, holds all 203 of Walsin Technology (Walsin)’s parametric export files, and we re-measured our own ready-stock snapshot against every one of them rather than repeat a figure from an earlier post. This draft is measured from the Hong Kong stock workbook — read with header=3, dated 23 September 2026 in row 2 of the file despite a filename that says a different date — joined cell by cell against all 203 Walsin export files. Every code below is real, every count is of part numbers, and where a code has no matching row we say so on the same line, because that absence is the finding.
How many of our own stock codes return a Walsin part number not found?
One hundred and nine of 1,125. We took every catalogue code and order code in the snapshot, normalised whitespace out of both sides, and searched all 203 Walsin export files cell by cell rather than column by column, because a code can sit in the wrong column of an inconsistent schema. 109 codes, 9.7% of the shelf, return nothing. We published 101 in an earlier post; re-measuring cell by cell against the export files alone, independent of our own master index, the figure is 109, and we are stating the higher number rather than the lower one.
| What we searched | Scope | Result |
|---|---|---|
| Catalogue and order codes in the 23 September 2026 snapshot | 1,125 | 1,016 resolve, 109 do not |
| Export files searched, cell by cell | 203 | 121 non-empty sheets, 83 files return zero rows |
| Normalised distinct values across those sheets | 363,176 | None of them matches the 109 |
| Product lines carrying a gap | MLCC, MLCC (specialty), chip resistor, safety capacitor, 1 uncategorised line | 91 + 11 + 5 + 1 + 1 |
A code absent from every export is not a code we cannot supply. It is a code the automated path — our own cross-reference tool included — cannot describe. That distinction is the whole post.
Why does a naive string match find 176 missing codes and a cleaned one find 109?
Because 67 of those 176 are not really missing — they are present with an embedded space Walsin’s own export carries and a naive search does not strip. We ran the match twice: once on the raw cell text, once after removing all whitespace from both sides and upper-casing. The raw match returns 176 codes with no row anywhere. The whitespace-normalised match returns 109. The gap between those two numbers, 67 codes, is not a documentation hole at all — it is a search defect, and it is the first thing any tool built on this data has to get right before it reports a single missing part.
| Match method | Codes returning no row | What it tells you |
|---|---|---|
| Raw string match, no cleaning | 176 | Counts a formatting difference as a missing part |
| Whitespace stripped, upper-cased | 109 | The real gap, net of a known chip resistor export defect |
| Difference | 67 | All but one are chip resistor or array codes — see below |
Which register predicts a missing code better: the one with a description, or the one without?
The register with a description, by a factor of eight. Our stock file is two concatenated registers, not one: 683 of the 1,125 rows carry both an internal description and a date code, and the other 442 carry neither. Of the 109 codes with no Walsin export row, 101 sit in the 683-row register and only 8 sit in the 442-row register. That is a 14.8% failure rate in the first register against a 1.2% failure rate in the second — the first register is roughly eight times more likely to produce a gap. We have not seen this correlation published anywhere, by us or by anyone else, and it is a cleaner predictor of a gap than the dielectric, the case size or the product line.
| Register (by our own description/date-code fields) | Codes in register | Codes with no export row | Failure rate |
|---|---|---|---|
| Carries a description and a date code | 683 | 101 | 14.8% |
| Carries neither | 442 | 8 | 1.8% |
| Catalogue code | Product line | Register | Order code carries CT? |
Match / mismatch vs a code Walsin’s export can describe |
|---|---|---|---|---|
0201B101K160 |
MLCC | Carries description | Yes, 0201B101K160CT |
Match — resolves cleanly to a General Purpose Caps row, included for contrast |
0402F104Z100 |
MLCC | Carries description | Yes, 0402F104Z100CT |
Mismatch — no row in any of 203 files; one of the 101 in the higher-failure register |
0805F474Z500 |
MLCC | Carries description | Yes, 0805F474Z500CT |
Mismatch — same register, same gap pattern |
0805N331G201 |
MLCC | Carries neither | Yes, 0805N331G201CT |
Mismatch — one of only 8 gaps in the lower-failure register |
SH21B472J251 |
MLCC (specialty) | Carries neither | Yes, SH21B472J251CT |
Mismatch — same rare group, soft termination series |
WR12X0000FTL |
Chip resistor | Carries neither | No — identical in both columns | Mismatch — no row found even before any cleaning changes the result |
We will not tell you a register is the cause. We will show you that it correlates, and leave the mechanism to Walsin to confirm.
Why are 66 of the 67 rescued codes chip resistors, and what does that say about the gap?
Because the known chip resistor space defect sits exactly where it should. We identified the 67 codes that fail a raw string match but pass once whitespace is stripped, and 66 of the 67 are chip resistor codes, with the 67th a resistor array code. WR04X000PTL, WR04X101JTL and 64 others like them carry an embedded space inside Walsin’s own export cell, not inside our stock file — the same defect documented across the chip resistor data generally, where 39,576 of 234,815 part numbers contain an embedded space. None of the 67 is an MLCC code, which tells you the embedded-space defect and the register-correlation gap are two separate problems with two separate causes, not one problem counted twice.
What does a Walsin part number not found actually mean for a buyer?
That the automated path cannot describe the part, and nothing more. 109 of 1,125 — just under one in ten — of our own shelf will not resolve through any tool that reads Walsin’s published data cell by cell, our free cross-reference tool included, and the better predictor of which ones fail is which internal register they came from, not what the part looks like. A buyer should read a “not found” result as a prompt to ask a person, not as a statement about supply.
- Cross everything that will cross, in one pass. Paste up to 500 part numbers or drop an Excel or CSV into the free cross-reference tool. It is matched against Walsin’s published catalogue and states every difference field by field rather than hiding one.
- Send the residue as a question, with the catalogue code, not the order code. We hold 28 Walsin datasheets, 451 pages, and will tell you plainly when a part sits outside all of them.
- Check the dated shelf separately on ready stock, as at 23 September 2026. Part-number counts only; a code’s presence on the shelf and its presence in the export are two different questions, and this post is about the second one.
For the fuller breakdown of the 109 by dielectric and case size, see Walsin part number not found: 109 codes we hold. For why a code resists pasting at all, see why Walsin part numbers do not paste into your BOM. The chip resistor range most affected by the space defect is on the Walsin chip resistor page.
The short version
109 of 1,125 catalogue codes on our 23 September 2026 Hong Kong snapshot return no row in any of Walsin’s 203 export files, searched cell by cell with whitespace normalised. A raw, uncleaned search finds 176 — the extra 67 are not real gaps, and 66 of those 67 are chip resistor codes carrying Walsin’s own known embedded-space defect. Of the real 109, 101 sit in the stock register that carries a description and a date code, where the failure rate is 14.8%, against 8 in the other register, where it is 1.8%. We will not tell you why. We will show you that it correlates, and we are asking Walsin the same question we are asking you to stop and consider: which system populates which register, and why does one of them miss so much more often than the other. Qualification stays with you.
Send us any code a cross-reference tool returned as not found — ours or anyone’s — with the register or source it came from if you know it, and we will decode it by hand and tell you what we hold. And if you can think of a reason one internal register should be eight times more likely to miss Walsin’s own catalogue than the other, we would like to hear it before we ask Walsin.
Frequently asked questions
What does it mean when a Walsin part number is not found?
It means no row in any of Walsin’s 203 parametric export files describes that code, searched cell by cell with whitespace normalised. 109 of our own 1,125 Hong Kong stock codes return this result. It is a documentation gap in the automated path, not a statement about whether the part can be supplied.
Why do a raw search and a cleaned search give different numbers?
A raw, uncleaned string match against our stock codes returns 176 with no matching row. Stripping whitespace and upper-casing both sides before comparing brings that down to 109. The 67-code difference is almost entirely a known embedded-space defect in Walsin’s own chip resistor export, not a real documentation gap.
Does the register a code sits in predict whether it will be found?
Yes, more strongly than any other field we checked. 683 of our 1,125 stock rows carry both a description and a date code; 101 of those 683, or 14.8%, return no Walsin export row. The other 442 rows carry neither field, and only 8 of those, or 1.8%, fail to resolve. We have not seen this correlation published anywhere else.
Why are most of the rescued codes chip resistors?
Because the embedded-space defect that a naive search trips over is documented specifically in Walsin’s chip resistor data, where 39,576 of 234,815 part numbers carry a space inside the cell. 66 of the 67 codes rescued by whitespace normalisation in our own check are chip resistor codes, and the 67th is a resistor array code — none is an MLCC code.
Can Venatech still supply a code that returns not found?
Being absent from the export says nothing about availability. It means our cross-reference tool and any other automated path built on the same files cannot describe the part, so the question has to come to a person. Send us the catalogue code and we will decode it by hand and tell you what documentation we hold.
What is the fastest way to get an answer on a code that will not resolve?
Cross the rest of your list through the free cross-reference tool first, then send us the residue directly with the catalogue code rather than the order code. We will tell you whether the gap is a known defect, a register pattern, or something we need to ask Walsin about, and whether the part was on the Hong Kong shelf on 23 September 2026.