 |
| ||||||||
How to do Import Supplier using task Import for Supplier from Sourcing in Supplier Lifecycle & Performance (SLP)? How do I import legacy supplier in SLP?
You need to first export the supplier organization from sourcing. Steps for exporting suppliers from Sourcing:
- Go to Manage > Administration > Site Manager > Data Import/Export
- Click Export tab and search for Export Supplier Organizations (CSV)
- Click Export
While exporting suppliers from Sourcing: after downloading the .zip file from Sourcing, do not change the CSV file names, the data can be edited but the names of the files must remain the same. That naming convention is how the system differentiates the two files in it. You should also not open the files in Excel, as it wipes out leading zeroes. Instead, use a text editor.
- Edit the files in text editor (Notepad++). Keep the required supplier data in the files and save the files (do not change the CSV file names) and .zip them.
When you are importing supplier using option Suppliers from Sourcing you should import the .zip file which includes both SupplierOrganization_Export.csv, which contains data on the suppliers, and SupplierOrganizationOrganizationIdPart_Export.csv, which maps supplier domain ID's.
Steps to import the supplier:
- Go to Manage > SM Administration
- Data Import/Export > Type: Suppliers from Sourcing
- Browse the newly created .zip file and Upload.
The buyersystemid domain in SupplierOrganizationOrganizationIdPart_Export.csv file contains the SystemID which will populate the ERP Vendor ID in SLP (if you enable Consider Object Id as ERP Vendor Id option).
If you want another ID (not SystemID) to set as ERPVendorId then add a domain as "sap" for organization in downstream. Save the changes, export the suppliers, then use the exported files.
You can also check below documentation:
Supplier Lifecycle & Performance > SM Administration