Exporting data

[richardchui]

Hi,

Is there any way to export the data maintained by the plugin (e.g. orders, coupon, etc)? We would like to do some analysis of the data.

I have looked at the WordPress DB and could not find the where the plugin is maintaining its data.

One more question about the Subscription Addon. The plugin will create a subscription plan in Strip to do the recurring payment, and no credit card information will be kept by the site. Is that correct?

Thank you very much!

[alexanderfoxc]

Is there any way to export the data maintained by the plugin (e.g. orders, coupon, etc)? We would like to do some analysis of the data.

The plugin has no built-in data export functionality at the moment. But if you can describe your use-case scenario with a bit more details, perhaps we could find a way to either implement it in the plugin or to figure out some workaround.

You can also get the info from your Stripe account, it supports exporting of various data into CSV format. This is the reason why we don’t have our own data export since Stripe’s covers most of the needs.

and no credit card information will be kept by the site. Is that correct?

The plugin does not store any credit card info at all as this is PCI DSS compliance requirement. All the crucial info is processed and handled by Stripe on your behalf. Even the fields where your customers enter CC details are not controlled by the plugin, but the Stripe itself, so there is no way for the plugin (or its addons) to access those.

[richardchui]

> if you can describe your use-case scenario with a bit more details, perhaps we could find a way to either implement it in the plugin or to figure out some workaround.

Specifically, we want to find out in which orders the coupons are being used. I know that this information can be found in the order details, but just want to see if there is a faster and easier way to do that.

Thanks!

[alexanderfoxc]

The plugin adds metadata to Stripe when coupon is being used during a purchase. Product ID is also stored there. So you can export the data from Stripe (make sure the metadata is included when you configure export settings) and then analyze it as you prefer.

[richardchui]

Thanks for the tips.

I just tried exporting the payments from Stripe (all columns). Yes, Product ID is there, which is great. But I don’t see any reference to the coupon used.

[alexanderfoxc]

Just tried it myself and indeed, no coupon code is saved in Stripe metadata.

I’ve created an issue for this so the team could review and fix it.

[richardchui]

Thank you Alex for the excellent help.

[alexanderfoxc]

This has been fixed in new testing version (2.0.28t2). https://s-plugins.com/testing-version/

Thank you for reporting this.

[richardchui]

Installed the testing version and made a payment. Seems metadata still only has Product ID.

[alexanderfoxc]

This is fixed in current stable version 2.0.28.

Please update it via standard WP means (WP Admin -> Dashboard -> Updates).

[Author]

Posts