Laravel 11 Cashier (Stripe) - How to check for new subscriptions / re-subscriptions

In Laravel 11 when using the Cashier for Stripe, I need to get a total number of subscriptions that were created 1 day ago, divided into two groups:

Users who never had any subscription, but subscribed now
Users who had a subscription in the past, but re-subscribed

This should count with people who only might have been on a trial / never completed a payment for their first subscription that might be stored in a database.

vincent15000

1 year ago

Level 63

IMHO you need to keep a history of the previous subscriptions.

Then it's easy to filter the subscriptions by date, having both the new subscriptions and the new re-subscriptions.

And a user who has more than one subscription has necessarily re-subscribed.

newbie111

1 year ago

Level 1

@vincent15000 I do, but is it that simple? What if user had before tried to subscribed, but never finished the payment. Then he will have a subscription row with incomplete_expired / incomplete status no? And what about other situations

1 like

vincent15000

1 year ago

Level 63

@newbie111 Sure you have to count only the complete subscriptions.

martinbean

1 year ago

Level 80

@newbie111 What have you tried so far?

1 like

Please or to participate in this conversation.