Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I have got hundreds of posts published but with inappropriate titles. I want to edit/updates titles. I have those all titles in a .txt file which I want to have them on the posts. If there is any solution?? I want the fastest way. It's also so hard for me to copy/past each title to the post. I want one-click method. I have heard on some sites that it can done by exporting all posts to .csv file which can be then edited in excel to change titles and then imported to the site. but again I guess the problem is still there in excel I have to edit each column which is again a very tedious. I wish if someone could refer me wordpress plugins or any kinda excel bot which can make my work done.

Thanks.

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

It depends how you produce the titles of the posts but something like:

  1. Load the posts into wordpress
  2. Update wp_posts using mysql

That's how I do bulk editing and it works very well.

share|improve this answer
add comment

There is no easy way to accomplish this. It is going to be a tedious task no matter what. But this got me thinking that since you already have them published into WordPress, you could export them via the WordPress export tool. Which puts all your posts into an xml file, you would then have to edit all the titles in that file. Much easier than doing it via WordPress, where you have to quick edit each post and save. After you are done editing the xml file you could then just import the xml file. Not the best solution, but works.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.