SAP Knowledge Base Article - Public

3642241 - Product is shown multiple times in Catalog and in Bulk Export

Symptom

When attempting to Bulk Export a product it is shown multiple lines in the exported file and, for the same product, when navigating in Catalog, there are multiple entries, but when checking the Product Setup, there is only 1 register. 

Environment

SAP SALES CLOUD CPQ

Reproducing the Issue

  • Search for a part number in the product catalog
    • Product can be seen multiple times
  • On Setup, perform a Bulk Product Export and Filter by Part Number
    • Multiple Lines for same product can be seen.

Cause

Expected Behavior

Resolution

  • Issue Occurs due to multiple entries in the User Chosen Price Book with valid "Valid From" and "Valid Until" values for the the same part number
    • Empty values are also considered valid
  • As user is using the price book with multiple entries, all matching records are applied during processing of information (catalog and product export)
  • in order to avoid multiple products to be shown in Catalog and in Export, it is needed to set the "Valid Until" field to an expired date for all rows except the one needed to be retrieved by the system.

Keywords

Price Book, Product Export, Catalog, Bulk Export, Multiple Products, Duplicated Products, Price, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Bug Filed

Product

SAP CPQ 2024