Bulk Upload Vendors

Follow these steps to create your Vendor Directory. Learn how to:

Download the vendor template .csv

  • Navigate to Workspace and then to the vendors tab.
  • From the Vendors tab, click the blue 'Add Vendors' button.
  • From the dropdown, click 'Download a vendor list template' and an automatic download will begin.

Validate and review the .csv format

  • Users must download and use the provided CSV file template to ensure successful file upload and must adhere to the CSV formatting to avoid upload errors.
  • Vendor Name and External ID are mandatory fields. Entries with empty values will not be imported and upload errors will be encountered.
  • Invalid entries and duplicate data on the CSV file is not imported while new versions of existing Vendor entries are overwritten.
  • Upload only accepts .csv file extension. Error is encountered if incorrect file is uploaded: Unsupported file type. Please try again.
  • Limit to 2000 rows per file upload

Mandatory and Optional Fields: 

  • Vendor Name: Mandatory, Must not exceed 100 characters. 
  • Vendor ID: optional, max length: 50
  • Comments: optional, max length is 4000 characters
    • Contact Information Fields: If Vendor entries have no contact information - vendors are created but it will display the “Missing contact” label to the row on the UI)
      • Contact Name: optional, max length: 50
      • Contact email: 1 email address only, no max character limit but email address should be valid
      • Contact number: no max limit but contact phone with country code should be valid (I.e 19713942775)
        • Phone Country Code: Country code (without +) 
        • Contact Number
  • Addresses (both mailing and billing are optional)
    • Mailing Address (all fields max length: 300)
      • Address line 1
      • Address line 2
      • City
      • State / province / region
      • Country: 2 Digit Country Code
      • Zip / postal code: Numeric only
    • Billing same as mailing: True and False are the only accepted values
      • True if the Billing Address is the same as the Mailing address 
      • False if no Billing Address or Billing Address isn’t the same as the Mailing Address
    • Billing Address (all fields max length: 300)
      • Address line 1
      • Address line 2
      • City
      • State / province / region
      • Country: 2 Digit Country Code
      • Zip / postal code: Numeric only
  • External ID: Mandatory

Upload completed vendor file .csv

  • Navigate to Workspace and then to the Vendors tab.
  • From the Vendors tab, click the blue 'Add Vendors' button.
  • Select "Upload vendor list"
  • Either drag the completed vendor upload file into the yellow box or click the yellow upload box to select the file from the file manager.
  • Click the blue 'Upload file' button.

  • A message will appear to confirm that any new versions of existing vendors in the Vendor Directory will be overwritten with the newest version from the file you are uploading. If you wish to proceed, click 'Yes, upload vendor list'.
  • The system will indicate if the upload was Successful or Failed.

Outcome: Success or Fail

Success

If all entries from the .csv file are uploaded with no errors, you'll see two confirmation messages indicating the upload was successful. 

You will also receive an email notification if the upload was a success.

Example upload successes:

  1. Uploading a CSV file with Vendor Name and External ID already existing on the workspace but with updated values on other fields will replace or overwrite the existing data for that Vendor/External ID based on the CSV file. 
    • Existing: 
      • Vendor Name: VendorName1 / External ID: ExternalID1 / Mailing Address City: New York
    • Upload: 
      • Vendor Name: VendorName0 / External ID: ExternalID0 
      • Vendor Name: VendorName1 / External ID: ExternalID1 / Mailing Address City: Los Angeles
    • Outcome: Successful
      • Vendor Name: VendorName0 / External ID: ExternalID0 is uploaded successfully
      • Mailing Address City of VendorName1/ExternalID1 is updated to Los Angeles

Fail

The outcome is Fail if:

  • all entries from the .csv file are uploaded with errors in its entirety, or
  • a .csv file is uploaded with valid entries and entries with data errors.

You'll be alerted via two error messages if the upload has failed. Click the 'View upload errors' button to view the error identified by row to help you identify which data should be corrected on your file prior to re-uploading it.

You will also receive an email notification if the upload failed.

Example upload fails:

1. Uploading a CSV file with Vendor Name already existing on the workspace but External ID is unique
    • Existing: 
      • Vendor Name: VendorName1 / External ID: ExternalID2
    • Upload: 
      • Vendor Name: VendorName1 / External ID: ExternalID3
    • Outcome: Failed, upload error as Vendor Name already exists
2. Uploading a CSV file with a unique Vendor Name but the External ID already exists on the workspace:
    • Existing: 
      • Vendor Name: VendorName2 / External ID: ExternalID2
    • Upload: 
      • Vendor Name: VendorName3 / External ID: ExternalID2
    • Outcome: Failed, upload error as an inline update of the vendor name is restricted on the UI
3. Uploading a CSV file with a unique Vendor Name and External ID but has duplicate entries within the CSV:
    • Existing: 
      • Vendor Name: VendorName2 / External ID: ExternalID2
    • Upload: 
      • Vendor Name: VendorName3 / External ID: ExternalID2
      • Vendor Name: VendorName3 / External ID: ExternalID2
    • Outcome: Failed, upload error as entries on the CSV are duplicates even if doesn’t exist on the workspace
4. Uploading a CSV file with an existing Vendor Name and External ID new contact information within the CSV:
    • Existing: 
      • Vendor Name: VendorName2 / External ID: ExternalID2 / Contact Name: John Doe / Contact Email: john.doe@gmail.com
    • Upload: 
      • Vendor Name: VendorName2 / External ID: ExternalID2 / Contact Name: Jane Doe / Contact Email: jane.doe@gmail.com
    • Outcome: Upload is successful but the existing contact name is not replaced, instead new information from the CSV file is added as new contact information to the Vendor
5. Additional validations: Entries on the CSV file shouldn’t be successfully imported if there are:
    • Empty External ID or Vendor Name on the CSV
    • Fields exceeded the maximum character limit
    • Incorrect or invalid country code (only accepts 2-letter country code)
    • Contact Info: Contact name exceeds the maximum character limit
    • Contact Info: Incorrect email format
    • Contact Info: Invalid country phone country code contact number
    • Contact Info: Empty contact name but contact email and contact number are populated with valid data.
    • Contact Info: Contact name (with value) but contact email and contact number data are invalid
    • Missing columns on the CSV file.
    • Column positions that are interchanged.