Any reasons why the lemonsqueezy webhook is not registering the subscription?

[itsameandrea]

Hey guys!

I'm integrating pay with LemonSqueezy within my app. This is what I've got:

In my BillingController I set the payment processor for the user

class BillingController < ApplicationController
  def show
    Current.user.set_payment_processor(:lemon_squeezy)
    @plans = Plan.all
  end
end

Then, in the view I render this button

<%= component "ui/button", block: true, url: plan.url_for(Current.user), class: "lemonsqueezy-button" do %>
   Upgrade
<% end %>

The url_for is defined in a model that looks like this

class Plan < Struct.new(:id, :name, :description, :product_uuid, :product_id, :monthly_id, :yearly_id, :full_monthly_price, :monthly_price, :yearly_price, :project_count, :guest_research_count, :is_active, :features)
  def self.all
    YAML.load_file(Rails.root.join("app", "data", "plans.yml"))
      .map(&:with_indifferent_access)
      .map(&method(:build))
  end

  def self.find(id)
    all.find { |market| market.id.to_s == id.to_s }
  end

  def premium?
    id == "premium"
  end

  def url_for(user)
    "https://xxxxxx.lemonsqueezy.com/checkout/buy/#{product_uuid}?checkout[email]=#{user.email}&checkout[custom][passthrough]=#{Pay::LemonSqueezy.passthrough(owner: user)}"
  end

  private

  def self.build(plan)
    new(
      plan[:id],
      plan[:name],
      plan[:description],
      plan[:product_uuid],
      plan[:product_id],
      plan[:monthly_id],
      plan[:yearly_id],
      plan[:full_monthly_price],
      plan[:monthly_price],
      plan[:yearly_price],
      plan[:project_count],
      plan[:guest_research_count],
      plan[:is_active],
      plan[:features]
    )
  end
end

When I click that link and go through the checkout process, I see the incoming webhook

Started POST "/pay/webhooks/lemon_squeezy" for 127.0.0.1 at 2024-10-02 08:24:47 +0200
Processing by Pay::Webhooks::LemonSqueezyController#create as HTML
08:24:47 web.1  |   Parameters: {"meta"=>{"test_mode"=>true, "event_name"=>"subscription_updated", "custom_data"=>{"passthrough"=>"eyJfcmFpbHMiOnsiZGF0YSI6ImdpZDovL2RhaXN5LXNvbGlkLXRlbXBsYXRlL1VzZXIvNjIxIiwiZXhwIjoiMjAyNC0xMS0wMlQwNjoyMzo0Mi41NzNaIiwicHVyIjoiZGVmYXVsdCJ9fQ==--47151483a31a9f3e1d2fed1d9f6ed474df651851"}, "webhook_id"=>"xxxxxx"}, "data"=>{"type"=>"subscriptions", "id"=>"xxxxx", "attributes"=>{"store_id"=>xxxxx, "customer_id"=>xxxxx, "order_id"=>xxxxx, "order_item_id"=>xxxxx, "product_id"=>xxxxx, "variant_id"=>xxxxx, "product_name"=>"Early Bird", "variant_name"=>"Annual", "user_name"=>"Andrea Test", "user_email"=>"andrea@test.com", "status"=>"active", "status_formatted"=>"Active", "card_brand"=>"visa", "card_last_four"=>"4242", "pause"=>nil, "cancelled"=>false, "trial_ends_at"=>nil, "billing_anchor"=>2, "first_subscription_item"=>{"id"=>xxxxx, "subscription_id"=>xxxx, "price_id"=>xxxx, "quantity"=>1, "is_usage_based"=>false, "created_at"=>"2024-10-02T06:24:16.000000Z", "updated_at"=>"2024-10-02T06:24:16.000000Z"}, "urls"=>{"update_payment_method"=>"https://xxxxx.lemonsqueezy.com/subscription/xxxxx/payment-details?expires=1727936687&signature=60decfc94b3ff4ca00fa97140564b91dbf8660668f53d6ec6ef390d23763b42f", "customer_portal"=>"https://guestlabai.lemonsqueezy.com/billing?expires=1727871887&test_mode=1&user=xxxxxx&signature=0a3d0067f2a351d0dcbaab6ae4f68f74d7a63f451042286f2c5528d6628abe7c", "customer_portal_update_subscription"=>"https://xxxxx.lemonsqueezy.com/billing/xxxxx/update?expires=1727936687&user=xxxxxx&signature=f81d254e8aa808a142e941593bdd198ae497f633bfa42a30f5d2d006ea7d7ca8"}, "renews_at"=>"2025-10-02T06:24:10.000000Z", "ends_at"=>nil, "created_at"=>"2024-10-02T06:24:11.000000Z", "updated_at"=>"2024-10-02T06:24:16.000000Z", "test_mode"=>true}, "relationships"=>{"store"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/store", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/store"}}, "customer"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxx/customer", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/customer"}}, "order"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/order", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/order"}}, "order-item"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/order-item", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/order-item"}}, "product"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/product", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/product"}}, "variant"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxxx/variant", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/variant"}}, "subscription-items"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/subscription-items", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxx/relationships/subscription-items"}}, "subscription-invoices"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/subscription-invoices", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/subscription-invoices"}}}, "links"=>{"self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx"}}, "lemon_squeezy"=>{"meta"=>{"test_mode"=>true, "event_name"=>"subscription_updated", "custom_data"=>{"passthrough"=>"eyJfcmFpbHMiOnsiZGF0YSI6ImdpZDovL2RhaXN5LXNvbGlkLXRlbXBsYXRlL1VzZXIvNjIxIiwiZXhwIjoiMjAyNC0xMS0wMlQwNjoyMzo0Mi41NzNaIiwicHVyIjoiZGVmYXVsdCJ9fQ==--47151483a31a9f3e1d2fed1d9f6ed474df651851"}, "webhook_id"=>"93999558-25bc-4f11-8856-6a8e647870b2"}, "data"=>{"type"=>"subscriptions", "id"=>"xxxxxx", "attributes"=>{"store_id"=>xxxxx, "customer_id"=>xxxxxx, "order_id"=>xxxxx, "order_item_id"=>xxxxxx, "product_id"=>xxxxx, "variant_id"=>xxxxx, "product_name"=>"Early Bird", "variant_name"=>"Annual", "user_name"=>"Andrea Test", "user_email"=>"andrea@test.com", "status"=>"active", "status_formatted"=>"Active", "card_brand"=>"visa", "card_last_four"=>"4242", "pause"=>nil, "cancelled"=>false, "trial_ends_at"=>nil, "billing_anchor"=>2, "first_subscription_item"=>{"id"=>xxxxx, "subscription_id"=>xxxxxx, "price_id"=>xxxxx, "quantity"=>1, "is_usage_based"=>false, "created_at"=>"2024-10-02T06:24:16.000000Z", "updated_at"=>"2024-10-02T06:24:16.000000Z"}, "urls"=>{"update_payment_method"=>"https://guestlabai.lemonsqueezy.com/subscription/634571/payment-details?expires=1727936687&signature=60decfc94b3ff4ca00fa97140564b91dbf8660668f53d6ec6ef390d23763b42f", "customer_portal"=>"https://guestlabai.lemonsqueezy.com/billing?expires=1727871887&test_mode=1&user=3449501&signature=0a3d0067f2a351d0dcbaab6ae4f68f74d7a63f451042286f2c5528d6628abe7c", "customer_portal_update_subscription"=>"https://guestlabai.lemonsqueezy.com/billing/xxxxxx/update?expires=1727936687&user=3449501&signature=f81d254e8aa808a142e941593bdd198ae497f633bfa42a30f5d2d006ea7d7ca8"}, "renews_at"=>"2025-10-02T06:24:10.000000Z", "ends_at"=>nil, "created_at"=>"2024-10-02T06:24:11.000000Z", "updated_at"=>"2024-10-02T06:24:16.000000Z", "test_mode"=>true}, "relationships"=>{"store"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/store", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/store"}}, "customer"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/customer", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxxxx/relationships/customer"}}, "order"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/order", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/order"}}, "order-item"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/order-item", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/order-item"}}, "product"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/product", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/product"}}, "variant"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/variant", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/variant"}}, "subscription-items"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/subscription-items", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxx/relationships/subscription-items"}}, "subscription-invoices"=>{"links"=>{"related"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxxx/subscription-invoices", "self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxxx/relationships/subscription-invoices"}}}, "links"=>{"self"=>"https://api.lemonsqueezy.com/v1/subscriptions/xxxxxx"}}}}
08:24:47 web.1  |   TRANSACTION (0.1ms)  begin transaction
08:24:47 web.1  |   Pay::Webhook Create (1.0ms)  INSERT INTO "pay_webhooks" ("processor", "event_type", "event", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) RETURNING "id"

And the job gets enqueued

TRANSACTION (0.1ms)  commit transaction
08:24:47 web.1  | [ActiveJob] Enqueued Pay::Webhooks::ProcessJob (Job ID: fc8197f8-b893-4c97-a064-82c8d126480a) to Async(default) with arguments: #<GlobalID:0x000000016ed5a8a8 @uri=#<URI::GID gid://daisy-solid-template/Pay::Webhook/15>>

Inspecting the logs, this is the only query that is made to any of the pay models from within the job

Pay::Customer Load (0.0ms)  SELECT "pay_customers".* FROM "pay_customers" WHERE "pay_customers"."processor" = ? AND "pay_customers"."processor_id" = ? LIMIT ?  [["processor", "lemon_squeezy"], ["processor_id", "3847429"], ["LIMIT", 1]]

I think the problem stems from this query here. Pay is trying to find a customer with processor_id 3847429, but the customer that got created with Current.user.set_payment_processor(:lemon_squeezy) does not have any processor ID assigned.

#<Pay::LemonSqueezy::Customer:0x00000001271b9ec8
 id: 6,
 owner_type: "User",
 owner_id: 621,
 processor: "lemon_squeezy",
 processor_id: nil,
 default: true,
 data: nil,
 stripe_account: nil,
 deleted_at: nil,
 created_at: Wed, 02 Oct 2024 06:51:51.666428000 UTC +00:00,
 updated_at: Wed, 02 Oct 2024 06:51:53.028335000 UTC +00:00,
 type: "Pay::LemonSqueezy::Customer">

Any ideas as to what I may be doing wrong?