Awesome WordPress Cli Commands

I often reference this list of useful WordPress CLI commands to enhance or clean up my sites. Please be careful and make backups.

How to install WordPress CLI. Here you can checkout the commands.

List:

• Syncing High-Performance Order Storage
• Recovering WordPress after a fatal error from plugin update
• Cleaning Woocommerce trash products
• WordPress Hacking cleanup
• Cleaning unattached jpegs from the WordPress library
• Creating Dummy content
• Deleting spam comments
• Truly stopping comments
• Cleaning your website
• Checking the config file
• Checking the database size
• Running core update
• Plugins manipulation
• Reseting User Password
• Database Manipulations

Syncing High-Performance Order Storage

wp wc cot sync

Recovering WordPress after a fatal error from plugin update

wp plugin deactivate plugin-says-no --skip-plugins

Cleaning Woocommerce trash products

wp post delete $(wp post list --post_type=product --post_status=trash --format=ids) --force

WordPress hacking cleanup

The following commands will remove any files that may have been created by a hacker. It will also remove any PHP files that are not part of the WordPress core. This is a very dangerous command and should be used with caution. It isn't a 100% guarantee that it will remove all the files that a hacker may have created, but it will remove most of them.

1. Download the script from the repository - /scripts/wp-hacking-cleanup.sh
2. chmod +x scripts/wp-hacking-cleanup.sh
3. ./scripts/wp-hacking-cleanup.sh

Cleaning unattached jpegs from the WordPress library

for id in $(wp db query "SELECT ID FROM wp_posts where post_type='attachment' AND post_parent=0 AND post_mime_type='image/jpeg'" --silent --skip-column-names)
do
    wp post delete --force $id
done

Cleaning unattached jpegs from the WordPress library in batches. You can change the batch size by changing the value of the batch_size variable.

1. Download the script from the repository - /scripts/batch-delete-unattached-jpegs.sh
2. chmod +x scripts/batch-delete-unattached-jpegs.sh
3. ./scripts/batch-delete-unattached-jpegs.sh

Creating Dummy content

wp post generate --count=10

Deleting spam comments

wp comment list --status=spam --format=ids | xargs wp comment delete --force

Truly disabling/stopping comments

wp option update default_comment_status closed
wp option update default_ping_status closed
wp db query "UPDATE wp_posts SET comment_status='closed' WHERE post_status='publish';"
wp db query "UPDATE wp_posts SET ping_status='closed' WHERE post_status='publish';"

Cleaning your website

wp site empty

Checking the config file

wp config get

Checking the database size

wp db size --tables

Running core update

wp core update

Plugins manipulation

List

wp plugin list

Install

wp plugin install

Update

wp plugin update plugin-name

Disable

wp plugin deactivate plugin-name

Delete

wp plugin delete plugin-name

Reseting User Password

wp user update user@example.com --user_pass=new-password

Database Manipulations

Optimization

wp db optimize

Repair

wp db repair

Backup

wp db export name.sql