Skip to content

Instantly share code, notes, and snippets.

@michaelbragg
Last active December 8, 2021 19:41
Show Gist options
  • Save michaelbragg/68a33edccb1f0d5660fe530c3515fee0 to your computer and use it in GitHub Desktop.
Save michaelbragg/68a33edccb1f0d5660fe530c3515fee0 to your computer and use it in GitHub Desktop.
Empty a WooCommerce database of Orders and Customers
# Delete orders.
wp post delete $(wp post list --post_type='shop_order' --post_status=trash --format=ids --force) --force
wp post delete $(wp post list --post_type='shop_order' --post_status=wc-failed --format=ids --force) --force
wp post delete $(wp post list --post_type='shop_order' --post_status=wc-cancelled --format=ids --force) --force
wp post delete $(wp post list --post_type='shop_order' --post_status=wc-refunded --format=ids --force) --force
wp post delete $(wp post list --post_type='shop_order' --post_status=wc-processing --format=ids --force) --force
wp post delete $(wp post list --post_type='shop_order' --post_status=wc-completed --format=ids --force) --force
# Delete users.
wp user delete $(wp user list --role=subscriber --field=ID --format=ids) --reassign=1
wp user delete $(wp user list --role=contributor --field=ID --format=ids) --reassign=1
wp user delete $(wp user list --role=author --field=ID --format=ids) --reassign=1
wp user delete $(wp user list --role=customer --field=ID --format=ids) --reassign=1
wp user delete $(wp user list --role=shop_manager --field=ID --format=ids) --reassign=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment