Usuário não consegue recomprar um produto de assinatura após cancelar

amalg · Agosto 6, 2021, 8:49pm

I’ve got an odd problem cropped up here with a subscriber.

They have no active subscriptions in under the Billing section;

In Stripe it shows as cancelled;

yet they cannot resubscribe… says already purchased;

Have I set something up incorrectly?

justin · Agosto 7, 2021, 4:50pm

That looks like you might have your webhook endpoint improperly configured. When the subscription period ends, Stripe sends a webhook which the plugin uses to remove group membership, and remove the user from being an existing customer on that product (which allows the user to purchase again).

You’ll need to make sure this is configured per the OP here: Discourse Subscriptions

One way you to confirm from your server:

./launcher enter app
rails c
u = User.find_by_username(<username>)
c = DiscourseSubscriptions::Customer.where(user_id: u.id)
subscription = DiscourseSubscriptions::Subscription.where(customer_id: c.customer_id)

Be sure to replace <username> with the actual username of the user.

If subscription returns [], there’s another issue going on. But if it returns a value, that likely confirms the missing webhook.

To delete the DiscourseSubscriptions::Subscription entry so the user can purchase the product again:

Make sure subscription has only one value by running subscription.count. If the value returned is greater than 1, you’ll have to do a bit more digging to make sure you’re deleting the correct subscription instance. If you delete the wrong one, your subscriptions data will be in an inconsistent state and likely yield weird behavior.

Once you’ve confirmed there’s only one subscription, then you can run:

subscription.destroy_all

Keep in mind that subscription is the value returned from the initial set of queries we ran in the Rails console.

Hope that helps!

amalg · Agosto 9, 2021, 9:21pm

Thanks @justin

• got to the last line subscription and ran it… returned this;

NoMethodError: undefined method customer_id' for #<DiscourseSubscriptions::Customer::ActiveRecord_Relation:0x000055be473772f0> from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.3.2/lib/active_record/relation/delegation.rb:110:in method_missing’

• Checked Stripe webhooks and it’s pointed to https://./s/hooks

• Events sent to webhook;

```
subscription_schedule.updated
```
```
subscription_schedule.expiring
```
```
subscription_schedule.created
```
```
subscription_schedule.canceled
```

• Stripe webhook log has one entry from setup date which looks to be establishing the events supported.

• I have an event entry in Stripe that is a cancellation of a subscription, but… the line entry says (effectively) “[subscription was canceled]” however when I click into the event, it says the event type is customer.subscription.deleted … which I notice is not listed in my webhooks event list.

Could the above be the problem?

justin · Agosto 9, 2021, 9:26pm

Looks like the line should be DiscourseSubscriptions::Subscription instead of ::Customer. Try that and see what you get!

amalg · Agosto 9, 2021, 9:42pm

[2] pry(main)> c = DiscourseSubscriptions::Subscription.where(user_id: u.id)
=> #DiscourseSubscriptions::Subscription::ActiveRecord_Relation:0x8020
[3] pry(main)> subscription = DiscourseSubscriptions::Subscription.where(customer_id: c.customer_id)
NoMethodError: undefined method customer_id' for #<DiscourseSubscriptions::Subscription::ActiveRecord_Relation:0x000055ec51164ca0> from /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.3.2/lib/active_record/relation/delegation.rb:110:in method_missing’

justin · Agosto 9, 2021, 9:45pm

Sorry, I misunderstood where this was happening.

Try this instead:

./launcher enter app
rails c
u = User.find_by_username(<username>)
c = DiscourseSubscriptions::Customer.find_by(user_id: u.id)
subscription = DiscourseSubscriptions::Subscription.where(customer_id: c[:customer_id])

amalg · Agosto 9, 2021, 10:10pm

Ah…

[3] pry(main)> subscription = DiscourseSubscriptions::Subscription.where(customer_id: c[:customer_id])
=>

amalg · Agosto 11, 2021, 6:41pm

Do you think the lack of subscription data has anything to do with the customer.subscription.deleted event being missing?

Is there anything I should explore next at this point?

