Delete guest list

  • jamesgird

    (@jamesgird)


    6 years, 3 months ago

    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

    (@yithemes)

    6 years, 3 months ago

    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.