Subscription Data Import

Subscription import can create a membership subscription, its historical membership fee debts, and optional manual payment records from the contact data import flow.

Use SubscriptionPaymentDate when the first imported subscription invoice should be treated as paid. The import creates a manual Payment for the subscription using that date.

Use PayAllPastSubscriptionInvoices together with SubscriptionPaymentDate when all historical invoices up to the import date should be treated as paid. Truthy values are true, 1, yes, and y.

Import columns	Payment behavior
SubscriptionPaymentDate only	Creates the first imported subscription payment. Historical catch-up debts that remain unpaid keep the subscription in PastDue and use the plan grace period from the import date.
SubscriptionPaymentDate + PayAllPastSubscriptionInvoices=true	Creates payments for every historical subscription debt generated during import, and stores a per-subscription instruction so later debt webjobs also create matching payments for historical debts.
PayAllPastSubscriptionInvoices=true without SubscriptionPaymentDate	Does not create payments, because the import has no date anchor for the generated payment records.

The background subscription debt job also honors the pay-all instruction. When SubscriptionDebtsProcess creates or finds a debt for an imported subscription, it creates the matching manual payment only if the debt IssuedOn date is on or before the original import date. Future renewal invoices after the import date are not automatically paid.

Payment dates preserve the offset from the first imported payment. For example, if the first invoice is issued on 2021-05-14 and SubscriptionPaymentDate is 2021-05-14, later yearly historical invoices receive payments on 2022-05-14, 2023-05-14, and so on.

For plans whose payment failure action is CancelSubscription, unpaid catch-up debts created by import do not immediately cancel the subscription. The subscription remains PastDue, and GracePeriodEndDate is set from the import date plus the plan grace period.