I have a list of more than 100 Amphenol part numbers. However, when I upload the BOM, the results do not correctly match the manufacturer Amphenol. Therefore, I’m thinking of using Digi-Key part numbers to upload the BOM instead.
So, how can I obtain a list of Digi-Key part numbers without having to search for each part number individually in the search bar?
Hello @Serein
Using Mil Spec part numbers in your BOM can result in multiple manufacturer for each part number. You are correct in thinking using the DigiKey part number will differentiate the manufacturer. However I am not sure of how you can do this automatically without getting each part number individually or enter each manufacturer number into a list and use the drop down to select the right vendor you are wanting.
Greetings,
As mentioned, the most likely reason for manufacturer part numbers not resolving to the desired vendor is that your list contains mil-spec part numbers (such as 38999 series products) which by design have the same part number regardless of manufacturer.
In such a case you’re likely seeing something like the below during the upload process:
Using the “View Options” link to select the desired vendor/DigiKey part number on a per-item basis is likely to be faster than using the search bar.
However, an possibility that may save some additional effort is to guess the DigiKey part number based on observed patterns and applying it preemptively in the list being uploaded, such as by using Excel’s CONCAT() function or similar. In the example above, the DigiKey P/N simply adds a -ND suffix to the Mfr P/N. The same pattern will not necessarily apply to all items, but when looking for similar items from a single vendor, it may be worth a try.