Issue
- I have an issue with the commerce wish list table in the database. The table has lots of entries and it is growing more, even though we do not use the wish list feature. I would like to remove these entries and disable the creation of the wish lists.
Environment
- Liferay DXP 7.1+
Resolution
- The "CommerceWishList" table can be cleaned safely using the the following query:
DELETE FROM CommerceWishList WHERE defaultWishList = '0';
This can be used safely as there are no dependencies.
-
Regarding the possibility of disabling the functionality, first you will need to remove all instances of the Wish Lists and Wish List Content widgets on their pages (or if you have a page for the wish lists, you can remove the permissions to access the page to users/guests or remove the page entirely if you do not need it).
There are also configurations under Control Panel --> Configuration --> System Settings --> Commerce --> Wish Lists to limit the number of guest wish lists and guest wish list items:
Guest Wish List Max Allowed
Guest Wish List Item Max Allowed
When set to 0 these configs will prevent the creation of new wish lists and wish list items. Please see the attached screenshot: CommerceWishList.png