SQL query generator for WordPress and WooCommerce

Generate common SQL queries for your WordPress and WooCommerce database.
⚠ Make a FULL BACKUP before running any query.

Table prefix (*) Your WordPress table prefix (default is usually wp_)

Database type

Query type

Find and replace

Text to find Replace with

Change domain

Old domain New domain

Reset passwords

New password (*) ⚠ This will change the password for ALL users

Change admin email

New email (*)

Update prices by percentage

Price type Percentage change Use a positive number to increase, negative to decrease. Example: 10 = +10%, -15 = -15%

Update prices by fixed amount

Price type Operation Amount Fixed amount to add or subtract in your store currency

Update prices by category

Category slug The product category slug (e.g.: clothing, electronics) Percentage change Positive number to increase, negative to decrease

Change order statuses

Current status New status

Clean abandoned carts

Days old Delete abandoned carts older than X days

Bulk update stock

Operation Amount Amount to add or subtract from current stock

Custom query

Your SQL query

Enable/Disable comments

Action Applies to all existing posts and sets the default for new posts

Enable/Disable product reviews

Action Applies to all existing products and updates the global WooCommerce setting

Generated query

-- The generated query will appear here