3652489 - How to remove shared favorites from CPQ tenant?

• A user has mistakenly marked multiple favorites in the product catalog as shared favorites, making them visible to all users within the tenant.
• These shared favorites are now appearing for other users.
• However, the admin is unable to identify the user who created them from the audit trail and cannot find an option to delete them. 

SAP Sales Cloud CPQ

The inability to delete shared favorites is due to system restrictions where only the user who created the favorites can delete them.

It is possible to identify the user who created specific favorites using scripting. You can use the Script Workbench to find the user who created a favorite by using its FavoriteId.

To find the favorite IDs, follow these below steps:

1. Login to your tenant and open browser console by pressing Fn+F12.
2. Click on the Network tab in the console.
3. Now click on the Favorites option and you'll see some entries under the Network tab in the browser console.
4. Scroll down and look for GetInitData? entry as highlighted in the screenshot, and  click on it.
   
   

5. Click on the Response payload and you can do Ctrl+F and look for "FavoriteId", or else you can copy paste this response to a notepad and search for all the FavoriteIds.

Once you have the desired favorite IDs that need to be deleted, please execute the following line in the Script Workbench:
 x = SqlHelper.GetList(''' select CreatedByUserId from FavoritesDefinition where id = xyz ''')

Here, instead of xyz you need to put in the favorite ID.

1. When you have the information about the user, contact them and have them delete the global favorites.
2. If the user is no longer working with you, then:

• Provide the list of favorite IDs to the support team for deletion via a database update, and provide this KBA as a reference.
• Alternatively, delete the user account to check if the associated global favorites are also removed.

Note: To prevent this issue from occurring in the future, it is recommended to update the Set Favorites Permissions setting to restrict this action to admins only. 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Refer to: Favorites Management

global favorites, shared favorites, sales cloud cpq, delete favorites, admin permissions, script workbench, audit trail, product catalog, database update, favorite IDs, user-created favorites , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem