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'
...
4
votes
Accepted
importing entry status via CSV - does uppercase or lowercase status matter
While firing a query in DB, No matter you pass "Open" or "open". Both are same.
Your first question's answer is: As per EE Standards, It should be "open".
EE save "open/closed" in database, it shows ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
status × 73channel-entries × 12
safecracker × 12
categories × 7
cartthrob × 4
entries × 4
expresso-store × 3
ee3 × 3
entry × 3
groups × 3
bulk × 3
ee2 × 2
matrix × 2
members × 2
playa × 2
add-on × 2
relationships × 2
channel × 2
error × 2
email × 2
zoo-visitor × 2
hook × 2
payment-gateway × 2
notification × 2
orderby × 2