3571055 - Business Partner Upload Failure Due to Duplicate System IDs in SAP CPQ

• An attempt to upload around a lot of Business Partners (BP) records in SAP CPQ was partially unsuccessful.
• Only some of them were successfully uploaded, but the job status shows as Finished on the Bulk import/export page.

Sales Cloud CPQ

1. Go to Setup in SAP CPQ.
2. Navigate to Import/Export.
3. Select Bulk Business Partner Import/Export.
4. Upload the excel file containing records.
5. After the job completes, search for any of the BPs from the uploaded records in the system and they're missing.

The Excel sheet contained multiple records with duplicate System IDs. As SAP CPQ requires System IDs to be unique, these duplicates caused import errors.

1. After uploading a file and completing the import job, download the corresponding Import job report to review the process.
2. Look for rows highlighted in red in the report. These rows represent errors encountered during the upload.
3. Scroll to the last column of a red row to find an error message stating: "System ID must be unique."
4. Ensure that the System IDs are unique before the next import.

SAP CPQ, Business Partner, BP, Upload, Import, Duplicate, System ID, Import Job, Error, Unique, Report. , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem