Stripe Payment Methods v Stripe Sources

Hi,

As a starting point, I’d recommend this discussion in Stackoverflow: Stripe: Whats the different between Source vs. Card vs. Bank vs Payment Method?

For a concept about a payment token, please check: What Is a Payment Token WooCommerce?

Regarding the database, you can see what is stored into the wooCommerce_payment_tokens table here:

https://github.com/woocommerce/woocommerce/wiki/Database-Description#table-woocommerce_payment_tokens

I was checking into my testing site database, running a SQL sentence (A select) from that table will look like this:

I found an article on the web related to export Payment methods used in the orders into a CSV, to get more information please check here (In Spanish).

Let us know if there are any questions.

Thanks for the reply – it looks like it’s a stripe source that is stored in woocommerce_payment_tokens based on the prefix of src_ instead of a payment method which is unfortunate.

Hi,

Thank you for your message.

Regarding exporting customer payment data, please note that only a small part of this information is stored in your site database. For example, the payment method data is saved by the payment gateway (Not WooCommerce) they process the transaction for the payment to go through. The Payment gateway provides a token to the site informing if the transaction processed properly.

Just in case you want to export the basic data saved in the store from the profile, you can use the core WordPress exporter to gather all customer data:

• How to Easily Import and Export WordPress Users

I hope this provides clarity.