The Nexar Supply Excel Add-in enables you to access pricing and availability data from right within Microsoft Excel. You can populate part information for your BOM ...

The functions are located under the 'Formulas' tab under the 'Barcode Function Library' group (see images). All check digits are auto-calculated.