Items — Associated Subscriptions

The Items - Associated Subscriptions export contains information about all subscription add-ons created from a saved item in your catalog during a period of time.

This export only reports on add-ons that are currently attached to renewing, future start, last billing period, and paused subscriptions. If an add-on has been removed from a subscription, or if a subscription has expired or has been canceled, the subscription will not be included in the export.

Time Range Filter

This export includes all RENEWING, FUTURE START, LAST BILLING PERIOD, and PAUSED subscriptions with a saved item add-on created during the selected timeframe. Uses the "subscription_add_on_created_at" date in the export.

Export Contents

Column NameExampleDescription
item_idl20fl6bek3mpThe system-generated unique internal identifier of the saved item used to create this add-on.
item_namePink SweaterThe name of the saved item used to create this add-on. This is also the add-on name, which will appear on the customer's invoice.
item_codepink_sweaterThe unique Recurly identifier of the saved item used to create this add-on. This is also the add-on code.
external_skuPS1234The optional external SKU of the saved item used to create this add-on.
item_statusenabledThe status of the item in your Recurly catalog. Can be "enabled" or "disabled".
plan_codeplatinumThe unique Recurly identifier of the plan associated with this subscription.
plan_namePlatinum PlanThe current name of the plan associated with this subscription.
subscription_id3c42a34d1442f840The system-generated unique internal identifier for the subscription that offers this item as an add-on.
subscription_add_on
_quantity
1The number of add-ons added to the subscription for this item.
subscription_add_on
_unit_amount_in_cents
600The cost (in cents) of a unit of the add-on on the subscription. Can differ from the default cost of a unit of the add-on on the plan, or from the default price of the item.
subscription_add_on
_currency
USDThe currency being charged with this subscription.
subscription_add_on
_created_at
2020-02-07 10:18:34 MSTThe date/time the add-on was created. Used for date range filter.
subscription_add_on
_modified_at
2020-02-07 10:18:34 MSTThe date/time the add-on was last modified.