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.