Stripe webhook checkout.session items to Supabase

user_7771863 0
Viewed 268

Im using next.js and Stripe webhooks to insert checkout sessions to Supabase that will create a customer's order history. I'm able to get the information about the whole order written to a table called 'orders', but am wondering what the best way to add individual items within each checkout session to another table called 'order_items' is. This way I can map through main orders and then the children items. Appreciate any help provided. Here is what I have for getting orders associated with a customer:

const upsertOrderRecord = async (session: Stripe.Checkout.Session, customerId: string) => {
  const { data: customerData, error: noCustomerError } = await supabaseAdmin
    .from<Customer>('customers')
    .select('id')
    .eq('stripe_customer_id', customerId)
    .single();
  if (noCustomerError) throw noCustomerError;

  const { id: uuid } = customerData || {};
    const sessionData: Session = {
      id: session.id,
      amount_total: session.amount_total ?? undefined,
      user_id: uuid ?? undefined
    };

    const { error } = await supabaseAdmin.from<Session>('orders').insert([sessionData], { upsert: true });
    if (error) throw error;
    console.log(`Product inserted/updated: ${session.id}`);
  };
supabase-database supabase stripe-payments next.js reactjs
1 Answers

The Checkout Session object contains a line_items field which is a list of each item included in the purchase.

However this field is not included in the object by default, and therefore won't be a part of your webhook payload. Instead you'll need to make an API call in your webhook handle to retrieve the Checkout Session object, passing the expand parameter to include the line_items field:

const session = await stripe.checkout.sessions.retrieve('cs_test_xxx', {
  expand: ['line_items']
});
user_157846500
Related