wp-cli.md

WP CLI

Update meta for a CPT.

wp post list --post_type=<cpt-name> --field=ID | xargs -I % wp post meta update % _yoast_wpseo_meta-robots-nofollow 1

List active themes in multisite.

wp site list --field=url | xargs -I % bash -c "echo 'URL:' % && wp theme list --url=% --status=active"

Delete a term across all sites in the network.

wp site list --field=url | xargs -I % bash -c "echo 'URL:' % && wp term delete category <category-slug> --by=slug --url=%"

Update option across all sites in the network.

wp site list --field=url | xargs -I % bash -c "echo 'URL:' % && wp option update test_key test_value --url=%"

Flush rewrite rules for all sites in the network.

wp site list --field=url | xargs -I % bash -c "echo 'URL:' % && wp rewrite flush --url=%"

CLI command to force the save_post hook to run on all published posts:

wp post list --field=ID --post_type=post --post_status=publish | xargs -I % wp post update % --post_status=publish

List all taxonomies for a post.

wp taxonomy list --fields=name | xargs -I % wp post term list <Post ID> %

Recount all taxonomies.

wp taxonomy list --field=name | xargs wp term recount

Assign a term to all posts in a post type.

wp post list --post_type=post --fields=ID | xargs -I % wp post term set % category "daily-briefing"

Swap category to a custom taxonomy term and remove the original category on the post.

wp post list --field=ID --category=<category slug> | xargs -I % bash -c "wp post term add % <taxonomy> <term slug> --by=slug && wp post term remove % <taxonomy> <term slug>"

Copy parent post ID into a meta field.

wp post list --field=ID | xargs -I % bash -c "wp post meta update % <meta field> $(wp post get % --field=post_parent)"

Update post meta

for postID in $(wp post list --post_type=sfwd-topic --field=ID); do wp post meta update "$postID" sort_date '$(wp post get "$postID" --field=post_date_gmt)'; echo "$postID"; done;

Run command on all posts depending on meta key.

wp post list --field=ID --meta_key=<meta key> '--meta_compare=NOT EXISTS' | xargs -I % wp example transform run --post_id=%

Get around locked tables

wp db export --single-transaction

Set a user to the same role across all sites on a multisite network.

wp site list --field=url | xargs -I % wp user set-role <user ID> <role> --url=%

Update meta on posts depending on post type.

for postID in $(wp post list --post_type=page --field=ID); do wp post meta update $postID sort_date "$(wp post get $postID --field=post_date)"; echo "$postID"; done;

Reindex only public sites.

for url in $(wp site list --field=url --archived=0 --deleted=0 --public=1); do echo "Indexing site: $url" && wp elasticpress sync --per-page=100 --url=$url --force --quiet --yes; done

or

for url in $(wp site list --field=url --archived=0 --deleted=0 --public=1); do echo "Indexing site: $url"; yes "y" | wp elasticpress sync --per-page=100 --url=$url --force --quiet --yes; done

Backup database

• https://gist.github.com/lukecav/f333618818b2be33bb8ff96a0d90faac

wp db export --all-tablespaces --single-transaction --quick --lock-tables=false - | gzip -9 - > wordpress-dump.sql.gz

List all site URLs in a multisite network

WP_CLI_PATH="./wp-cli.phar" && WP_ROOT_PATH="./wp/." && for url in $(${WP_CLI_PATH} site list --path="${WP_ROOT_PATH}" --field=url 2>/dev/null); do bash -c "${WP_CLI_PATH} option get siteurl --path="${WP_ROOT_PATH}"  --url="${url}" 2>/dev/null"; done;

WP_CLI_PATH="./wp-cli.phar" && \
WP_ROOT_PATH="./wp/." && \
for url in $(${WP_CLI_PATH} site list --path="${WP_ROOT_PATH}" --field=url 2>/dev/null); do bash -c "${WP_CLI_PATH} option get siteurl --path="${WP_ROOT_PATH}"  --url="${url}" 2>/dev/null"; done;

WP_CLI_PATH="./wp-cli.phar" && WP_ROOT_PATH="./wp/." && for url in $(${WP_CLI_PATH} site list --path="${WP_ROOT_PATH}" --field=url 2>/dev/null); do bash -c "${WP_CLI_PATH} elasticpress sync --quiet --per-page=50 --path="${WP_ROOT_PATH}"  --url="${url}" 2>/dev/null"; done;

Create super admin

./wp-cli.phar --path=./wp/. user create <username> <email> --user_pass=<password> --role=administrator --porcelain | xargs -I {} bash -c "./wp-cli.phar --path=./wp/. super-admin add {}"

Check for updates

wp plugin list | \
 awk 'BEGIN{N=0;} \
  ($3=="available"){N++; print $0;} \
  END{print(N>0)?"Plugin updates available: "N:"No plugin updates available";}'

Purge cache on all sites

wp site list --field=url | xargs -I % bash -c "echo 'URL:' % && wp rewrite flush --url=% && wp cache flush --url=% && wp transient delete --all --url=% && wp beaver clearcache --url=%"