Skip to content

Instantly share code, notes, and snippets.

@lukecav

lukecav/Query

Created June 10, 2022 20:00
Show Gist options
  • Save lukecav/f7a4e7e19858ed6ffa2f4f4697119a0a to your computer and use it in GitHub Desktop.
Save lukecav/f7a4e7e19858ed6ffa2f4f4697119a0a to your computer and use it in GitHub Desktop.
Download ZIP
WooCommerce Stripe database cleanup
Raw
Query
DELETE FROM `wp_usermeta`
WHERE meta_key IN ( '_stripe_customer_id', '_stripe_source_id', '_stripe_card_id' );
DELETE tokenmeta FROM `wp_woocommerce_payment_tokenmeta` tokenmeta
INNER JOIN `wp_woocommerce_payment_tokens` ON `wp_woocommerce_payment_tokens`.`token_id` = tokenmeta.`payment_token_id`
WHERE `wp_woocommerce_payment_tokens`.`gateway_id` = 'stripe';
DELETE FROM `wp_woocommerce_payment_tokens` WHERE gateway_id='stripe';
@lukecav
Copy link
Author

lukecav commented Jun 10, 2022

https://woocommerce.com/document/stripe-fixing-customer-errors/#section-1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment