1. Create a query of Vendor Import IDs and export it to Excel.

2. Add the new Vendor IDs to the next blank column and save the spreadsheet as a CSV.

3. In Administration, Import Records, create a new Vendor Import parameter.

4. On the General tab, select to Update Existing Records and Validate Data Only.

5. Browse out to the CSV file and select to import using the Vendor Import ID.

6. On the fields tab, map out the specified columns.

7. Click Validate Now.

8. Once zero exceptions are received, uncheck Validate Data Only on the General tab and click Import Now.