Cashier: use Billable on User model but store information in payment_method table

As the title says, I want to use Cashier and it's Billable trait on the User model, but I am also trying to store the information about the customer (stripe ID, pm_last_four, etc) on a separate table called payment_methods, as the application will allow users to store multiple payment types for one-off transactions.

I have published and altered the Cashier migrations so that they create the fields in the new table, but when I try to run $user->createAsStripeCustomer() I get this error:

Column not found: 1054 Unknown column 'stripe_id' in 'field list'

I know it's because Cashier is expecting the stripe_id to exist in the users table, because that's where I have defined the use of the Billable trait, but is there a way to override it? I couldn't find anything in the config, and I haven't yet found anything in the documentation.

martinbean

3 years ago

Level 80

@garrettmassey A customer can have multiple payment methods, but will only ever have one Stripe ID. That is the ID of the customer in Stripe. A customer doesn’t get multiple IDs just because they have multiple payment methods.

If you want to interact with a user’s payment methods then use the methods that Cashier gives you to do so: https://laravel.com/docs/9.x/billing#retrieving-payment-methods

1 like

Please or to participate in this conversation.