I’m particularly interested in focusing on why the subscription page shows “purchased” while the active subscriptions section shows no active subs… is there some other place in the database where sub info is stored which might be cleared / empty under the active subs section but somehow a “purchased” boolean is still set to true somewhere … or something like that?

amalg · Agosto 23, 2021, 5:25pm

Is there anything else to try here?

justin · Agosto 24, 2021, 4:42pm

Make sure in Stripe the purchase is fully cancelled and not waiting to be cancelled at the end of the period. You can also look under the Admin → Plugins → Discourse Subscriptions → Subscriptions area and look for this user’s username. If they have a subscription listed there, you can cancel it immediately.

Without further looking into your Discourse instance, I’m not sure how much further I can help.

amalg · Agosto 24, 2021, 8:51pm

yeah it’s not active under subscriptions in the plugin area, and also not on stripe either… the only thing that indicates anything is still active is if the user goes to the subscription page, they see a little green “purchased” checkmark and “go to billing”.

If I go to billing as the user in question, nothing;

So my question is - what in the database triggers that green checkmark and can it be cleared?

justin · Agosto 24, 2021, 10:46pm

github.com

discourse/discourse-subscriptions/blob/6e96f073788212b9c832fa397850e377a3298c47/app/controllers/discourse_subscriptions/subscribe_controller.rb#L161-L168

    
      
          def current_user_products
            return [] if current_user.nil?
          
          
  Customer
              .select(:product_id)
              .where(user_id: current_user.id)
              .map { |c| c.product_id }.compact
          end

If this list includes the Stripe product id as per here:

github.com

discourse/discourse-subscriptions/blob/6e96f073788212b9c832fa397850e377a3298c47/app/controllers/discourse_subscriptions/subscribe_controller.rb#L156

    
      
            end
          end
          
          
private
          
          
def serialize_product(product)
            {
              id: product[:id],
              name: product[:name],
              description: PrettyText.cook(product[:metadata][:description]),
              subscribed: current_user_products.include?(product[:id]),
              repurchaseable: product[:metadata][:repurchaseable]
            }
          end
          
          
def current_user_products
            return [] if current_user.nil?
          
          
  Customer
              .select(:product_id)
              .where(user_id: current_user.id)

Then the front end will display it as purchased. You may need to dig around the console with these queries to find out where it’s located. I almost guarantee there’s a record hanging around there yet.

amalg · Fevereiro 2, 2023, 6:36am

Ok, sei que estou ressuscitando este tópico, mas 1) isso continua sem solução e 2) encontrei tempo para investigar isso novamente… Acontece que eu era um idiota que não conseguia seguir as instruções. É assim que descobri que sou um bobo e por que agora estou pronto para resolver isso (com alguma ajuda).

O que acabei fazendo foi exportar um CSV do Stripe de todas as contas canceladas. Concentrei-me no mesmo usuário do Discourse referenciado acima neste tópico, que era assinante, havia cancelado, mas depois não conseguia se reinscrever porque a página de assinatura mostrava como “comprada”, embora sua página de assinaturas ativas não mostrasse nenhuma assinatura. Nos dados do CSV, o registro dele mostrava como “cancelado” com os seguintes dados;

id (sub_JNWejdDo4qhLG5)
customer_id (cus_JmiMoqZNTzUNxt)
user_id (id do usuário do Discourse 4981)

Então, anexei ao contêiner do aplicativo, entrei no console Ruby e comecei a investigar. Primeiro, procurei o ID do cliente em DiscourseSubscriptions::Customer e o encontrei.

[3] pry(main)> DiscourseSubscriptions::Customer.where(customer_id: 'cus_JNWeiIWTs6YOwQ')
=> [#<DiscourseSubscriptions::Customer:0x000055db2d48eb40
  id: 16,
  customer_id: "cus_JNWeiIWTs6YOwQ",
  product_id: "prod_JJbwYnKz0T5Z9h",
  user_id: 3256,
  created_at: Tue, 27 Apr 2021 07:45:07.455275000 UTC +00:00,
  updated_at: Tue, 27 Apr 2021 07:45:07.455275000 UTC +00:00>]

