Categories without any posts

M

mitramarathi

BANNED

Apr 13, 2016

119

6

• Apr 25, 2016

• #1

dear freindsI had autoblog with 3000 postsdeleted half of thembut orphan categories are taking tollI only want to delete category with zero postsplz help

 

B

b1acky

Newbie

Jun 17, 2015

47

13

• Apr 25, 2016

• #2

If you are using wordpress you can check how many posts there is in each category in categories view.

 

M

mitramarathi

BANNED

Apr 13, 2016

119

6

• Apr 25, 2016
• Thread Starter Thread Starter

• #3

I want todelete
not check

 

LockerWizPro

Junior Member

Aug 10, 2010

146

222

• Apr 25, 2016

• #4

https://wordpress.org/plugins/wp-sweep/ that should be able to do the job.

 

Conor

Elite Member

Nov 7, 2012

3,621

6,217

• Apr 25, 2016

• #5

I hope your delete button works better than your spacebar.

In any case, something like this should work, if you have access to the database:

Code:

DELETE FROM wp_term_taxonomy WHERE taxonomy = 'category' AND count = 0

 

Last edited: Apr 25, 2016

M

mitramarathi

BANNED

Apr 13, 2016

119

6

• Apr 25, 2016
• Thread Starter Thread Starter

• #6

u want me to press delete button thousand times?

 

clevelandslim

Elite Member

Nov 15, 2008

2,655

233

• Apr 26, 2016

• #7

You may prevent WP from displaying categories :
In Admin, in the post editor screen within the Admin interface, use screen options to hide the category picker. And in your theme, remove category-related lines. This won't, technically, disable everything category-related from showing, but you and end users won't notice them.

 

living2xl

Elite Member

Dec 9, 2011

1,968

530

• Apr 26, 2016

• #8

You can delete manually. I know that its a time taking process.
But you have to do it. I don't think there is any too available for it.

 

M

mitramarathi

BANNED

Apr 13, 2016

119

6

• Apr 26, 2016
• Thread Starter Thread Starter

• #9

wp sweep worked fine
also I did same using mysql in backend

 

L

lostandfound86

Newbie

Apr 16, 2016

29

5

• Apr 27, 2016

• #10

Conor said:

I hope your delete button works better than your spacebar.

In any case, something like this should work, if you have access to the database:

Code:

DELETE FROM wp_term_taxonomy WHERE taxonomy = 'category' AND count = 0

Click to expand...

:smash: Absolutely right.

 

M

mitramarathi

BANNED

Apr 13, 2016

119

6

• May 1, 2016
• Thread Starter Thread Starter

• #11

tahnks
will try that sql query

 

SEO Sicko

Power Member

Oct 24, 2014

777

134

• May 2, 2016

• #12

If you are using an Wordpress means you have an option called Bulk edit feature where you can select all Uncategorized posts.
It will automatically creates some category for your posts.If not you can use this above option.

Try this out : Posts--> Categories and then select Delete.