Snippet to clear customer IP address when order is sent. #woocommerce #wordpress

woocommerce-delete-customer-ip.php

<?php
/**
 * Snippet for deleting the customer IP address from WooCommerce orders.
 * Important for Trusted Shops® certificates in Germany.
 */
add_action( 'woocommerce_checkout_update_order_meta', 'mp1401091554', 1 );
function mp1401091554( $order_id ) {
	update_post_meta(
		$order_id,
		'_customer_ip_address',
		0
	);
}

It is probably easier to just run an SQL query if it's a one-time thing:

DELETE FROM wp_postmeta WHERE meta_key = '_customer_ip_address'

Hi @tommyshellberg, I've tried to use your SQL query but unfortunately still didn't know how to remove already stored ip adresses. I've used the php code stated in the beginning of this conversation to remove the ip adresses of future customers and it worked. But I still would need to figure out how to remove the ip adresses of already existing customers. I'd be very grateful if someone could help me out!