Em seguida, procurei em DiscourseSubscriptions::Subscription para ver se este usuário tinha alguma assinatura e, surpreendentemente, sim, ele tinha;

[1] pry(main)> DiscourseSubscriptions::Subscription.where(external_id: 'sub_JNWejdDo4qhLG5')
=> [#<DiscourseSubscriptions::Subscription:0x000055854e1e1620
  id: 16,
  customer_id: 16,
  external_id: "sub_JNWejdDo4qhLG5",
  created_at: Tue, 27 Apr 2021 07:45:07.459681000 UTC +00:00,
  updated_at: Tue, 27 Apr 2021 07:45:07.459681000 UTC +00:00>]

Portanto, parece que posso simplesmente remover este registro de assinatura e corrigir tudo… para este usuário. O fato é que todo usuário cancelado que verifiquei em minha exportação CSV ainda tinha assinaturas restantes no sistema. Obviamente, há uma desconexão de alguma forma / em algum lugar entre o webhook do Stripe e o plugin de assinatura… Eu só não sei onde / como.

Primeiro; como removo com segurança o registro de assinatura de um usuário específico? Explique como se eu tivesse 5 anos. Estou no prompt do console Ruby… como garanto que apenas os dados de assinatura do usuário alvo sejam removidos e eu não apague os dados de assinatura de todos?
Segundo, como soluciono o mecanismo de webhook de cancelamento de assinatura?

Toda a sua ajuda é muito apreciada!

ATUALIZAÇÃO:

Ok, avancei um pouco mais… Consegui descobrir como usar .delete_by para remover apenas os dados de assinatura do usuário alvo;

[1] pry(main)> DiscourseSubscriptions::Subscription.delete_by(external_id: 'sub_JNWejdDo4qhLG5')
[2] pry(main)> DiscourseSubscriptions::Subscription.where(external_id: 'sub_JNWejdDo4qhLG5')
=> []

No entanto, o registro do cliente ainda tem um product_id associado;

[3] pry(main)> DiscourseSubscriptions::Customer.where(customer_id: 'cus_JNWeiIWTs6YOwQ')
=> [#<DiscourseSubscriptions::Customer:0x0000560ec18e4948
  id: 16,
  customer_id: "cus_JNWeiIWTs6YOwQ",
  product_id: "prod_JJbwYnKz0T5Z9h",
  user_id: 3256,
  created_at: Tue, 27 Apr 2021 07:45:07.455275000 UTC +00:00,
  updated_at: Tue, 27 Apr 2021 07:45:07.455275000 UTC +00:00>]

Isso significa que eles ainda veem o visto verde e não conseguem se reinscrever… então apliquei o “destroy_all” ao objeto Customer… e funcionou! Mas apenas para aquele usuário, é claro…

[4] pry(main)> DiscourseSubscriptions::Customer.where(customer_id: 'cus_JNWeiIWTs6YOwQ').destroy_all
=> [#<DiscourseSubscriptions::Customer:0x0000560ec19770e0
  id: 16,
  customer_id: "cus_JNWeiIWTs6YOwQ",
  product_id: "prod_JJbwYnKz0T5Z9h",
  user_id: 3256,
  created_at: Tue, 27 Apr 2021 07:45:07.455275000 UTC +00:00,
  updated_at: Tue, 27 Apr 2021 07:45:07.455275000 UTC +00:00>]

Então, agora resta apenas diagnosticar por que o webhook do Stripe para assinaturas canceladas não está funcionando.

Tópico		Respostas	Visualizações
Can't cancel a subscription for Discourse Bug subscriptions , fixed	3	97	16 de Julho de 2024
Subscription update problem Bug subscriptions	11	178	13 de Dezembro de 2024
Discourse Subscriptions - user not removed from group when subscription cancelled Support subscriptions	4	789	22 de Dezembro de 2022
Subscriptions: Deleted data in Stripe, now plugin errors Support subscriptions	5	856	9 de Fevereiro de 2021
Discourse Subscriptions Plugin Plugin official , subscriptions , payments , included-in-core	46	49458	7 de Novembro de 2025

Usuário não consegue recomprar um produto de assinatura após cancelar

Tópicos relacionados