The Master Vendor List, or MVL, is an external file of information about your vendors. You can upload the MVL to provide new or updated vendor information, and you can download the MVL to review existing vendor information that would otherwise be accessible only by displaying the details for each vendor in PaymentNet.
When you upload the MVL, the file can contain your entire vendor list with additions and changes, or it can contain only the records you want to add or update. A sample MVL template and detailed instructions for using it are provided in the SUA Vendor List Guide on the Resources page in PaymentNet.
You will receive one of the following email notifications when processing of your uploaded file is complete:
Success - The file was processed successfully without errors; all the records were updated.
File failure - The file could not be processed; no records were updated.
Successful with errors - The file was processed successfully but some errors occurred. The records that could not be updated are listed in the notification.
Note:If you use Vendor IDs in your payment file, you must upload the MVL to create the vendor record before submitting a payment request for a new vendor. If you use email addresses in your payment file, you do not need to upload vendor data first.
If you need to change the vendor ID, set ID, or site ID for existing vendors, you must upload a Vendor Identifier Update File.
Downloading the MVL creates a .csv file that contains information about all your vendors, as well as additional information for vendors who participate in SUA Connection.
Note: The downloaded MVL is intended for informational purposes only; you cannot upload this file to update vendor records.
To upload the Master Vendor List:
Click the Upload MVL button on the Vendor List screen or on the Manage Vendors tab of the SUA Overview screen.
In the file dialog box, browse to and select the .csv file that contains the Master Vendor List, then click Open. The size of the file cannot exceed 10MB. No file types other than .csv are allowed.
To download the Master Vendor List:
Click the Download MVL button on the Vendor List screen or on the Manage Vendors tab of the SUA Overview screen.
When the download is complete, PaymentNet displays a confirmation message with a link to the Available Downloads screen. Click the name of the export file you want to download.
When prompted, click Save to save the file to your local machine.
Note: In order to preserve any leading zeros in your data (for example, in Vendor IDs or zip codes), do NOT double-click to open the file in Excel at this point.
Open a new Microsoft Excel workbook.
From the Data menu, select Get External Data > From Text, navigate to the .csv file you downloaded to your local machine, and click Import.
In Step 1 of the Text Import Wizard, select Delimited as the Original data type, and also select the My data has headers option. Then click Next.
In Step 2, select Comma from the Delimiters list (make sure no other delimiter options are selected). Then click Next.
In Step 3, select all the columns in the Data preview area (the first column is selected by default). Hold down the Shift key, then scroll to the last column and click the header. Select Text as the Column data format and click Finish.
When prompted, indicate whether you want to import the data into the existing worksheet at the specified location or into a new worksheet. Then click OK to close the Wizard.
When the data import is complete, save the workbook as an Excel (.xlsx) file.