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
SAP Knowledge Base Article - Public