Tzuyu-subscription-export | Stripe Developers | Page 1

tropic obsidian Nov 10, 2021, 1:54 PM

#

Hi there 👋 can you elaborate a bit on what you're looking for assistance with?

umbral plank Nov 10, 2021, 2:15 PM

#

I would like to know what causes the data inconsistency between the payment and subscription export

tropic obsidian Nov 10, 2021, 2:17 PM

#

Do you have an example subscription ID that we could take a look at?

umbral plank Nov 10, 2021, 2:36 PM

#

i have his customer id : cus_KVE5hHWgEsXZcz

#

invoice id : in_1JqDdKL1Vxy4ELqOwLuHFctu

tropic obsidian Nov 10, 2021, 2:40 PM

#

Thanks, digging in a bit.

#

Can you specify what fields within the subscription export you're referring to? And are these values inconsistent or missing?

umbral plank Nov 10, 2021, 3:10 PM

#

I've tried to do a lookupv between two exports and I can't find certains clients with their customer_id

#

I've tried to have the "Product", "Plans" and "Interval"

compact kite Nov 10, 2021, 3:19 PM

#

Where are you trying to look up the customers by ID that they are not showing up?

umbral plank Nov 10, 2021, 3:42 PM

#

from an export of subscription

compact kite Nov 10, 2021, 3:49 PM

#

So cus_KVE5hHWgEsXZcz was in what column of that export? And where is the second place you are looking for where you are running in to an issue?

umbral plank Nov 10, 2021, 3:56 PM

#

I can find this client in the export of payement but not in subscription

compact kite Nov 10, 2021, 4:02 PM

#

I am taking a look at those sheets but we try to keep real data like that off of the server.

#

Because it is public anyone can grab anything here

umbral plank Nov 10, 2021, 4:03 PM

#

okay thank you! I did not pay attention to that

compact kite Nov 10, 2021, 4:07 PM

#

It looks like that customer's subscription was cancelled before there were any payments in November

umbral plank Nov 10, 2021, 4:14 PM

#

so how can I do an export to know the product and plan that clients get for each payment ?

#

if it doesn't work in this case

compact kite Nov 10, 2021, 4:19 PM

#

So basically you are trying to line up which invoices from the invoice export line up with which subscriptions from the subscription export?

#

I don't think the invoice export can have rows for product and plan but you can export a subscription column which would allow you to match it up based on the subscription ID

umbral plank Nov 10, 2021, 4:25 PM

#

I feel that the subsciption id change for the same offer all the time so I can't do a table for vlookup

compact kite Nov 10, 2021, 4:26 PM

#

A Subscription ID will stay the same for the lifetime of the subscription

umbral plank Nov 10, 2021, 4:28 PM

#

for example, the weekly plan with different coupon, there are different subscription ID ?

#

these clients have the same subscription, same product and same promo coupon, however they don't have the same subscription ID

#

compact kite Nov 10, 2021, 4:34 PM

#

One customer can have multiple subscriptions

#

Those could be simultaneous subscriptions or it is possible that a subscription was cancelled and then another one was started

umbral plank Nov 10, 2021, 4:39 PM

#

but these are subscriptions for different clients

#

that's why I feel that the subsciption ID changes all the time

compact kite Nov 10, 2021, 4:40 PM

#

Oh sorry I see

#

Yes, that is expected. Subscriptions are their own objects that charge based on plan and whatnot

#

Let's take a step back: what is your end goal here?

#

What information are you trying to get from these two sheets?

umbral plank Nov 10, 2021, 4:43 PM

#

I want to have these informations for all payments : date / new or renew subscription / plans / product / duration / amount / coupon

compact kite Nov 10, 2021, 4:54 PM

#

Okay so the subscription ID will help you here. The Payment does not have the information on the Subscription's plan and product. So you can look up the ID from the invoices sheet in the subscriptions sheet and see what that specific subscription's product and plan is

umbral plank Nov 10, 2021, 4:58 PM

#

but I don't have product and plan in the invoice sheet

#

and i have to analyse the data of the year

#

so I can't not look up one by one on the website

compact kite Nov 10, 2021, 5:04 PM

#

Right. The invoice sheet does not have that data. The subscription sheet does. If you want to do this entirely with sheets, you can export the invoice sheet while including the Subscription column and use that subscription ID to see what the Subscription's product and plan are in the subscription sheet

umbral plank Nov 10, 2021, 5:09 PM

#

That's what I did. But it doesn't work for some who cancels their subscription

#

there is no information for them in subscription sheet

still gate Nov 10, 2021, 5:10 PM

#

How have you created this export?

umbral plank Nov 10, 2021, 5:11 PM

#

Payment > subscription > exporter

#

I don't know if it's configured by our developers or it's by default

still gate Nov 10, 2021, 5:12 PM

#

This is someting you pulled from our Dashboard right?

umbral plank Nov 10, 2021, 5:13 PM

#

Yes

still gate Nov 10, 2021, 5:14 PM

#

I'm guessing that the Dashboard only exports the subscriptions for the specific "tab" you're on. So for example, when you go to Payment -> Subscription you're on the "Current" tab. When you click export you'd only see the current subscriptions. You can export all your cancelled subscriptions separately by switching to the correct tab and exporting that as well

umbral plank Nov 10, 2021, 5:15 PM

#

Okay thank you ! I think that will help !

#

I'll come back to you if needed 🙂

#Tzuyu-subscription-export