7
votes
Accepted
Mass-change entries from one status to another
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'
...
1
vote
What is the best way to delete every entry in a channel?
To delete all channel items but keep the channel itself (e.g. channel id may be hardcoded in some custom code or whatever), do from the admin panel:
The usual way is to select items page by page, ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
bulk × 11status × 3
channel-entries × 2
categories × 1
matrix × 1
pixelandtonic × 1
ee3 × 1
structure × 1
forms × 1
email × 1
entries × 1
ee1 × 1
postmaster × 1
import × 1
update × 1
checkout × 1
shopping-cart × 1
sql × 1
delete × 1
entry-date × 1
mailinglist × 1
moderation × 1
batch-update × 1