CODEWITHSUNDEEP
phpapireportstripe-payments
Stephen Watkins
Stephen Watkins

Reputation: 25765

Creating a Stripe Summary Report

I've recently switched payment processing to Stripe. I now need to create a report for our finance department that shows a rollup of transactions within a specified date range. I've started to create a simple PHP web page (and using the Stripe PHP library) that will give the following summaries:

I'm having some trouble figuring out how to properly query charges with Stripe for my reporting purposes.

I know I can retrieve charges with: 

$charges = Stripe_Charge::all();

And from the returned set of charges, I can compute the summary information that I need in the report. However, this will only return me a maximum of 100 charges, and I don't know how to return the charges within a specified date range.

I'm hoping more experienced Stripe developers can point me to the correct method of building the report I need.

How can I return all charges within a specified date range?

Is there a better way to get this summary information from Stripe?

Upvotes: 8

Views: 4665

Answers (5)

Amos
Amos

Reputation: 161

Realize this is old-ish, but.. this is now possible, a php example:

$charges=Stripe_Charge::all(array("created" => array("gt" => $unix_time),"limit" => 100));

Upvotes: 0

PHP Ferrari
PHP Ferrari

Reputation: 15616

You can use offset like

$return = Stripe_Charge::all(array("count" => 100, 'offset' => 0)); // set count
$return = Stripe_Charge::all(array("count" => 100, 'offset' => 100));   // set count
$return = Stripe_Charge::all(array("count" => 100, 'offset' => 200));   // set count

Upvotes: -1

Stephen Watkins
Stephen Watkins

Reputation: 25765

I received confirmation from a Stripe employee that the only two options are in fact the ones described in the answers from @dwhalen and @Saikat Chakrabarti.

Quoting from the Stripe employee to the same question I asked on Stripe:

Other than the options you described (retrieving all charges, or tracking in your database as charges come in) there isn't any alternative way of producing the stats that you want there.

Upvotes: 0

dwhalen
dwhalen

Reputation: 1925

You could use webhooks to be notified when a charge.succeeded or charge.refunded event occurs and store the relevant information in a database you control. That will give you flexibility to do the reporting you need. You can download charges that have already occurred as a CSV from the Stripe dashboard.

Upvotes: 3

Saikat Chakrabarti
Saikat Chakrabarti

Reputation: 311

You can paginate through the charges by using the count and offset parameters (documented at https://stripe.com/docs/api?lang=php#list_charges). I would suggest using these to process 100 charges at a time. Then you can stop iterating through your charges once you get a charge beyond your date range.

Upvotes: 1

Related Questions