Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Stripe Subscription Item History

Answered
Teddy Ruby User

Hi! We are trying to create historical MRR records and it feels like the subscription item table is necessary to recreate full historical records from subscriptions with more than one product. 

If there is a single product in a subscription then the quantity of the product is stored in the subscription. I can then use the subscription history table to reconstruct the quantity of the product over time to get my MRR figure.

But if there are multiple products in a subscription the quantity field is null. This means I have to use the subscription item table to get the quantity but because that is not a historical table I can't track the quantity over time. Is there another way to track the quantity of a product over time for a subscription with multiple products? If not it feels like historical subscriptions are fairly incomplete without historical subscription items as well. 

Thanks!

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Elan User

    Hey Teddy, thanks for reaching out about this and we are glad you are using our Stripe connector. After looking at our internal Stripe account, we did notice that we were receiving records where the quantity field was greater than 1 (aka, meaning multiple products in the subscription). This means that it may be a unique behavior to receive null quantity values for your account. 

    Because of this, it may be easier to open up a support ticket so we can request source access to see if this complication is caused by the source or Fivetran. Let me know once you are able to open up the ticket and I can prioritize it with our team!