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
• Cleaning Woocommerce trash products
• Cleaning unattached jpegs from the WordPress library
• Creating Dummy content
• 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

Cleaning Woocommerce trash products

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

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.

# !/bin/bash

# Fetch all IDs in one command and store them in an array

ids=($(wp db query "SELECT ID FROM wp90_posts WHERE post_type='attachment' AND post_parent=0 AND post_mime_type='image/jpeg'" --silent --skip-column-names))

# Function to delete posts in batches

delete_in_batches() {
    local batch=("$@")
    if ! wp post delete --force "${batch[@]}"; then
        echo "Error: Failed to delete one or more posts in this batch."
        exit 1
    fi
}

# Batch size

batch_size=500

# Total number of IDs

total_ids=${#ids[@]}

# Process IDs in batches of 500

for ((i=0; i<total_ids; i+=batch_size)); do
    batch=("${ids[@]:i:batch_size}")
    echo "Deleting batch starting with ID ${batch[0]}"
    delete_in_batches "${batch[@]}"
done

echo "Deletion process completed."

Using scripts/batch-delete-unattached-jpegs.sh it is nearly 1.5x faster than the previous command. Don't forget to make the script executable by running chmod +x scripts/batch-delete-unattached-jpegs.sh.

Creating Dummy content

wp post generate --count=10

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