Title: Delete guest list
Last modified: February 6, 2020

---

# Delete guest list

 *  [jamesgird](https://wordpress.org/support/users/jamesgird/)
 * (@jamesgird)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/delete-guest-list/)
 * We changed the setting for Wishlists to be enabled for all users to Only Authenticated
   Users.
    Under the “All Wishlist” tabs there is still over 11 000 lists for guest
   users, and they are just staying there. How can all list for guests be deleted
   without doing it screen by screen for almost 600 pages of lists?

Viewing 1 replies (of 1 total)

 *  Plugin Author [YITHEMES](https://wordpress.org/support/users/yithemes/)
 * (@yithemes)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/delete-guest-list/#post-12404995)
 * I’m afraid the only way to proceed in this case is to bulk delete wishlists directly
   from DB using a couple of dedicated queries
 *     ```
       DELETE FROM wp_5_yith_wcwl WHERE wishlist_id IN ( SELECT ID FROM wp_5_yith_wcwl_lists WHERE user_id IS NULL );
       DELETE FROM wp_5_yith_wcwl_lists WHERE user_id IS NULL;
       ```
   
 * Please, note this is only an indication, and you should double check the queries
   before performing them on your DB; you should refer to an expert developer, if
   you’re not confident enough working with DBMS
    Besides, you should create a backup
   before proceeding, in order to avoid losing any important data by accident

Viewing 1 replies (of 1 total)

The topic ‘Delete guest list’ is closed to new replies.

 * ![](https://ps.w.org/yith-woocommerce-wishlist/assets/icon-128x128.gif?rev=3129302)
 * [YITH WooCommerce Wishlist](https://wordpress.org/plugins/yith-woocommerce-wishlist/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/yith-woocommerce-wishlist/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/)
 * [Active Topics](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [YITHEMES](https://wordpress.org/support/users/yithemes/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/delete-guest-list/#post-12404995)
 * Status: not resolved