a.sheliutsin

[steady stump]

Hey, just checking in with a colleague on this

Can you elaborate on how you're processing payments with Stripe? Are these recurring/subscription payments? Is it via Checkout, or Payment Intents directly?

[wintry gazelle]

I am not sure about that. As I see, there are some recurring invoices, but for old products we had direct payment intents

[coral fiber]

when you say 'per product' what does that mean? Like per Stripe Product(Billing/Invoicing/Connect), or per a prod_xxx Product object, or something else?

[wintry gazelle]

per a prod_xxx

[coral fiber]

well I don't know anything about Sigma but in the API you can for example list all invoices (https://stripe.com/docs/api/invoices/list) and then in your code look into each invoice.lines.data.price.product to get the Product for each line item in each Product. I'm sure we have better options but unfortuantely we don't know much about Stripe's reporting tools in this channel

[wintry gazelle]

Thank you for your help. Unfortunately, as I see from data not all of our charges have invoices. I believe I cannot map everything to it. Where can I refer to?

To find the better option

[coral fiber]

if the charge doesn't have an invoice or something higher level like a CheckoutSession, and was just manually created via e.g. the /v1/payment_intents API directly then it's not associated with a prod_xxxx

[wintry gazelle]

Hm, for some reason I see that there is a charge with no invoice but associated with item

[coral fiber]

what does "associated with item" mean?

[wintry gazelle]

I open payment in web ui (link like https://dashboard.stripe.com/payments/pi_XXX ) and in the Checkout summary section there is ITEMS subsection with the product and the link to it (link like https://dashboard.stripe.com/products/prod_XXXX)

[coral fiber]

then it's associated with a CheckoutSession

[coral fiber]

if the charge doesn't have an invoice or something higher level like a CheckoutSession

the recon is harder there