Function main

scripts/backdate-salesforce-invoice.ts:62–152

()

});

async function main() {
  // 1. Find the price by lookup key
  const prices = await stripe.prices.list({
    lookup_keys: [LOOKUP_KEY],
    active: true,
    expand: ['data.product'],
  });

  if (prices.data.length === 0) {
    console.error(`No active price found for lookup key: ${LOOKUP_KEY}`);
    process.exit(1);
  }

  const price = prices.data[0];
  const product = price.product as Stripe.Product;
  console.log(`Product: ${product.name} (${price.lookup_key})`);
  console.log(`Amount: ${(price.unit_amount! / 100).toFixed(2)} ${price.currency.toUpperCase()}`);
  console.log(`Invoice date: ${INVOICE_DATE.toISOString().split('T')[0]}`);
  console.log(`Terms: net-${DAYS_UNTIL_DUE}`);

  if (dryRun) {
    console.log('\n--dry-run: Would create subscription + backdated invoice. Exiting.');
    return;
  }

  // 2. Find or create customer
  const existing = await stripe.customers.list({ email: CUSTOMER_EMAIL, limit: 1 });
  let customer: Stripe.Customer;

  if (existing.data.length > 0) {
    customer = existing.data[0];
    console.log(`\nFound existing customer: ${customer.id}`);
  } else {
    customer = await stripe.customers.create({
      email: CUSTOMER_EMAIL,
      name: COMPANY_NAME,
      metadata: { contact_name: CONTACT_NAME },
    });
    console.log(`\nCreated customer: ${customer.id}`);
  }

  // 3. Create subscription with backdated start and custom terms
  const invoiceDateUnix = Math.floor(INVOICE_DATE.getTime() / 1000);

  const subscription = await stripe.subscriptions.create({
    customer: customer.id,
    items: [{ price: price.id }],
    collection_method: 'send_invoice',
    days_until_due: DAYS_UNTIL_DUE,
    backdate_start_date: invoiceDateUnix,
    metadata: {
      lookup_key: LOOKUP_KEY,
      contact_name: CONTACT_NAME,
      note: 'Backdated invoice created via script',
    },
  });

  console.log(`\nSubscription created: ${subscription.id}`);