Title: Bulk set categories
Last modified: June 7, 2017

---

# Bulk set categories

 *  [nmcleish](https://wordpress.org/support/users/nmcleish/)
 * (@nmcleish)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/bulk-set-categories/)
 * Hi.
    I need to upload about 150 images, to be set to maybe 7 or 8 categories.
 * The plugin does not have a feature to bulk select images and choose a category
   for those selected. As far as I can see, each image must be added to a category
   one by one.
 * Power users can achieve the bulk category addition by running an SQL query against
   the database, sure, but ‘normal’ users are going to find this plugin a pain to
   use, when they need to upload a ton of images in one go.
 * For those interested in the query to run, gather your image post ids from the
   wp_post_meta table; e.g. 601,602, 603, 604, 605.
 * Get your category id from the wp_terms table; e.g. 2 (you’ll see the category
   name next to the number)
 * Then build your SQL. For the above post ids and category, it would look like 
   this:
 * INSERT INTO wp_term_relationships (object_id,term_taxonomy_id) VALUES (601,2);
   
   INSERT INTO wp_term_relationships (object_id,term_taxonomy_id) VALUES (602,2);
   INSERT INTO wp_term_relationships (object_id,term_taxonomy_id) VALUES (603,2);
   INSERT INTO wp_term_relationships (object_id,term_taxonomy_id) VALUES (604,2);
   INSERT INTO wp_term_relationships (object_id,term_taxonomy_id) VALUES (605,2);
 * Run that through phpmyAdmin or adminer (or whatever is available to you).
 * When you then go to the Media Library and view by list, you’ll see that your 
   category has been applied to all the images you chose from the wp_post_meta table.
 * To the plugin dev: Please add a function so that users do not have to go through
   this dance, and more people may consider buying the pro version. I’m certainly
   not going to part with any money until I can bulk set categories.
 * Cheers.

The topic ‘Bulk set categories’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/go-gallery_9ab0bf.svg)
 * [Go Gallery](https://wordpress.org/plugins/go-gallery/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/go-gallery/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/go-gallery/)
 * [Active Topics](https://wordpress.org/support/plugin/go-gallery/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/go-gallery/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/go-gallery/reviews/)

## Tags

 * [categories](https://wordpress.org/support/topic-tag/categories/)

 * 0 replies
 * 1 participant
 * Last reply from: [nmcleish](https://wordpress.org/support/users/nmcleish/)
 * Last activity: [8 years, 11 months ago](https://wordpress.org/support/topic/bulk-set-categories/)
 * Status: not resolved