Items — Associated Plans

The Items - Associated Plans export contains information about all plan 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 active plans. If an add-on has been removed from a plan, or if a plan has been deleted, the plan will not be included in the export.

Time Range Filter

This export includes all ACTIVE plans with a saved item add-on created during the selected timeframe. Uses the "plan_add_on_created_at" date in the export.

Export Contents

Column Name

Example

Description

item_id

l20fl6bek3mp

The system-generated unique internal identifier of the saved item used to create this add-on.

item_name

Pink Sweater

The 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_code

pink_sweater

The unique Recurly identifier of the saved item used to create this add-on. This is also the add-on code.

external_sku

PS1234

The optional external SKU of the saved item used to create this add-on.

item_status

enabled

The status of the item in your Recurly catalog. Can be "enabled" or "disabled".

plan_code

platinum

The unique Recurly identifier of the plan that offers this item as an add-on.

plan_name

Platinum Plan

The current name of the plan that offers this item as an add-on.

plan_add_on
_unit_amount_in_cents

1599

The cost (in cents) of a unit of the add-on.

plan_add_on
_currency

USD

The currency of the plan, which is the currency of the plan_add_on_unit_amount_in_cents.

plan_add_on
_created_at

2020-02-05 15:52:46 MST

The date/time the add-on was created. Used for date range filter.

plan_add_on
_modified_at

2020-02-05 15:52:46 MST

The date/time the add-on was last modified.