[wp-trac] [WordPress Trac] #11302: Bulk editing posts should pre-fill fields with the same value / allow for removal

[WordPress Trac]

#11302: Bulk editing posts should pre-fill fields with the same value / allow for
removal
-----------------------------+-----------------------------
 Reporter:  pavelevap        |       Owner:
     Type:  enhancement      |      Status:  new
 Priority:  normal           |   Milestone:  Future Release
Component:  Quick/Bulk Edit  |     Version:  2.9
 Severity:  normal           |  Resolution:
 Keywords:  needs-patch      |     Focuses:
-----------------------------+-----------------------------

Comment (by lau@…):

 I just tried the Batch-Move posts plugin but that only deals with post
 categories and posts. It doesn't deal with product categories and
 products.

 I think I've figured out the SQL to do this. Can anybody tell me if I'm
 missing something?
 In this case 493 is the term_id of the product category.

 DELETE  term_relationships
 INNER JOIN term_taxonomy
 ON term_relationships.term_taxonomy_id = term_taxonomy.term_taxonomy_id
 AND term_taxonomy.term_id = 493

 UPDATE kry_term_taxonomy SET
 count = 0
 WHERE term_taxonomy.term_id = 493


 ANOTHER SOLUTION which may be easier for you guys to implement as it
 eliminates a lot of complexity and potential for serious bugs and user
 misunderstanding is to have a second icon/link column in the Product
 Category page, next to the "Count" column. When clicked it takes you to a
 completely new page that lists all the products in the category (not the
 page that you go to when you click "count").
 This new page has (at a minimum) a tickbox next to each product and two
 "Bulk Actions":
 1) Remove from category
 2) Add specified to category (you then have a dropdown with a list of
 categories at the top of the page)

 I think this is probably the technically easiest solution and covers all
 the bases, even if some bases require a little extra user effort.
 I think trying to do it through the bulk edit feature of the current
 product list page will be technically difficult for you guys and confusing
 for the user. The problem is how to indicate which categories are already
 allocated  to the set of products, and especially the categories which are
 only allocated to a subset of the products (greyed out tickbox). I think
 that many users won't know what the greyed out tickbox represents and may
 tick or untick it incorrectly and then you get a lot of angry people who
 unwittingly removed or added a bunch of products to categories that they
 didn't mean to.

 By creating the new page for products in a category you could even add an
 additional cool feature: you could use the term_relationships.term_order
 field to store the default order that the products should be displayed on
 the category page, and you could let the users specify the order by
 either:
 1) a single field on each product row that you save using ajax to
 term_relationships.term_order
 or
 2) a funky feature to drag each product row into the proper order. (Best
 is to have both methods so that if you have 100 products in a category and
 you want to move a few from the top to much lower down don't have to do
 lots of scrolling/dragging.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/11302#comment:25>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform