afonso | Stripe Developers | Page 1

carmine sorrelBOT May 30, 2023, 5:01 AM

#

bronze bramble May 30, 2023, 5:01 AM

#

Hi there, what do you mean by get all the money that I got from a certain product ?

gaunt island May 30, 2023, 5:01 AM

#

All time earnings for a particular product id.

#

Dashboard only shows MRR.

#

I want all-time revenue.

#

Excluding of course refunds.

#

I just want net revenue of a product.

bronze bramble May 30, 2023, 5:03 AM

#

Are you using Checkout sessions?

gaunt island May 30, 2023, 5:05 AM

#

yes

bronze bramble May 30, 2023, 5:08 AM

#

OK, then you can use the List Checkout Sessions API (https://stripe.com/docs/api/checkout/sessions/list#list_checkout_sessions) to get the list of checkout sessions and filter them out based on your criteria. Remember to expand 'data.line_items' field so that you can get the product info from the line_items

Stripe API reference – List all Checkout Sessions – curl

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

gaunt island May 30, 2023, 5:10 AM

#

this feels so indirect

#

isn't there a more direct way?

#

how does stripe itself get the MRR for a product?

#

because on the dashboard it shows mrr

bronze bramble May 30, 2023, 5:12 AM

#

I can only help with Stripe API related questions. and I don't have details on how Stripe Dashboard is implemented.

gaunt island May 30, 2023, 5:17 AM

#

isn't there a way to do like that with the charges?

#

i think the charges are a more true reflection no?

bronze bramble May 30, 2023, 5:18 AM

#

A charge object doesn't carry information of products

gaunt island May 30, 2023, 5:19 AM

#

damn

#

so i basically need to go checkout sessions and check if the product is on line items

#

but with the checkout it doesnt have in account the subscriptions

#

why is this so difficult?

#

just want total net revenue for 1 product

#

and then we need to remove the stripe tax as well

#

damn this is trouble, don't you have easier way?

#afonso