Delete All Listings in Specific Category

This topic contains 14 replies, has 3 voices, and was last updated by  serendipity 3 years, 11 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #539683

    serendipity
    Buyer
    Post count: 131

    I have duplicate listings in a specific category that need to be deleted. I have 5 I read https://www.competethemes.com/blog/remove-wordpress-posts/ and after following instructions I attempted to delete all listings but my WordPress simply wouldn’t delete even one listing. I changed the screen options to 100 instead of 200 but it still wouldn’t work. Some listings are in 2 or 3 categories but I only want to delete listings that are in 1 specific category, not multiple categories.

    I keep getting the following message:

    Sorry, you are not allowed to move this item to the Trash.

    Could you please help me delete these listings?

    Thanks a lot

    #539684

    serendipity
    Buyer
    Post count: 131
    This reply has been marked as private.
    #539729

    Kor
    Moderator
    Post count: 16516
    This reply has been marked as private.
    #539760

    serendipity
    Buyer
    Post count: 131

    Hi,

    I cleared the browser cache and WP cache and I’m still getting this error:

    Error in moving to Trash.

    How many listings from that specific category were you able to remove? What is the best way to remove all of the listings in that category? Is there a way to do it from the database?

    Awaiting a reply

    #539769

    Kor
    Moderator
    Post count: 16516

    Hi serendipity,

    Thanks for your reply. I’ve just tested removing 17 listings at a time. Maybe it stalls when you try to remove too many at a time. I will forward this to a developer for a second opinion.

    #539790

    Naveen Giri
    Moderator
    Post count: 1559
    This reply has been marked as private.
    #539979

    serendipity
    Buyer
    Post count: 131

    Hi Naveen,

    Oh, you saved me so many hours of work. I spent at least 3 hours and only made it to the letter E.

    Can you please delete all posts in the trash folder too? I’ve been having the same problem removing items from the trash folder.

    Thanks so much

    #540004

    Naveen Giri
    Moderator
    Post count: 1559

    Removed them using the empty trash button.
    Please have a look.

    #542700

    serendipity
    Buyer
    Post count: 131

    Hi Naveen,

    I just noticed that I have another site where I have duplicate listings that need to be removed. There are 3199 pending listings that need to be deleted and I wonder if you help me complete a bulk delete of the pending listings using the script you shared above. The pending listings are the duplicates. Also, please check that the trash is also empty. See attached screenshot. WP login details below.

    Thanks a lot

    #542703

    serendipity
    Buyer
    Post count: 131
    This reply has been marked as private.
    #542890

    Naveen Giri
    Moderator
    Post count: 1559

    Hi, I will proceed and let you know.

    Regards
    Naveen

    #543035

    Naveen Giri
    Moderator
    Post count: 1559

    Hi, serendipity

    before proceeding just to be confirmed.
    do you want me to remove all the pending places that are only in the “brewery” category?

    #543250

    serendipity
    Buyer
    Post count: 131

    Hi Naveen,

    Please see my post on April 27, 2020. This request to remove 3199 pending listings is on another site because they are all duplicates and I have given you the login details April 27th. I added a screenshot in the first post dated April 27th.

    Thanks

    #543251

    Naveen Giri
    Moderator
    Post count: 1559

    Hi serendipity

    Please have a look. I have removed those pending posts.

    your other reply created confusion for me.

    Please help me delete duplicate listings in the “brewery” category only. Do not delete listings that are in multiple categories. See attached.

    Regards
    Naveen

    #543354

    serendipity
    Buyer
    Post count: 131

    Hi Naveen,

    Yes, you helped me remove those pending posts.

    Thanks a lot

Viewing 15 posts - 1 through 15 (of 15 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket