How can I clean up the database after changing my Stripe account?

In order to properly link local data to the data in Stripe’s systems, our Stripe extension stores various identifiers (for customers, cards, and so on) in your database. However, that data is specific to a single Stripe account.

For that reason, if you’re replacing a previous Stripe account with a new one, a database cleanup may be required. If you do not perform this cleanup, purchases could fail.

Before proceeding with the cleanup, however, please contact Stripe to check whether the existing data can be transferred over to your new account. If it can, this procedure may not be necessary.

This is an example SQL query you might run on a single site installation of WordPress. Replace the wp_ value with your site’s database table prefix.

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';

This is an example SQL query you might run on a single site installation of WordPress. Replace the wp_ value with your site’s database table prefix.

This is an example SQL query you might run on a multisite installation of WordPress. Replace wp_999_ with the site prefix (or wp_ if cleaning up the database for the main site of the network, as it does not use a number in the prefix).

DELETE FROM 
  `wp_usermeta` 
WHERE 
  meta_key IN (
    '_stripe_customer_id', '_stripe_source_id', 
    '_stripe_card_id', 'wp_999__stripe_customer_id'
  );
DELETE tokenmeta 
FROM 
  `wp_999_woocommerce_payment_tokenmeta` tokenmeta 
  INNER JOIN `wp_999_woocommerce_payment_tokens` ON `wp_999_woocommerce_payment_tokens`.`token_id` = tokenmeta.`payment_token_id` 
WHERE 
  `wp_999_woocommerce_payment_tokens`.`gateway_id` = 'stripe';
DELETE FROM 
  `wp_999_woocommerce_payment_tokens` 
WHERE 
  gateway_id = 'stripe';