We cannot bulk-edit entries via the CP, and I need to make a change in my workflow. In one channel, I need to mass-change all entries whose current status is OPEN to CREATED, if the entry-date is before a certain date.

I'm fairly sure that this is possible with SQL (Developer Tools > SQL Manager > Query Form), but...I don't know SQL. I think this question covers SOME of it (how to change entry statuses), but not all of it (only in a certain channel, only before a certain entry date): Bulk entry status change



SQL is the best option to bulk update the entries. But you must need to be careful as wrong execution can stress you up!

You can use below query:

UPDATE exp_channel_titles 
SET status = 'created' 
WHERE status = 'open' 
AND channel_id = '1' 
AND entry_date <= '1262332799'

Replace the date value with UNIX timestamps of the date and channel_id you want use.

  • 1
    Thanks! I'll make a backup of the database before running this query...ju-u-ust in case :) (A new version of EE just came out, so I also have to upgrade. I'll do that after I run this query.) Thanks again for the exact syntax!
    – LiAnn
    Mar 4 '17 at 2:14
  • 2
    EE 3 still doesn't allow bulk updates from the CP like EE2 did. I believe it's on the feature request list to be added back in. Hopefully EL will accommodate us users.
    – Jeremy
    Mar 6 '17 at 20:07
  • Yes @Jeremy - that's true. (At least it is up through EE3.5.2, I haven't upgraded to 3.5.3 yet.) I've posted in threads in the official forums that I'd like the more granular search, AND the bulk edit. Both of those were nice features to have in the CP...don't know why they removed them!
    – LiAnn
    Mar 7 '17 at 2:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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