How do I modify or add ERP Vendor Key information for a supplier?
ERP Vendor Key information is missing for our supplier (eg. Vendor ID, Business System ID, Site ID or Location ID). How do I add it?
You can modify or add ERP Vendor Key information for a supplier in two ways:
Via Data Import/Export:
- Manage > Administration > Site Manager > Data Import/Export
- Export tab > Search Organization with vendor keys
- Export the zip, make a copy of it to save as a backup
- Open both csv's within the zip
- OrgWithVendorKeyHeaderExport - add your Supplier's SystemID as a new row, if it doesn't already exist in the file
- OrgWithVendorKeyDetailsExport - add the SystemID if it doesn't already exist, along with any other necessary IDs
- Save and close both files
- In Ariba, tab to Import Organization with vendor keys, select Import then select the appropriate Operation and upload both files
- Load if your file contains all existing rows plus the row you're adding, Update Only if your file only contains the row(s) that you're adding
Via the user interface (UI):
Strategic Contracts > Strategic Contracts Import/Export
Strategic Sourcing > Strategic Sourcing Import/Export