如何基于Stripe订阅中客户A的扣费自动触发客户B计费？

Absolutely, you can make this work with Stripe Subscriptions and Webhooks—here's a step-by-step breakdown tailored to your gym membership scenario:

1. 搭建产品与客户的基础结构 #

First, you'll want to set up a usage-based pricing model for your gym membership, since the cost fluctuates based on days used:

• Create a product for your weekly gym membership, then add a price that charges per day (e.g., $4/day, since $20/5 workdays = $4). This lets you track exactly how many days each employee used the gym each week.
• Create Stripe Customer records for both the employee (Customer A) and their company (Customer B). Make sure you store the link between them in your own database (or add metadata to the employee's Stripe Customer object) so you can look up the company later.

2. 处理客户A的浮动订阅扣费 #

For the employee's subscription:

• Create a subscription for Customer A using the per-day price you set up.
• At the end of each week, use the Stripe API to report usage (i.e., the number of days the employee actually used the gym). Stripe will automatically calculate the total weekly cost (e.g., 3 days × $4 = $12, or whatever the actual usage is).
• Stripe will generate an invoice for Customer A and charge their saved payment method.

3. 用Webhooks自动触发客户B的扣费 #

This is the key part—you'll use a Stripe Webhook to listen for when Customer A's invoice is successfully paid, then charge the company the remaining amount:

• In your Stripe Dashboard, go to Webhooks and add an endpoint pointing to your backend server. Subscribe to the invoice.paid event (this fires only when the customer's payment goes through successfully).
• On your backend, write code to handle this event:
  1. Validate the Webhook signature (critical for security—never skip this, as it prevents fake requests).
  2. Pull the total amount from the paid invoice (in cents, since Stripe uses smallest currency units).
  3. Look up how much the employee is responsible for (e.g., $16) from your database or the customer's metadata.
  4. Calculate the remaining amount the company owes (total invoice amount - employee contribution).
  5. Use the Stripe API to create a one-time PaymentIntent or Invoice for Customer B to charge the remaining amount.

后端代码示例（Node.js） #

const stripe = require('stripe')('your_stripe_secret_key');
const express = require('express');
const app = express();

// Webhook端点配置
app.post('/stripe-webhook', express.raw({ type: 'application/json' }), async (req, res) => {
  const sig = req.headers['stripe-signature'];
  let event;

  // 验证Webhook签名
  try {
    event = stripe.webhooks.constructEvent(
      req.body,
      sig,
      'your_webhook_secret'
    );
  } catch (err) {
    return res.status(400).send(`Webhook Error: ${err.message}`);
  }

  // 处理客户A的发票支付成功事件
  if (event.type === 'invoice.paid') {
    const invoice = event.data.object;
    const customerAId = invoice.customer;

    // 从数据库获取员工与企业的关联信息
    const employee = await yourDatabase.query(`SELECT * FROM employees WHERE stripe_customer_id = $1`, [customerAId]);
    const customerBId = employee.company_stripe_customer_id;
    const employeeContributionCents = employee.weekly_contribution * 100; // 转换为分

    // 计算企业需支付的金额
    const totalInvoiceCents = invoice.total;
    const companyOwedCents = totalInvoiceCents - employeeContributionCents;

    if (companyOwedCents > 0) {
      // 向客户B发起扣费
      await stripe.paymentIntents.create({
        amount: companyOwedCents,
        currency: 'usd',
        customer: customerBId,
        description: `Gym membership contribution for ${employee.name} (Week of ${new Date(invoice.created * 1000).toLocaleDateString()})`,
      });
    }
  }

  res.json({ received: true });
});

app.listen(3000, () => console.log('Webhook server running on port 3000'));

4. 需要考虑的边缘情况 #

• 客户A支付失败: 因为我们监听的是invoice.paid事件，只有员工支付成功后才会触发企业扣费。如果员工支付失败，Stripe会发送invoice.payment_failed事件，你可以暂停企业扣费并通知员工/HR。
• 客户B支付失败: 在Stripe的支付设置中开启自动重试，并配置告警，方便你跟进企业的支付问题。
• 固定/浮动员工分摊金额: 如果部分员工有固定周付金额（比如不管使用天数都付$16），直接在数据库存储该值；如果是按比例分摊，调整计算逻辑即可。

最后说明 #

这个方案足够灵活，能适配你的浮动收费模型，一旦搭建好基础结构，就能完全自动化分摊支付流程。你还可以扩展功能，比如给双方发送支付凭证，或者在你的签到系统中自动向Stripe上报使用天数。

内容的提问来源于stack exchange，提问作者JoeDenly