It would be very useful to also get something like "Stripe Customer Unsubscribed" events too perhaps if that would be possible as part of this plugin?

We should be able to support capturing historical paid invoices.

How this would work:

1. Allow users to set a backfill date in config

2. When calculating Paid Invoices, query all invoices starting with backfill date – send backdated events to PostHog with the amount paid per month

This should give users a pretty good view of all income month over month

Planning on rebuilding this plugin as it currently times out and doesn't work well.

Current usage of this plugin

• No-one on cloud
• No recent usage on self hosted

What we want out of this

• person/group properties
  • What plan and product they're on
  • Current status (paid/cancelled)
  • How much they spent in the last month
  • How much they spent cumulatively
  • How much they paid cumulatively
  • When they subscribed
• Events
  • Subscribed
  • invoice paid
  • cancelled

How to identify stripe customers with posthog persons

1. metadata on the Stripe Customer: posthog_distinct_id
2. email on the stripe customer
3. stripe customer_id

How it works:

every 10 minute, get 100 new invoices (paginate until we find new ones, from storage)

• if customer doesn't exist
  • call api/person and grab user by email to get distinct_id. WARN if > 1 result or 0 results
  • if group_type_id is set, also call groups/related to find related groups
  • send subscribed invoice
  • store distinct_id mapping into storage
• grab customer from storage, increment "total_spend" amount and update dict with dates and amounts
• send invoice paid event, with $set for all properties
• (if group_type_id is set) send $groupidentify event
• set invoice id in storage

• Better testing
• Filter relevant information better
• Check a hash of the customer data before sending event to update it
• Support a daily MRR event
• Support more of Stripe's endpoints

1. Stripe errors seem to occur when sending the subscription event

2. Some fields don't seem to be mapped properly

Getting Could not load source code for plugin Stripe Plugin ID ### (organization ID ####- global). Tried: index.ts, index.js after enabling the plugin

In our case the billable entity is an "organization" as such we would want to associate f.e. the turnover generated with the organization and not (only) the person, even though stripe of course associates turnover to a person.

On our "organization" group type we store the person ID of the "owner" and of course the person is also associated with the "organization" via group identify.

What I guess I would like to see added is the ability to specify a group type and then relevant properties would also be added there. what I am unsure about is how to best handle cases where the "owner" changes. in that case it should ideall sum up f.e. the turnover from the previous and the current owner on the "organization".

Sentry issue: https://sentry.io/organizations/posthog2/issues/3509277428/?query=is%3Aunresolved+level%3Aerror

The groups API query is failing since the relevant id passed forward is undefined. cc @timgl