Import Suppliers

From Hornbill
Jump to navigation Jump to search
Home > Administration > Supplier Manager Administration > Imports > Import Suppliers Index


Use the import suppliers option to upload New or Existing suppliers from a csv file.
Supplier Manager Imported Suppliers.png

Related Articles

Download Template File

Select the Download Template File button to download a CSV template file. The file will contain the column headers, under which you need your supplier data when looking to import new suppliers into Supplier Manager.

  • Use the Help option to understand both the purpose of each supplier attribute field, but also the expected format / length i.e 255 character limit (if it applies)
  • Once you have added your supplier data, save the csv ready for uploading.

Select CSV File to Upload

Select the Select CSV File to Upload button to choose the csv file you wish to upload.

  • Once selected, the import will be initiated, and the successfully imported suppliers will then be listed to confirm they have been imported into the staging form.
  • Before they can be imported, staging suppliers must be validated. To do this, select the specified records, or all records and click the validate button.
  • Staging records that have been successfully validated can be imported. To do this, select the specified records, or all records and click the promote button.
  • If the validation of a staging record results in errors being identified, you can open the individual record's details and correct the error(s) as directed. Once modified, the status of the staging record returns to unvalidated and must be validated again successfully before it can be imported.
  • If a valid supplier is provided, the existing supplier will be updated. If the supplier provided does not match a supplier that is already in the system, a new supplier will be created.
  • Once staging records have been imported, you can remove all records from the staging form, or just the ones that have been successfully imported.