Available exports in the Export Builder
Use this article to understand which data each export includes in the Export Builder, so you can choose the right one for your use case.
The exports available to your store can vary depending on your Recharge platform.
Before you start
Most exports follow the same setup flow:
- In the merchant portal, click Tools & apps and select Exports.
- Click Create export.
- Select the export type.
- Enter a custom export name if needed.
- Select any available filters, date ranges, or additional columns.
- Click Export data.
Some exports reference related records by ID only. In those cases, you may need to run a related export, such as Customers or Addresses, to get more context.
Choose the right export
Use case |
Recommended export |
| Review customer records | Customers or Customers - active |
| Review shipping address information | Addresses or Customers - shipping addresses |
| Review upcoming or failed billing activity | Charges exports |
| Review order activity by status | Orders exports |
| Review subscription records by status | Subscriptions exports |
| Review credit balances or adjustments | Credit - Accounts or Credit - Adjustments |
| Review bundle selections | Bundles exports |
| Review gift subscription activity | Gifts |
| Review sent notification emails | Emails |
| Review activity logs | Events |
Recommended and additional columns
Some exports include both recommended and additional columns.
- Recommended columns include the core data most merchants need for that export.
- Additional columns include extra supporting data that may be useful depending on your use case.
Recharge automatically selects all recommended columns. Review the available additional columns before you run the export if you need more detailed data.
Some Charges and Orders exports also let you include line-item columns. When you enable line item columns, each line item is exported on its own row instead of grouping the charge or order into a single summary row.
Use line item columns when you need item-level reporting for titles, variants, quantities, SKUs, or pricing.
Addresses
Addresses - Similar By Creation Date
Use this export to identify similar customer addresses.
This export includes:
- Customer identifiers
- Address details
- Address creation date
- Subscription count
- Next charge date
- A subscription link
Helpful columns: customer_id, address_id, address_created_at, subscription_count, next_charge_date
View available columns
Header |
Definition |
|---|---|
| customer_id | A unique string of numbers that identifies a specific customer and is tied to their email address. Even if a customer has multiple subscriptions under one email address, they will only have one customer ID. |
| customer_first_name | The customer’s first name listed on the subscription. |
| customer_last_name | The customer’s last name listed on the subscription. |
| address_id | A unique string of numbers used to identify the customer’s subscription. This is also referred to as the purchase ID. Individual products within a subscription are assigned a unique purchase_item_id. |
| address_created_at | The date the address was created. |
| address_1 | The customer’s street address. This may differ from the billing address if the recipient and cardholder live at different addresses. |
| address_2 | Additional address information, such as an apartment number or mailbox. This field is optional. |
| city | The city where the subscriber is located. |
| zip | The ZIP or postal code where the subscriber is located. |
| state | The state or province where the subscriber is located. |
| country | The country where the subscriber is located. |
| subscription_count | The number of subscriptions associated with the address. |
| next_charge_date | The next charge date for the subscription(s) associated with the address. |
| subscription_link | A link to the subscription order details. |
Bundles
Customizable Bundles - Active
Use this export to review the products currently selected in active bundle subscriptions.
Each product in a bundle is listed on its own row. For example, if a bundle includes five unique items, the export will contain five rows for that bundle.
View available columns
Each unique product is listed on a separate row. If your bundle product has five unique items, the bundle has five rows listed in the export.
Header |
Definition |
| Subscription ID | Unique identifier for the subscription in Recharge that the bundle belongs to. |
| Subscription Title | The name of the active bundle subscription as it appears in your store. |
| Next Charge Date | The upcoming date when the customer’s next charge for this bundle is scheduled. |
| Variant Title | The selected product variant for the main bundle subscription (for example, size or flavor). |
| Selection ID | Unique identifier for the current bundle selection. |
| Selection Item Product ID | The commerce platform’s unique product ID (for example, Shopify product ID) for the item in the bundle. |
| Selection Item Variant ID | The commerce platform’s unique variant ID for the item in the bundle. |
| Selection SKU | The SKU (stock keeping unit) for the selected bundle item, used for inventory tracking and fulfillment. |
| Selection Quantity | The number of units of the bundle item included in the selection. |
| Last Updated At | The most recent date and time the bundle selection or configuration was updated in Recharge. |
| Product Title | (Optional) The title of the product included in the bundle. |
| Is Fallback | (Optional) Indicates whether the bundle contains fallback contents instead of customer-selected items. A value of 0 means no, and 1 means yes. |
| Customer ID | (Optional) Unique identifier for the customer associated with the bundle. |
| Customer Email | (Optional) Email address of the subscriber who owns the bundle. |
Bundles selection - Filtered by contents
Use this export to review specific products included in customers' bundle selections.
Use Add products to filter by to select the products you want to review.
View available columns
Header |
Definition |
| Bundle Selection ID | Unique numeric identifier for the bundle selection. This ID remains the same for each selection within a subscription. |
| Subscription ID | Unique numeric identifier for the subscription. |
| Selection Item Product ID | The product ID of the bundle selection. |
| Selection Item Variant ID | The variant ID of the bundle selection. |
| Selection SKU | The product SKU of the bundle selection. |
| Selection Quantity | The number of units of the selected product in the bundle. |
| Subscriber ID | The Recharge customer ID. |
| Subscriber Email | The customer’s email address. |
| Bundle Variant ID | (Optional) The variant ID associated with a bundle product. |
| Is Fallback | (Optional) Indicates whether the bundle contains fallback contents instead of customer-selected items. A value of 0 means no, and 1 means yes. |
Charges
Charges exports help you review charge activity across different statuses.
Date range limits:
- Up to 90 days for future charges
- Up to 1 year for processed charges
Charges exports reference customers and addresses by ID. Run the Customers or Addresses export if you need additional record details.
Charge exports let you choose whether to include line-item columns, which export each line item as its own row. Selecting Include line item columns is useful when you need detailed, item-level data for each product within a charge or order. Instead of a single row summarizing the entire charge, this option creates a separate row for each item.
Available line item columns
Header |
Definition |
| line_item_title | Product title for the line item on the charge. |
| line_item_variant_title | Variant or option name for the line item (for example, size or flavor). |
| line_item_quantity | Number of units for this line item on the charge. |
| line_item_external_product_id | Commerce platform product ID for this line item (for example, Shopify product ID). |
| line_item_external_variant_id | Commerce platform variant ID for this line item (for example, Shopify variant ID). |
| line_item_properties | Custom key–value properties on the line item (for example, personalization or bundle selections). |
| line_item_sku | SKU used for inventory and fulfillment for this line item. |
| line_item_original_price | Per-unit price before any discounts, in the presentment currency. |
| line_item_price | Line item total after per-line discounts (original price × quantity − line discounts). Excludes order-level discounts, taxes, duties, and shipping. |
| line_item_subscribe_and_save_discount | Discount amount applied to this line due to a Subscribe & Save or recurring discount. |
| line_item_purchase_item_type | Purchase type for the line (for example, subscription, one_time, prepaid, add_on). |
| line_item_subscription_id | Associated subscription ID when the line belongs to a subscription or prepaid cycle. Blank for one-time lines. |
Charges - error
Use this export to review charges that failed between the selected start and end dates.
View available columns
Note that addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| charge_id | Unique identifier for the charge record in Recharge. |
| multiple_rows | Indicates that the same charge appears across multiple export rows (for example, when a charge has multiple line items). Subsequent rows repeat the charge-level fields. |
| address_id | Unique identifier for the customer’s subscription address associated with the charge. |
| customer_id | Unique identifier for the customer in Recharge (tied to the customer’s email). |
| external_order_id | The commerce platform order ID (for example, Shopify) created for the charge. Often blank for failed charges. |
| processor_name | Name of the payment processor or gateway used for the charge (for example, Stripe, Braintree, Authorize.net). |
| transaction_id | Identifier returned by the payment gateway for the attempt. May be missing if no transaction was created. |
| shipments_count | Number of shipments associated with this charge. Failed charges typically have 0. |
| type | Charge type (for example, recurring subscription charge or one-time add-on charge). |
| status | Current charge status. In the error export this is usually failed or error, but may also show queued or pending during retries. |
| pending_status_reason | Reason the charge is pending (for example, dunning, awaiting retry, or a payment method update is required). |
| scheduled_at | The date and time the charge is or was scheduled to process. |
| original_scheduled_at | The initial scheduled date and time before any reschedules (for example, due to dunning or edits). |
| processed_at | Timestamp of the most recent processing attempt (successful or failed). |
| subtotal_price | Item total before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax amount applied to the charge, in the presentment currency. |
| total_duties | Total duties applied (if applicable), in the presentment currency. |
| total_shipping | Total shipping amount for the charge, in the presentment currency. |
| total_discounts | Total value of discounts (order-level and line-item), in the presentment currency. |
| total_price | Grand total after discounts, taxes, duties, and shipping, in the presentment currency. |
| total_refunds | Total amount refunded against this charge, in the presentment currency. For failed charges this is typically 0. |
| note_attributes | Key-value metadata attached to the charge (for example, custom attributes from apps or workflows). |
| note | Free-form note associated with the charge (merchant-authored or system-generated). |
| created_at | Timestamp when the charge record was created in Recharge. |
| updated_at | Timestamp of the most recent update to the charge record. |
| merged_at | Timestamp when this charge was merged or consolidated with another charge (if applicable). |
| discount_id | Internal ID of the discount applied to the charge (if any). |
| discount_code | Discount code used on the charge (if any). |
| shipping_lines | Breakdown of shipping lines for the charge (for example, method, title, and amount). |
| error | Human-readable error message from the payment attempt (often returned by the gateway). |
| last_charge_attempt_date | Timestamp of the most recent failed attempt to collect payment for this charge. |
| error_type | Categorized error reason (for example, card_declined, card_expired, insufficient_funds, gateway_error). |
| number_times_tried | Total number of collection attempts made for this charge (includes initial and dunning retries). |
| retry_date | The next scheduled retry date for this failed charge (based on your dunning settings). |
| Customer’s email address associated with the charge. | |
| billing_first_name | Cardholder’s first name on the billing address. |
| billing_last_name | Cardholder’s last name on the billing address. |
| billing_company | Company name on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (apartment, suite, unit; optional). |
| billing_city | Billing city. |
| billing_province | Billing state, province, or region. |
| billing_zip | Billing postal or ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if provided). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (apartment, suite, unit; optional). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state, province, or region. |
| shipping_zip | Shipping postal or ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if provided). |
| store_subtotal_price | Item subtotal in your store currency before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes in your store currency. |
| store_total_duties | Total duties in your store currency. |
| store_total_discounts | Total discounts in your store currency. |
| store_total_price | Grand total in your store currency after discounts, taxes, duties, and shipping. |
| store_line_items_price | Sum of line item prices in your store currency. |
| store_total_shipping | Total shipping in your store currency. |
| store_total_refunds | Total refunds issued for this charge in your store currency. |
| store_currency | Your store’s base currency (ISO code, for example USD, CAD, GBP). |
| currency_conversion_rate_presentment_to_store | Rate used to convert from the presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Rate used to convert from the presentment currency to USD. |
| usd_total_price | Grand total converted to USD using the presentment-to-USD rate. |
| presentment_currency | Currency shown to the customer for this charge (ISO code). |
| is_gift | Indicates whether the charge was a gift purchase (true or false). |
Charges - pending
Use this export to review charges that have entered processing but have not yet completed successfully. These charges typically require attention, as they may be waiting on payment authorization, retry attempts, or error resolution. This export helps you identify why a charge has not completed and what action may be needed.
View available columns
Addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| charge_id | A unique string of numbers given to each charge. The charge ID is used to reference a specific charge. |
| multiple_rows |
This field indicates whether there are multiple products contained within the charge. Each product will be present within the export as a separate row, identified with the same Order ID. If this value is falsethere is a single line item within the charge. If the value is true, multiple line item rows are available for this charge. The rows will share the same id as well as all fields except fields starting with line_item_. This is to provide line item level information for each charge. |
| address_id | A unique string of numbers used to identify the customer’s subscription. This is also referred to as the Purchase ID. Individual products within a subscription will also be assigned a unique purchase_items_id. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| external_order_id | A unique string of numbers that corresponds to the order created in your eCommerce platform for fulfillment. Generally, this information is only used by your eCommerce platform’s API to create the order. |
| processor_name |
List the payment processor associated with the charge (e.g. Braintree) Charges that are associated with a Shopify Payment Gateway will have shopify_payments under the processor_name column regardless of what processor was used. |
| transaction_id | A unique string of numbers assigned by the payment gateway that is used to identify a transaction. |
| shipments_count | The number of shipments that were sent for that specific order. |
| type | The type of charge it is, such as recurring. |
| status | The status of the charge. Depending on which export you pull, the status will be different. For example, processed or queued. |
| pending_status_reason | The reason for the status. |
| scheduled_at | The date the charge is scheduled to process. |
| processed_at | The date the charge was processed. |
| subtotal_price | The price of the charge before taxes, shipping, or discounts. |
| total_taxes | Total combined tax amount on the charge. |
| total_shipping | The total cost for shipping on a specific charge. |
| total_discounts | The total discount amount. |
| total_price | The total price of the charge, including taxes, discounts and shipping. |
| total_refunds | The total refunds provided on the charge. |
| note_attributes | Extra information that is added to the order. Each array entry will contain “name” and “value” keys. |
| note | The note that is passed in the “note” field of orders when submitted to your eCommerce platform. |
| created_at | The date the charge was created. |
| updated_at | If a change is made to the charge, then this column will reflect the most recent change date. |
| discount_id | When a discount code is applied to a charge, a unique string of numbers is attributed to the code being used. The ID identifies a specific discount code used on a single charge. |
| discount_code | A specific string of text, numbers, or a combination of both, that customers can use to receive their subscription at a reduced cost. |
| shipping_lines |
Recharge pulls the shipping rate applied to each charge from the If the shipping settings retain the original rate, this value reflects the rate the customer pays at checkout. If the system dynamically recalculates shipping, this value reflects the updated rate at the time of the charge, which may differ from the checkout rate. |
| error | The error code listed on the charge in Recharge. |
last_charge_attempt_date |
The last time that we tried to process the unsuccessful charge. |
| error_type | The error type listed on the charge in Recharge. |
number_times_tried |
The total number of times we have attempted to process the charge. |
| retry_date | The date when the next attempt will be placed. |
| The email address associated with the subscription. | |
billing_first_name |
The cardholder’s first name. |
billing_last_name |
The cardholder’s last name. |
| billing_company | The cardholder’s company name. This field is not mandatory. |
| billing_address1 | The street address of the cardholder. This address can be different than the shipping address if the customer has purchased the product for someone else. |
| billing_address2 | Any additional address information such as apartment number or specific mailbox. This field is not mandatory. |
| billing_city | The city the cardholder lives in. |
| billing_province | The cardholder’s state or province. |
| billing_zip | The cardholder’s zip or postal code. |
| billing_country | The country the cardholder lives in. |
| billing_phone | The cardholder’s phone number. |
shipping_first_name |
The first name of the person receiving the subscription product, aka the subscriber. |
shipping_last_name |
The subscriber’s last name. |
shipping_address1 |
The subscriber’s street address. This address may be different than the billing address if the person receiving the subscription and the cardholder live at different addresses. |
shipping_address2 |
Any additional address information such as apartment number or specific mailbox. This field is not mandatory. |
shipping_company |
The subscriber’s company. |
| shipping_city | The city where the subscriber is located. |
shipping_province |
The subscriber’s state or province. |
| shipping_zip | The subscriber’s zip or postal code. |
| shipping_country | The country where the subscriber is located. |
| shipping_phone | The phone number of the person receiving the subscription. This is helpful if there are any problems with shipping or delivery. |
| line_item_title | The title of the product within the charge. |
line_item_variant_title |
The variant title of the product within the charge. |
line_item_quantity |
The amount of the specific product within a charge. |
line_item_external_product_id |
The external product ID within the charge. |
line_item_external_variant_id |
The external variant ID within the charge. |
line_item_properties |
This column displays any line item properties associated with the product within the charge. |
| line_item_sku | The SKU of the product within the charge. |
| line_item_price | The price of the product within the charge. |
| line_item_purchase_item_type | The type of item within the charge. |
| line_item_subscription_id | The subscription ID within the charge. |
| store_currency | The store’s main currency |
| total_duties | Duties displayed in presentment currency. |
| store_total_duties | Total duties displayed in store currency. |
| store_subtotal_price | Subtotal is displayed in store currency. |
| store_total_taxes | Taxes are displayed in store currency. |
| store_total_discounts | Discounts displayed in store currency. |
| store_total_price | Price displayed in store currency. |
| store_line_item_price | Line items displayed in store currency. |
| store_total_shipping | Shipping displayed in store currency. |
| store_total_refunds | Refunds displayed in store currency. |
| currency_conversion_rate_presentment_to_store | Currency conversion rate from presentment currency to store currency. |
| currency_conversion_rate_presentment_to_usd | Currency conversion rate from presentment currency to USD. |
| usd_total_price | Total pricing converted into USD. |
| presentment_currency | The currency the customer checked out with. |
| merged_at | List of charges that have been merged and the associated customers. |
| original_scheduled_at | The date when the charge was initially created. This date never changes. To determine the original charge date, refer to the original_charge_date attribute. |
Charges - processed
Use this export to review successfully processed charges within the selected date range.
View available columns
Note that addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| charge_id | Unique identifier for the charge record in Recharge. |
| multiple_rows | Indicates that the charge spans multiple rows in the export (for example, if there are multiple line items associated with one charge). |
| address_id | Unique identifier for the subscription address associated with the charge. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email address. |
| external_order_id | The commerce platform’s order ID (for example, Shopify) once the charge successfully creates an order. |
| processor_name | The payment processor or gateway responsible for the transaction (for example, Stripe, Braintree, Authorize.net). |
| transaction_id | Unique identifier returned by the payment gateway when the transaction is attempted or authorized. |
| shipments_count | Number of shipments created or expected to be created once the charge completes processing. |
| type | Type of charge (for example, recurring subscription charge or one-time add-on charge). |
| status | Current charge status. For this export, statuses typically include queued, processing, or pending. |
| pending_status_reason | Reason the charge is pending (for example, awaiting inventory, awaiting order creation, or pending fulfillment). |
| scheduled_at | Date and time when the charge is scheduled to process. |
| original_scheduled_at | Initial scheduled processing date and time before any adjustments (for example, customer skips or edits). |
| processed_at | Timestamp indicating when the processing attempt began or most recently occurred. |
| subtotal_price | Item total before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax amount applied to the charge, in the presentment currency. |
| total_duties | Total duties applied (if applicable), in the presentment currency. |
| total_shipping | Total shipping cost for the charge, in the presentment currency. |
| total_discounts | Total value of all applied discounts, in the presentment currency. |
| total_price | Total charge amount after discounts, taxes, duties, and shipping, in the presentment currency. |
| total_refunds | Total refunded amount (if applicable) in the presentment currency. Typically 0 for processing charges. |
| note_attributes | Key-value metadata attached to the charge (for example, custom attributes or workflow tags). |
| note | Free-form note associated with the charge (either merchant-authored or system-generated). |
| created_at | Timestamp when the charge was created in Recharge. |
| updated_at | Timestamp of the most recent update to the charge record. |
| merged_at | Timestamp when the charge was merged with another charge, if applicable. |
| discount_id | Internal ID of the discount applied to the charge (if any). |
| discount_code | Discount code applied to the charge (if any). |
| shipping_lines | Details about shipping lines (method name, price, title, and rate). |
| error | If the charge is in processing but encountered a temporary issue, this column includes the error message (for example, gateway timeout). |
| last_charge_attempt_date | Timestamp of the last processing attempt for this charge. |
| error_type | Categorized error reason (for example, gateway_error, network_error, or timeout). Typically blank unless a temporary failure occurred. |
| number_times_tried | Total number of processing attempts made for this charge to date. |
| retry_date | Date of the next automatic retry if the charge is awaiting reprocessing. |
| Customer’s email address associated with the charge. | |
| billing_first_name | Billing contact’s first name. |
| billing_last_name | Billing contact’s last name. |
| billing_company | Company name listed on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (for example, apartment or suite number). |
| billing_city | Billing city. |
| billing_province | Billing state, province, or region. |
| billing_zip | Billing postal or ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if available). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (for example, apartment or suite number). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state, province, or region. |
| shipping_zip | Shipping postal or ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if available). |
| store_subtotal_price | Item subtotal in your store currency before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes in your store currency. |
| store_total_duties | Total duties in your store currency. |
| store_total_discounts | Total discounts in your store currency. |
| store_total_price | Grand total after discounts, taxes, and shipping in your store currency. |
| store_line_items_price | Total of all line item prices in your store currency. |
| store_total_shipping | Shipping total in your store currency. |
| store_total_refunds | Refund total in your store currency (usually 0 for in-progress charges). |
| store_currency | Your store’s base currency (ISO code). |
| currency_conversion_rate_presentment_to_store | Exchange rate used to convert the customer’s presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Exchange rate used to convert from the presentment currency to USD. |
| usd_total_price | Charge total converted to USD. |
| presentment_currency | Currency displayed to the customer for this charge (ISO code). |
| is_gift | Indicates whether the charge is a gift order (true/false). |
Charges - queued
Use this export to review upcoming charges that are scheduled to process in the future. These charges have not yet entered processing and do not have an associated order or transaction. This export is useful for forecasting upcoming revenue and reviewing scheduled charges before they are processed.
View available columns
Note that addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| charge_id | Unique identifier for the charge record in Recharge. |
| multiple_rows | Indicates that the charge spans multiple rows in the export (for example, when a charge includes multiple line items). |
| address_id | Unique identifier for the subscription address associated with this queued charge. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email address. |
| external_order_id | The commerce platform’s order ID (for example, Shopify). This field is blank for queued charges, as no order has been created yet. |
| processor_name | Payment processor or gateway that will be used once the charge begins processing (for example, Stripe, Braintree, Authorize.net). |
| transaction_id | Unique identifier from the payment gateway once the charge is attempted. This remains empty for queued charges. |
| shipments_count | Number of shipments that will be generated once this queued charge processes successfully. |
| type | Type of charge (for example, recurring subscription charge or one-time add-on charge). |
| status | Current charge status. For this export, the value is typically queued. |
| pending_status_reason | Reason the charge remains queued (for example, future scheduled date or pending prerequisite process). |
| scheduled_at | The date and time the charge is scheduled to process next. |
| original_scheduled_at | The original scheduled processing date before any reschedules (for example, due to customer skips or updates). |
| processed_at | Empty for queued charges until processing begins. |
| subtotal_price | Item total before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax amount that will apply once the charge is processed, in the presentment currency. |
| total_duties | Total duties that will apply once the charge is processed, in the presentment currency. |
| total_shipping | Total shipping cost for the queued charge, in the presentment currency. |
| total_discounts | Total value of discounts that will be applied to the charge, in the presentment currency. |
| total_price | Expected total amount of the charge after discounts, taxes, duties, and shipping, in the presentment currency. |
| total_refunds | Total refunded amount, typically 0 for queued charges. |
| note_attributes | Key-value metadata attached to the charge (for example, tags or custom fields from integrations). |
| note | Free-form note associated with the charge (merchant-authored or system-generated). |
| created_at | Timestamp when the charge was created and entered the queue. |
| updated_at | Timestamp of the most recent update to the queued charge record. |
| merged_at | Timestamp if this queued charge was merged with another charge (for example, during batching). |
| discount_id | Internal ID of the discount applied to the charge (if any). |
| discount_code | Discount code applied to the queued charge (if any). |
| shipping_lines | Details about the shipping method and rate that will apply once the charge is processed. |
| error | Error information (typically empty for queued charges, as no processing has occurred yet). |
| last_charge_attempt_date | Date of the most recent processing attempt, if any. Typically empty for queued charges. |
| error_type | Categorized error reason. Typically empty for queued charges. |
| number_times_tried | Number of processing attempts made. Queued charges will show 0. |
| retry_date | The next scheduled retry date if the charge has been rescheduled before processing begins. |
| Customer’s email address associated with the queued charge. | |
| billing_first_name | Billing contact’s first name. |
| billing_last_name | Billing contact’s last name. |
| billing_company | Company name listed on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (for example, apartment or suite number). |
| billing_city | Billing city. |
| billing_province | Billing state, province, or region. |
| billing_zip | Billing postal or ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if available). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (for example, apartment or suite number). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state, province, or region. |
| shipping_zip | Shipping postal or ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if available). |
| store_subtotal_price | Item subtotal in your store currency before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes in your store currency. |
| store_total_duties | Total duties in your store currency. |
| store_total_discounts | Total discounts in your store currency. |
| store_total_price | Expected total after discounts, taxes, duties, and shipping in your store currency. |
| store_line_items_price | Sum of line item prices in your store currency. |
| store_total_shipping | Shipping total in your store currency. |
| store_total_refunds | Refund total in your store currency (typically 0 for queued charges). |
| store_currency | Your store’s base currency (ISO code, for example, USD, CAD, GBP). |
| currency_conversion_rate_presentment_to_store | Exchange rate used to convert from the customer’s presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Exchange rate used to convert from the presentment currency to USD. |
| usd_total_price | Expected total converted to USD. |
| presentment_currency | Currency displayed to the customer for this charge (ISO code). |
| is_gift | Indicates whether the queued charge is a gift purchase (true/false). |
Charges - skipped
Use this export to review charges that were skipped between the selected start and end dates.
View available columns
Note that addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| charge_id | Unique identifier for the charge record in Recharge. |
| multiple_rows | Indicates the charge spans multiple rows in the export (for example, when multiple line items exist). |
| address_id | Unique identifier for the subscription address associated with the charge. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email. |
| external_order_id | Commerce platform order ID (e.g., Shopify). Skipped charges do not create orders, so this is typically blank. |
| processor_name | Payment processor or gateway configured for the subscription (e.g., Stripe, Braintree). No processing occurs for skipped charges. |
| transaction_id | Gateway transaction identifier. Skipped charges do not attempt payment, so this is blank. |
| shipments_count | Number of shipments associated with the charge. Skipped charges typically have 0. |
| type | Charge type (for example, recurring subscription charge or one-time add-on). |
| status | Current status. For this export, the status is typically skipped. |
| pending_status_reason | Reason the charge was skipped (for example, customer-initiated skip, rule-based skip, inventory or timing rules). |
| scheduled_at | Date and time the charge was originally scheduled before being skipped. |
| original_scheduled_at | Initial scheduled date before any edits; useful if the charge was rescheduled and then skipped. |
| processed_at | Processing timestamp. Skipped charges do not process, so this is blank. |
| subtotal_price | Item subtotal before discounts, taxes, and shipping, in the presentment currency (for reference even if skipped). |
| total_taxes | Calculated taxes in the presentment currency (reference values; no capture occurs). |
| total_duties | Calculated duties in the presentment currency (if applicable). |
| total_shipping | Calculated shipping amount in the presentment currency. |
| total_discounts | Total discounts applied (order-level and line-item), in the presentment currency. |
| total_price | Calculated order total after discounts, taxes, duties, and shipping, in the presentment currency. |
| total_refunds | Total refunded amount. Skipped charges typically show 0. |
| note_attributes | Key-value metadata on the charge (e.g., app/workflow tags or custom flags). |
| note | Free-form note associated with the charge (merchant-authored or system-generated). |
| created_at | Timestamp when the charge record was created in Recharge. |
| updated_at | Timestamp of the most recent update to the charge record (e.g., when it was marked skipped). |
| merged_at | Timestamp if this charge was merged with another charge (rare for skipped charges). |
| discount_id | Internal ID of any discount that would have applied. |
| discount_code | Discount code that would have applied (if any). |
| shipping_lines | Details of the shipping method and rate calculated for the charge (no fulfillment occurs). |
| error | Error details. Skipped charges are not errors; this is typically blank unless an error preceded the skip. |
| last_charge_attempt_date | Date of the last attempt, if any. Skipped charges usually have no attempts. |
| error_type | Categorized error reason. Usually blank for skipped charges. |
| number_times_tried | Number of payment attempts. Skipped charges typically show 0. |
| retry_date | Next retry date. Not applicable for skipped charges unless a workflow reschedules them. |
| Customer’s email address associated with the charge. | |
| billing_first_name | Billing contact’s first name. |
| billing_last_name | Billing contact’s last name. |
| billing_company | Company name on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (apartment, suite, unit; optional). |
| billing_city | Billing city. |
| billing_province | Billing state/province/region. |
| billing_zip | Billing postal/ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if provided). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (apartment, suite, unit; optional). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state/province/region. |
| shipping_zip | Shipping postal/ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if provided). |
| store_subtotal_price | Item subtotal in your store currency before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes in your store currency. |
| store_total_duties | Total duties in your store currency. |
| store_total_discounts | Total discounts in your store currency. |
| store_total_price | Calculated total after discounts, taxes, duties, and shipping in your store currency. |
| store_line_items_price | Sum of line item prices in your store currency. |
| store_total_shipping | Shipping total in your store currency. |
| store_total_refunds | Refund total in your store currency (typically 0 for skipped charges). |
| store_currency | Your store’s base currency (ISO code, e.g., USD, CAD, GBP). |
| currency_conversion_rate_presentment_to_store | Rate used to convert from the presentment currency (customer-facing) to your store currency. |
| currency_conversion_rate_presentment_to_usd | Rate used to convert from the presentment currency to USD. |
| usd_total_price | Calculated total converted to USD. |
| presentment_currency | Currency displayed to the customer for this charge (ISO code). |
| is_gift | Indicates whether the charge was for a gift purchase (true/false). |
Credits
Credit - Adjustments
Use this export to review all credit adjustments made to customer credit accounts.
This export can help you track credit increases and decreases, validate customer balances, and support accounting or customer service workflows.
View available columns
Header |
Definition |
| credit_adjustment_id | A unique string of numbers that identifies a specific credit adjustment. |
| credit_account_id | A unique string of numbers that identifies a specific customer credit account. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| amount | The monetary value of the credit adjustment based on the adj_type. |
| currency_code | The currency in which the adjustment amount is denominated, such as USD, EUR, etc. This is the store's deafult currency. |
| ending_balance | The balance of the credit account after the specific adjustment was created. |
| adj_type | The type of credit adjustment being made. Possible values are 'credit' indicating an increase or 'debit' indicating a decrease in the credit. |
| note | An optional internal note for source, categorizing or recording the reason. |
| created_at | The date the credit adjustment was created. |
| reference_type |
An indicator of the origin or nature of the credit adjustment, linking it to other records in the system, such as flow nodes, charges, etc. This column is blank if you manually adjusted the customer's credit. |
| reference_id |
A unique string of numbers that identifies another record based on the reference_type. This column is blank if you manually adjusted the customer's credit. |
| created_by | The identifier for the user or system that created the credit adjustment. |
Credit - Accounts
Use this export to review all customer credit accounts in Recharge.
View available columns
Header |
Definition |
| id | Credit account id. A unique string of numbers that identifies a specific customer credit account. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| name | Name of credit that is issued to the customer. For example, "Reward Credit" displays for reward type credits and "Customer Support" displays for manually issued credits. |
| credit_type |
Type of credit issued. Currently, the following credit types are available:
|
| created_at | The date the credit was created. |
| expires_at | The date the credit is expected to expire if an expiration date was set. |
| initial_value | The amount of the first credit_adjustment if set on credit account creation. |
| available_value | Amount of credits available on the credit account. |
Customers
Customers exports help you review customer records, customer status, payment tokens, and shipping addresses.
Customer in segment
Use this export for identifying customers who belong to a specific specific segment based on shared attributes or behaviors.
View available columns
Specify the customer segment using the Customer segment name drop-down menu.
Header |
Definition |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| first_name | The customer’s first name listed on the subscription. |
| last_name | The customer’s last name. |
| The email address associated with the subscription. | |
accepts_marketing |
Indicates whether the customer accepts email marketing. A 1 present in the column indicates that the customer accepts marketing. |
created_at |
The date the customer was created. |
external_customer_id |
A unique string of numbers assigned by your platform to identify each customer. |
| hash | The unique customer portal URL for the customer |
| orders_count | The total number of orders that the customer has received for their subscription |
number_active_subscriptions |
This is the number of subscriptions that the customer is currently paying for. |
number_subscriptions |
This is the total number of subscriptions that have existed for this customer. |
streak_of_uncancelled_charges |
Total number of subscription charges successfully processed without customer cancellation. |
total_subscription_spend_store_currency |
Total customer subscription spend, including taxes and shipping. |
credits_total_balance |
Current available credit balance per customer. |
first_charge_processed_at |
The date that first charge was processed for the specific customer. |
card_error_in_dunning |
Indicates if the customer is having issues with their payment processing successfully. |
| sms_transactional_consent | Indicates whether the customer has consented to receive transactional SMS messages, such as order confirmations, shipping updates, and other account- or subscription-related notifications. |
| sms_marketing_consent | Indicates whether the customer has consented to receive marketing SMS messages, such as promotional campaigns, product announcements, and other non-transactional communications. |
Customer in flow
Use this export for identifying customers who are currently active in a specific workflow or automation flow.
View available columns
To access customer data, you need to provide the flow ID, which appears at the end of the URL for any experience you’ve created.
Header |
Definition |
| customer id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| flow id | Refers to the unique identifier of a specific experience or flow that a customer interacts with. |
| first name | The customer’s first name listed on the subscription. |
| last name | The customer’s last name. |
| The email address associated with the subscription. | |
flow_state |
The outcome of the customer’s interaction with the flow. It typically reflects whether the experience completed successfully or encountered an issue. |
started at |
The exact timestamp when the customer began the flow. |
Customers
Use this export to review all customer records in your store.
View available columns
Header |
Definition |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| first_name | The customer’s first name listed on the subscription. |
| last_name | The customer’s last name. |
| The email address associated with the subscription. | |
accepts_marketing |
Indicates whether the customer accepts email marketing. A 1 present in the column indicates that the customer accepts marketing. |
| created_at | The date the customer account was first created. |
external_customer_id |
A unique string of numbers assigned by your platform to identify each customer. |
| hash | The unique customer portal URL for the customer |
| orders_count | The total number of orders that the customer has received for their subscription |
number_active_subscriptions |
This is the number of subscriptions that the customer is currently paying for. |
number_subscriptions |
This is the total number of subscriptions that have existed for this customer. |
streak_of_uncancelled_charges |
Total number of subscription charges successfully processed without customer cancellation. |
total_subscription_spend_store_currency |
Total customer subscription spend, including taxes and shipping. |
credits_total_balance |
Current available credit balance per customer. |
first_charge_processed_at |
The date that first charge was processed for the specific customer. |
card_error_in_dunning |
Indicates if the customer is having issues with their payment processing successfully. |
| sms_transactional_consent | Indicates whether the customer has consented to receive transactional SMS messages, such as order confirmations, shipping updates, and other account- or subscription-related notifications. |
| sms_marketing_consent | Indicates whether the customer has consented to receive marketing SMS messages, such as promotional campaigns, product announcements, and other non-transactional communications. |
Customers - active
Use this export to review customers with active subscriptions.
View available columns
Header |
Definition |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| first_name | The customer’s first name listed on the subscription. |
| last_name | The customer’s last name. |
| The email address associated with the subscription. | |
accepts_marketing |
Indicates whether the customer accepts email marketing. A 1 present in the column indicates that the customer accepts marketing. |
| created_at | The date the customer account was first created. |
external_customer_id |
A unique string of numbers assigned by your platform to identify each customer. |
| hash | The unique customer portal URL for the customer |
| orders_count | The total number of orders that the customer has received for their subscription |
number_active_subscriptions |
This is the number of subscriptions that the customer is currently paying for. |
number_subscriptions |
This is the total number of subscriptions that have existed for this customer. |
streak_of_uncancelled_charges |
Total number of subscription charges successfully processed without customer cancellation. |
total_subscription_spend_store_currency |
Total customer subscription spend, including taxes and shipping. |
credits_total_balance |
Current available credit balance per customer. |
first_charge_processed_at |
The date that first charge was processed for the specific customer. |
card_error_in_dunning |
Indicates if the customer is having issues with their payment processing successfully. |
Customers - payment tokens
Use this export to review stored payment token data for customers.
View available columns
Header |
Definition |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| first_name | The customer’s first name listed on the account. |
| last_name | The customer’s first name listed on the account. |
| The email address associated with the account. | |
| external_customer_id | A unique string of numbers assigned by your platform to identify each customer. |
| hash | The unique customer portal URL for the customer |
| accepts_marketing | Indicates whether the customer accepts email marketing. A 1 present in the column indicates that the customer accepts marketing. |
| orders_count | The total number of orders that the customer has received for their subscription |
| number_active_subscriptions | This is the number of subscriptions that the customer is currently paying for. |
| number_subscriptions | This is the total number of subscriptions that have existed for this customer. |
| first_charge_processed_at | The date that first charge was processed for the specific customer. |
| card_error_in_dunning | Indicates if the customer is having issues with their payment processing successfully. |
| stripe_customer_token | The customer's Stripe payment token. |
| encrypted_customer_token | An ciphered representation of the customer token. |
| paypal_customer_token | The customer's PayPal payment token. |
| authorizedotnet_customer_token | The customer's Authorize.net payment token. |
| created_at | The date the customer account was first created. |
Customers - shipping addresses
Use this export to review customer shipping addresses.
Addresses reference the Customer ID only. Run the Customers export if you need the full customer record.
View available columns
Header |
Definition |
| address_id | A unique string of numbers used to identify the customer’s subscription. This is also referred to as the Purchase ID. Individual products within a subscription will also be assigned a unique purchase_items_id. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| discount_id | When a discount code is applied to a charge, a unique string of numbers is attributed to the code being used. The ID identifies a specific discount code used on a single charge. |
shipping_first_name |
The customer’s first name listed on the subscription. |
shipping_last_name |
The customer’s last name. |
| company | The customer’s company. |
| address_1 | The customer’s street address. This address may be different than the billing address if the person receiving the subscription and the cardholder live at different addresses. |
| address_2 | Any additional address information such as apartment number or specific mailbox. This field is not mandatory. |
| city | The city where the subscriber is located. |
| province | The customer's state or province. |
| zip | The customer’s zip or postal code. |
| country | The country where the subscriber is located. |
| phone | The phone number of the person receiving the subscription. This is helpful if there are any problems with shipping or delivery. |
| cart_note | The note that that will be passed to the “note” field of orders made within the address. |
| note_attributes | Extra information that is added to the order. Each array entry will contain “name” and “value” keys. |
shipping_lines_override |
If a manual shipping override is present, the name, code, and price of the shipping rate appear here. However, this field may also include dynamic rates in some cases. To confirm whether a manual rate is set, check that shipping_manually_set is true. |
| created_at | The date the customer account was first created. |
shipping_manually_set |
'1' indicates a shipping rate override is in effect |
| presentment_currency | Currency that the customer checked out with. |
| store_currency | The store’s main currency. |
| delivery_method | A JSON field that has the delivery method and the external_location_id. The location ID will only contain a value if the delivery method is local delivery or pickup. |
| is_gift | If the value is True, this means the customer is a gift recipient and the existing address is where they redeemed their gift. |
Discounts
Use this export to review discounts created in Recharge.
View available columns
Header |
Definition |
| discount_id | When a discount code is applied to a charge, a unique string of numbers is attributed to the code being used. The ID identifies a specific discount code used on a single charge. |
| code | The discount code created in the merchant portal. |
| discount_type | Indicates what type of discount the customer will be receiving, such as a fixed amount, percentage, or shipping discount. |
| value | The total amount/percentage that the customer saves by using the discount. |
| starts_at | The date that discount is able to be applied. |
| ends_at | The date that the discount is no longer able to be applied. |
| status | Indicates whether the discount is enabled or disabled. |
| times_used | The total times that the discount code has been used by all customers. |
| usage_limit | How many times in total that the discount code can be used by all customers. |
applies_to_resource |
Identifies whether a discount code is set for a specific product or collection. |
| applied_to_id | The product or collections id the discount can be applied to. |
applies_to_product_type |
Indicates if a discount is applied to all products, subscription products, or one-time products. |
once_per_customer |
Indicates if the discount applies once per customer. |
| duration | Indicates if the discount is a single-use code or if it can be applied multiple times. |
duration_usage_limit |
Indicates the number of times a discount code can be applied in total |
prerequisite_subtotal_min |
Indicates the minimum order amount required for a discount code to be applied. |
first_time_customer_restriction |
Indicates if the discount is only available to first-time customers. |
| created_at | The date the discount was created. |
channel_settings_json |
The channels the discount can be applied. If a channel is enabled, it will display as true. |
Emails
Use this export to review emails sent from your store through Recharge notifications Only one month of data is available for this export.
View available columns
Header |
Definition |
| email_id | A unique string of numbers that identifies a notification ID associated with a specific customer or order email. |
| type | The category of notification. For example, charge confirmation or card decline. This also includes workflow_inline, which represents emails triggered by Recharge Workflows (such as Failed Payment Recovery, Cancellation Prevention, Automate, or Rewards) |
| from_email | The email of the sender. |
| from_name | The name of the sender. |
| to_email | The email of the receiver. |
| send_at | The date the email is scheduled to send. |
| sent_at | The date the email was sent. |
| purchase_id | The purchase ID. |
| bcc_emails | A list of emails that were BCCed. |
| cc_emails | A list of emails that were CCed. |
| created_at | The date the email was first created. |
Events
Use this export to review activity performed on orders, addresses, and other supported records. The Events export supports a maximum date range of 90 days.
Events reference customers by ID only. Run the Customers export if you need additional customer details.
View available columns
Header |
Definition |
| event_id | A unique string of numbers associated with a specific event performed on a customer account. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| object_id | The specific identifier of the object or location. For example, if an event occurred on a charge, the charge ID is recorded. |
| object_class | The object, or location, of the recorded event. For example, checkout, address, or order. |
| verb | The action performed on the object or location. For example, if a charge does not process due to a card error, it will display failed. |
| The email address that performed the specific action. | |
| source | Indicates the source of the action. For example, customer or store admin. |
| description | A description of the event or action that took place. |
| changes | If a change or action was made. |
| created_at | The date the event occurred. |
Gifts
Use this export to review gift subscription activity.
Gift purchases
View available columns
Header |
Definition |
| gift_purchase_id | A unique identifier assigned to the purchase transaction of the gift subscription. |
gift_credit_account_id |
The unique identifier for the credit account associated with the gift. |
gift_external_product_id |
The eCommerce platform product ID for the individual gift within the order. |
| gift_external_variant_id | The eCommerce platform variant ID for the individual gift product within the order. |
| gift_note | A personal message or note included by the sender for the recipient. |
recipient_customer_id |
The unique identifier assigned to the recipient's customer account within Recharge. |
recipient_email |
The email address of the gift recipient. |
redeemable_collection_id |
The identifier for the collection of products that the recipient can choose from when redeeming the gift. |
| redeemable_external_product_id | The identifier of the specific product that the recipient can redeem, as recognized in your eCommerce platform. |
| sender_customer_id | The unique identifier assigned to the sender's customer account within Recharge. |
sender_external_order_line_item_id |
The identifier for the specific line item in the sender's order, as recognized in your eCommerce platform. |
| sender_external_order_id | The identifier for the sender's order in your eCommerce platform. |
| sender_name | The full name of the individual who purchased and sent the gift. |
sender_email |
The email address of the sender. |
notification_scheduled_at |
The identifier for the scheduled notification to the recipient about the gift. |
| notification_sent_at | The timestamp indicating when the notification was sent to the recipient. |
redeemed_at |
The timestamp indicates when the recipient redeemed the gift. |
created_at |
The timestamp the charge was created. |
| updated_at | The timestamp indicating the most recent change made to the charge. |
One-time
Use this export to review all non-subscription products queued by Recharge.
One-time exports reference customers and addresses only by ID. Run the Customers or Addresses export if you need additional record details.
View available columns
Header |
Definition |
| onetime_id | A unique string of numbers that is given to each product in a customer’s subscription. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| customer_email | The email address associated with the account. |
| address_id | A unique string of numbers used to identify the customer’s subscription. This is also referred to as the Purchase ID. Individual products within a subscription will also be assigned a unique purchase_items_id. |
| status | The type of product. For example, one-time. |
| product_title | The title of the subscription product. |
| variant_title | The title of the specific variant that the subscriber is subscribed to. |
| price | The price the customer paid for their subscription product when they checked out. The price paid at checkout might differ from the recurring price if a discount code was used, or if a free trial workflow is implemented. |
| quantity | The number of products ordered. |
external_product_id |
A unique string of numbers that is used to identify the product that is listed on the subscription. |
external_variant_id |
A unique string of numbers that is used to identify the specific variant on the subscription. Even if a product does not have any variants created in your eCommerce platform, it will still have one variant ID assigned. Recharge uses the variant ID to create each charge. |
| properties | Line item properties are custom forms on a product used to collect additional customization information. |
| created_at | The date the product was added. |
| deleted_at | This column displays the date and time in the event that a product is completely deleted from a customer’s account. |
| updated_at | If a change or action was made to the product, the change date will be reflected in this column. |
| presentment_currency | Currency that the customer checked out with. |
| store_currency | The store’s main currency. |
Orders
Orders exports help you review order activity across multiple statuses.
Date range limits:
- Up to 90 days for future orders
- Up to 1 year for processed orders
Orders exports reference customers and addresses by ID. Run the Customers or Addresses export if you need additional record details.
Orders exports can also include line item columns when you need item-level reporting.
Order exports let you choose whether to include line item columns, which export each individual line item as its own row. Selecting Include line item columns is useful when you need detailed, item-level data for each product within a charge or order. Instead of a single row summarizing the entire charge, this option creates a separate row for every item included.
Available line item columns
Header |
Definition |
| line_item_title | Product title for the line item within the order. |
| line_item_variant_title | Variant or option name for the line item (for example, size or flavor). |
| line_item_quantity | Number of units for this line item in the order. |
| line_item_external_product_id | Commerce platform product ID for this line item (for example, Shopify product ID). |
| line_item_external_variant_id | Commerce platform variant ID for this line item (for example, Shopify variant ID). |
| line_item_properties | Custom key–value properties associated with the line item (for example, personalization, bundle selections, or upsells). |
| line_item_sku | SKU used for inventory and fulfillment for this line item. |
| line_item_original_price | Per-unit price before any discounts, in the presentment currency. |
| line_item_price | Line item total after per-line discounts (original price × quantity − line discounts). This amount excludes order-level discounts, taxes, duties, and shipping. |
| line_item_subscribe_and_save_discount | Discount amount applied to the line item due to a Subscribe & Save or recurring discount. |
| line_item_purchase_item_type | Purchase type for the line item (for example, subscription, one_time, prepaid, or add_on). |
| line_item_subscription_id | Associated Subscription ID when the line item belongs to a subscription or prepaid cycle. This field is blank for one-time items. |
Orders - cancelled
Use this export to review cancelled orders between the selected start and end dates.
View available columns
Note that addresses and customers are referenced only by their Address and Customer IDs, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| order_id | Unique identifier for the order record in Recharge. |
| charge_id | Unique identifier for the charge that created this order. |
| multiple_rows | Indicates that the order spans multiple rows in the export (one row per line item). Order-level fields repeat on each row. |
| address_id | Unique identifier for the customer’s subscription address associated with the order. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email address. |
| external_order_id | The commerce platform’s internal order ID (e.g., Shopify order ID) for this order. |
| external_order_number | The order number as shown in your commerce platform’s admin (e.g., #1001). |
| is_prepaid | Indicates whether the order is part of a prepaid subscription cycle (true/false). |
| type | Order type, such as recurring (subscription order) or one-time (add-on). |
| status | Current order status. For this export the value is typically cancelled. |
| pending_status_reason | If the order was pending before cancellation, the reason (e.g., awaiting creation, inventory checks). |
| scheduled_at | Date and time the order was scheduled to process. |
| processed_at | Date and time the order processed, if it reached processing before being cancelled. Often blank. |
| cancelled_at | Date and time the order was cancelled in Recharge. |
| cancel_reason | Reason the order was cancelled (e.g., customer request, inventory, voided payment). |
| subtotal_price | Total value of items before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax applied to the order, in the presentment currency. |
| total_duties | Total duties applied to the order (if applicable), in the presentment currency. |
| total_discounts | Total value of discounts (order-level and line-item), in the presentment currency. |
| total_price | Grand total after discounts, taxes, duties, and shipping, in the presentment currency. |
| note_attributes | Key-value metadata associated with the order (e.g., custom attributes from apps/workflows). |
| note | Free-form note attached to the order (merchant-authored or system-generated). |
| created_at | Timestamp when the order record was created in Recharge. |
| updated_at | Timestamp of the most recent update to the order record. |
| discount_code | Discount code applied to the order (if any). |
| shipping_lines | Details about shipping lines for the order (method, title, and amount breakdown). |
| error | Human-readable error message if the order encountered an error leading up to or during cancellation. |
| Customer’s email address associated with the order. | |
| billing_first_name | Cardholder’s first name on the billing address. |
| billing_last_name | Cardholder’s last name on the billing address. |
| billing_company | Company name on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (apartment, suite, unit; optional). |
| billing_city | Billing city. |
| billing_province | Billing state/province/region. |
| billing_zip | Billing postal/ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if provided). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (apartment, suite, unit; optional). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state/province/region. |
| shipping_zip | Shipping postal/ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if provided). |
| store_subtotal_price | Item subtotal converted to your store currency, before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes in your store currency. |
| store_total_duties | Total duties in your store currency. |
| store_total_discounts | Total discounts in your store currency. |
| store_total_price | Grand total in your store currency after discounts, taxes, duties, and shipping. |
| store_line_items_price | Sum of line-item prices in your store currency (typically before order-level adjustments). |
| total_shipping | Shipping charged for the order in the presentment currency. |
| store_total_shipping | Shipping total converted to your store currency. |
| currency_conversion_rate_presentment_to_store | Exchange rate used to convert from the customer’s presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Exchange rate used to convert from the presentment currency to USD. |
| usd_total_price | Order total converted to USD using the presentment→USD rate. |
| presentment_currency | Currency shown to the customer for this order (ISO code). |
| store_currency | Your store’s base currency used for reporting (ISO code). |
| is_gift | Indicates whether the order was a gift purchase (true/false). |
Orders - errors
Use this export to identify orders that encountered errors during processing, so you can review and resolve issues.
View available columns
Note that addresses and customers are referenced only by their Address and Customer IDs, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| order_id | Unique identifier for the order record in Recharge. |
| charge_id | Unique identifier for the charge that created this order. |
| multiple_rows | Indicates that the same order appears across multiple rows in the export (for example, when multiple line items exist). Order-level fields repeat on each row. |
| address_id | Unique identifier for the address associated with the order. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email address. |
| external_order_id | Commerce platform’s internal order ID (for example, Shopify order ID) for the cancelled or expired order. |
| external_order_number | Order number as displayed in the connected commerce platform (for example, #1001). |
| is_prepaid | Indicates whether this order was part of a prepaid subscription cycle (true/false). |
| type | Type of order, such as recurring (subscription) or one-time (add-on). |
| status | Current order status. For this export, the status is typically cancelled or expired. |
| pending_status_reason | Reason the order was pending before cancellation or expiration (for example, awaiting inventory or payment). |
| scheduled_at | Date and time the order was originally scheduled to process. |
| processed_at | Date and time the order was processed, if applicable. |
| cancelled_at | Date and time the order was cancelled or marked expired in Recharge. |
| cancel_reason | Reason the order was cancelled or expired (for example, failed payment, expired subscription, or merchant action). |
| subtotal_price | Item total before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax applied to the order, in the presentment currency. |
| total_duties | Total duties applied to the order (if applicable), in the presentment currency. |
| total_discounts | Total discounts applied (order-level and line-item), in the presentment currency. |
| total_price | Total amount of the order after discounts, taxes, duties, and shipping, in the presentment currency. |
| note_attributes | Key-value metadata attached to the order (for example, workflow tags or app data). |
| note | Free-form note associated with the order (merchant-authored or system-generated). |
| created_at | Timestamp when the order record was created in Recharge. |
| updated_at | Timestamp of the most recent update to the order record. |
| discount_code | Discount code applied to the order, if applicable. |
| shipping_lines | Details about the shipping method(s) and associated cost for the order. |
| error | Error message generated by the system or payment gateway, if any, before cancellation or expiration. |
| Customer’s email address associated with the order. | |
| billing_first_name | First name on the billing address. |
| billing_last_name | Last name on the billing address. |
| billing_company | Company name on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (for example, apartment or suite number). |
| billing_city | Billing city. |
| billing_province | Billing state, province, or region. |
| billing_zip | Billing postal or ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if provided). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (apartment, suite, or unit; optional). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state, province, or region. |
| shipping_zip | Shipping postal or ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if provided). |
| store_subtotal_price | Item subtotal in your store currency before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes in your store currency. |
| store_total_duties | Total duties in your store currency. |
| store_total_discounts | Total discounts in your store currency. |
| store_total_price | Grand total in your store currency after discounts, taxes, duties, and shipping. |
| store_line_items_price | Sum of all line item prices in your store currency (before adjustments). |
| total_shipping | Shipping charged for the order in the presentment currency. |
| store_total_shipping | Total shipping converted to your store currency. |
| currency_conversion_rate_presentment_to_store | Exchange rate used to convert from the customer’s presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Exchange rate used to convert from the presentment currency to USD. |
| usd_total_price | Order total converted to USD using the presentment-to-USD rate. |
| presentment_currency | Currency displayed to the customer for this order (ISO code). |
| store_currency | Your store’s base currency used for reporting (ISO code). |
| is_gift | Indicates whether this order was purchased as a gift (true/false). |
Orders - pending
Use this export to review pending orders between the selected start and end dates.
View available columns
Header |
Definition |
| order_id | A unique string of numbers given to each order. The order ID is used to reference a specific order. |
| charge_id | A unique string of numbers given to each charge. The charge ID is used to reference a specific charge. |
| multiple_rows |
If this value is false, there is a single line item within the charge. If the value is true, multiple line item rows are available for this charge. The rows will share the same id as well as all fields except fields staring with line_item_. This is to provide line item level information for each charge. |
| address_id | A unique string of numbers used to identify the customer’s subscription. This is also referred to as the Purchase ID. Individual products within a subscription will also be assigned a unique purchase_items_id. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| external_order_id | A unique string of numbers that corresponds to the order created in your eCommerce platform for fulfillment. Generally, this information is only used by your eCommerce platform’s API to create the order. |
external_order_number |
The corresponding order created in your eCommerce platform once the order in Recharge was processed. |
| is_prepaid | If the product is a prepaid product (ships more frequently than it is charged), the column will indicate a 1. |
| type | The source of the order submitted. For example, checkout or recurring. |
| status | Lists the status of the order. |
| scheduled_at | Indicates the date the order is scheduled to be submitted to your eCommerce platform. |
| processed_at | Indicates the date the order was submitted to your eCommerce platform. |
| cancelled_at | The date the order was canceled. |
| cancel_reason | The reason the order was canceled. |
| subtotal_price | The price of the order, before taxes, shipping, or discounts. |
| total_taxes | Total combined tax amount on the order. |
| total_discounts | The total discount amount attached to the order. |
| total_price | The total price, including taxes, shipping, or discounts. |
| note_attributes | Extra information that is added to the order. Each array entry must contain a dictionary with “name” and “value” keys. |
| note | The note that that is passed to the “note” field of orders made within the address. |
| created_at | The date the order was created. |
| updated_at | If a change was made to the subscription or order, it will be reflected in this column. |
| discount_code | A specific string of text, numbers, or a combination of both, that customers can use to receive their subscription at a reduced cost. |
| shipping_lines | The original shipping rate that was paid when the customer checked out. If the shipping settings are configured to retain the original rate for shipping on each order, our system references this data when each charge is created to ensure the original shipping lines are displayed. However, we do not reference this data if the shipping rates are dynamically recalculated on each charge. |
| error | If an order has an error, the error reason will be listed here. |
| The email address associated with the subscription. | |
billing_first_name |
The cardholder’s first name. |
billing_last_name |
The cardholder’s last name. |
| billing_company | The cardholder’s company name. This field is not mandatory. |
| billing_address1 | The street address of the cardholder. This address can be different than the shipping address if the customer has purchased the product for someone else. |
| billing_address2 | Any additional address information such as apartment number or specific mailbox. This field is not mandatory. |
| billing_city | The city the cardholder lives in. |
| billing_province | The cardholder’s state or province. |
| billing_zip | The cardholder’s zip or postal code. |
| billing_country | The country the cardholder lives in. |
| billing_phone | The cardholder’s phone number. |
shipping_first_name |
The first name of the person receiving the subscription product. |
shipping_last_name |
The subscriber’s last name. |
shipping_address1 |
The subscriber’s street address. This address may be different than the billing address if the person receiving the subscription and the cardholder live at different addresses. |
shipping_address2 |
Any additional address information such as apartment number or specific mailbox. This field is not mandatory. |
shipping_company |
The subscriber’s company. |
| shipping_city | The city where the subscriber is located. |
shipping_province |
The subscriber’s state or province. |
| shipping_zip | The subscriber’s zip or postal code. |
| shipping_country | The country where the subscriber is located. |
| shipping_phone | The phone number of the person receiving the subscription. This is helpful if there are any problems with shipping or delivery. |
| line_item_title | The title of the individual product within the order. |
line_item_variant_title |
The variant title of the individual variant product within the order. |
line_item_quantity |
The amount of the individual product within the order. |
line_item_external_product_id |
The eCommerce platform product ID for the individual product within the order. |
line_item_external_variant_id |
The eCommerce platform variant ID for the individual product within the order. |
line_item_properties |
This column displays any line item properties associated with the individual product within the order. |
| line_item_sku | The individual product SKU within the order. |
| line_item_price | The individual product price within the order. |
| line_item_purchase_item_type | The type of item within the charge. |
| line_item_subscription_id | The subscription ID within the charge. |
| store_currency | The store’s main currency |
| total_duties | Duties displayed in presentment currency. |
| store_total_duties | Total duties displayed in store currency. |
| store_subtotal_price | Subtotal is displayed in store currency. |
| store_total_taxes | Taxes are displayed in store currency. |
| store_total_discounts | Discounts displayed in store currency. |
| store_total_price | Price displayed in store currency. |
| store_line_item_price | Line items displayed in store currency. |
| store_total_shipping | Shipping displayed in store currency. |
| store_total_refunds | Refunds displayed in store currency. |
| currency_conversion_rate_presentment_to_store | Currency conversion rate from presentment currency to store currency. |
| currency_conversion_rate_presentment_to_usd | Currency conversion rate from presentment currency to USD. |
| usd_total_price | Total pricing converted into USD. |
| presentment_currency | The currency the customer checked out with. |
Orders - prepaid processed
Use this export for reviewing prepaid subscription orders that have already been processed, including details on fulfilled prepaid cycles.
View available columns
Header |
Definition |
| order_id | Unique identifier for the order record in Recharge. |
| charge_id | Unique identifier for the charge that generated this order. |
| multiple_rows | Indicates that the order spans multiple rows in the export (for example, when multiple line items are included). Order-level data repeats on each row. |
| address_id | Unique identifier for the customer’s address associated with the order. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email address. |
| external_order_id | Commerce platform’s internal order ID (for example, Shopify order ID) created for this prepaid order. |
| external_order_number | Order number as displayed in your commerce platform’s admin (for example, #1001). |
| is_prepaid | Indicates whether the order is part of a prepaid subscription cycle (true for this export). |
| type | Type of order, such as recurring (subscription) or one-time (add-on). |
| status | Current order status. For this export, the value is typically processed. |
| pending_status_reason | Reason the order was pending before processing (for example, queued for prepaid fulfillment). |
| scheduled_at | Date and time when the order was scheduled to process as part of the prepaid cycle. |
| processed_at | Date and time the order was successfully processed and sent to the connected platform. |
| cancelled_at | Date and time the order was cancelled, if applicable. Typically blank for processed orders. |
| cancel_reason | Reason the order was cancelled, if applicable. Typically empty for processed orders. |
| subtotal_price | Total value of items before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax amount applied to the order, in the presentment currency. |
| total_duties | Total duties applied to the order (if applicable), in the presentment currency. |
| total_discounts | Total discounts applied to the order, in the presentment currency. |
| total_price | Grand total after discounts, taxes, duties, and shipping, in the presentment currency. |
| note_attributes | Key-value metadata associated with the order (for example, app tags or workflow notes). |
| note | Free-form note associated with the order (merchant-authored or system-generated). |
| created_at | Timestamp when the order record was created in Recharge. |
| updated_at | Timestamp when the order record was last updated. |
| discount_code | Discount code applied to the order, if applicable. |
| shipping_lines | Details about the shipping method(s) used, including carrier and rate. |
| error | Error message returned from the payment processor or platform, if any, during processing. |
| Customer’s email address associated with the order. | |
| billing_first_name | First name on the billing address. |
| billing_last_name | Last name on the billing address. |
| billing_company | Company name listed on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (for example, apartment or suite number). |
| billing_city | Billing city. |
| billing_province | Billing state, province, or region. |
| billing_zip | Billing postal or ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if available). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (apartment, suite, or unit; optional). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state, province, or region. |
| shipping_zip | Shipping postal or ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if available). |
| store_subtotal_price | Item subtotal in your store currency before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes converted to your store currency. |
| store_total_duties | Total duties converted to your store currency. |
| store_total_discounts | Total discounts converted to your store currency. |
| store_total_price | Grand total in your store currency after discounts, taxes, duties, and shipping. |
| store_line_items_price | Sum of all line item prices in your store currency before adjustments. |
| total_shipping | Shipping total for the order in the presentment currency. |
| store_total_shipping | Total shipping converted to your store currency. |
| currency_conversion_rate_presentment_to_store | Exchange rate used to convert the customer’s presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Exchange rate used to convert from the presentment currency to USD. |
| usd_total_price | Order total converted to USD using the presentment-to-USD exchange rate. |
| presentment_currency | Currency displayed to the customer for this order (ISO code). |
| store_currency | Your store’s base currency used for reporting (ISO code). |
| is_gift | Indicates whether the order was purchased as a gift (true/false). |
Orders - prepaid queued
Use this export to review upcoming prepaid shipment orders between the selected start and end dates.
View available columns
Header |
Definition |
| order_id | Unique identifier for the order record in Recharge. |
| charge_id | Unique identifier for the charge that generated this prepaid order. |
| multiple_rows | Indicates that the order spans multiple rows in the export (for example, when multiple line items exist). Order-level data repeats on each row. |
| address_id | Unique identifier for the customer’s address associated with this order. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email address. |
| external_order_id | Commerce platform’s internal order ID (for example, Shopify order ID). Queued orders typically have this field blank until processed. |
| external_order_number | Commerce platform’s order number (for example, #1001). Usually empty for queued prepaid orders. |
| is_prepaid | Indicates that the order is part of a prepaid subscription cycle (true for this export). |
| type | Type of order, such as recurring (subscription) or one-time (add-on). |
| status | Current order status. For this export, the value is typically queued. |
| pending_status_reason | Reason the order is queued (for example, upcoming shipment in a prepaid cycle, or awaiting processing date). |
| scheduled_at | Date and time when the queued order is scheduled to process. |
| processed_at | Date and time the order was processed. Blank for queued orders that have not yet been processed. |
| cancelled_at | Date and time the order was cancelled, if applicable. Typically blank for queued orders. |
| cancel_reason | Reason the order was cancelled, if applicable. Usually empty for queued orders. |
| subtotal_price | Item subtotal before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax amount calculated for the order, in the presentment currency. |
| total_duties | Total duties calculated for the order (if applicable), in the presentment currency. |
| total_discounts | Total discounts applied to the order, in the presentment currency. |
| total_price | Grand total after discounts, taxes, duties, and shipping, in the presentment currency. |
| note_attributes | Key-value metadata associated with the order (for example, app data, workflow notes, or tags). |
| note | Free-form note attached to the order (merchant-authored or system-generated). |
| created_at | Timestamp when the order record was created in Recharge. |
| updated_at | Timestamp when the order record was last updated. |
| discount_code | Discount code applied to the order, if any. |
| shipping_lines | Details about shipping method(s) associated with the order, including title, carrier, and rate. |
| error | Error message generated before processing, if applicable. Typically blank for queued prepaid orders. |
| Customer’s email address associated with the order. | |
| billing_first_name | First name on the billing address. |
| billing_last_name | Last name on the billing address. |
| billing_company | Company name on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (for example, apartment or suite number). |
| billing_city | Billing city. |
| billing_province | Billing state, province, or region. |
| billing_zip | Billing postal or ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if provided). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (apartment, suite, or unit; optional). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state, province, or region. |
| shipping_zip | Shipping postal or ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if provided). |
| store_subtotal_price | Item subtotal in your store currency before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes converted to your store currency. |
| store_total_duties | Total duties converted to your store currency. |
| store_total_discounts | Total discounts converted to your store currency. |
| store_total_price | Grand total in your store currency after discounts, taxes, duties, and shipping. |
| store_line_items_price | Sum of all line item prices in your store currency before adjustments. |
| total_shipping | Shipping total for the order in the presentment currency. |
| store_total_shipping | Shipping total converted to your store currency. |
| currency_conversion_rate_presentment_to_store | Exchange rate used to convert from the customer’s presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Exchange rate used to convert from the presentment currency to USD. |
| usd_total_price | Order total converted to USD using the presentment-to-USD rate. |
| presentment_currency | Currency displayed to the customer for this order (ISO code). |
| store_currency | Your store’s base currency used for reporting (ISO code). |
| is_gift | Indicates whether the order was purchased as a gift (true/false). |
Orders - processed
Use this export to review successfully processed orders between the selected start and end dates.
View available columns
Header |
Definition |
| order_id | Unique identifier for the order record in Recharge. |
| charge_id | Unique identifier for the charge that created this order. |
| multiple_rows | Indicates that the order spans multiple rows in the export (for example, when multiple line items are present). Order-level data repeats on each row. |
| address_id | Unique identifier for the customer’s address associated with the order. |
| customer_id | Unique identifier for the customer in Recharge, tied to their email address. |
| external_order_id | Commerce platform’s internal order ID (for example, Shopify order ID) for this processed order. |
| external_order_number | Order number displayed in your commerce platform (for example, #1001). |
| is_prepaid | Indicates whether the order is part of a prepaid subscription cycle (false for standard processed orders). |
| type | Type of order, such as recurring (subscription) or one-time (add-on). |
| status | Current status of the order. For this export, the value is typically processed. |
| pending_status_reason | If applicable, reason the order was previously pending (for example, awaiting creation or fulfillment). |
| scheduled_at | Date and time when the order was scheduled to process. |
| processed_at | Date and time when the order was successfully processed and sent to the connected commerce platform. |
| cancelled_at | Date and time the order was cancelled, if applicable. Typically blank for processed orders. |
| cancel_reason | Reason the order was cancelled, if applicable. Typically blank for processed orders. |
| subtotal_price | Total value of items before discounts, taxes, and shipping, in the presentment currency. |
| total_taxes | Total tax amount applied to the order, in the presentment currency. |
| total_duties | Total duties applied to the order (if applicable), in the presentment currency. |
| total_discounts | Total amount of discounts applied (both order-level and line-item), in the presentment currency. |
| total_price | Grand total after discounts, taxes, duties, and shipping, in the presentment currency. |
| note_attributes | Key-value metadata associated with the order (for example, app tags, custom workflow data, or fulfillment notes). |
| note | Free-form note attached to the order (merchant-authored or system-generated). |
| created_at | Timestamp when the order record was created in Recharge. |
| updated_at | Timestamp when the order record was last updated. |
| discount_code | Discount code applied to the order, if any. |
| shipping_lines | Details about the shipping method(s) applied to the order, including carrier name, rate, and title. |
| error | Error message from the system or payment processor, if applicable. Typically blank for processed orders. |
| Customer’s email address associated with the order. | |
| billing_first_name | First name on the billing address. |
| billing_last_name | Last name on the billing address. |
| billing_company | Company name listed on the billing address (if provided). |
| billing_address1 | Billing street address line 1. |
| billing_address2 | Billing street address line 2 (for example, apartment, suite, or unit; optional). |
| billing_city | Billing city. |
| billing_province | Billing state, province, or region. |
| billing_zip | Billing postal or ZIP code. |
| billing_country | Billing country. |
| billing_phone | Billing phone number (if provided). |
| shipping_first_name | Recipient’s first name on the shipping address. |
| shipping_last_name | Recipient’s last name on the shipping address. |
| shipping_address1 | Shipping street address line 1. |
| shipping_address2 | Shipping street address line 2 (for example, apartment or suite number; optional). |
| shipping_company | Company name on the shipping address (if provided). |
| shipping_city | Shipping city. |
| shipping_province | Shipping state, province, or region. |
| shipping_zip | Shipping postal or ZIP code. |
| shipping_country | Shipping country. |
| shipping_phone | Shipping phone number (if provided). |
| store_subtotal_price | Item subtotal converted to your store currency, before discounts, taxes, and shipping. |
| store_total_taxes | Total taxes converted to your store currency. |
| store_total_duties | Total duties converted to your store currency. |
| store_total_discounts | Total discounts converted to your store currency. |
| store_total_price | Grand total in your store currency after discounts, taxes, duties, and shipping. |
| store_line_items_price | Sum of all line item prices in your store currency (before adjustments). |
| total_shipping | Shipping total for the order in the presentment currency. |
| store_total_shipping | Shipping total converted to your store currency. |
| currency_conversion_rate_presentment_to_store | Exchange rate used to convert the customer’s presentment currency to your store currency. |
| currency_conversion_rate_presentment_to_usd | Exchange rate used to convert from the presentment currency to USD. |
| usd_total_price | Order total converted to USD using the presentment-to-USD exchange rate. |
| presentment_currency | Currency displayed to the customer for this order (ISO code). |
| store_currency | Your store’s base currency used for reporting (ISO code). |
| is_gift | Indicates whether this order was purchased as a gift (true/false). |
Payment Methods - All
Use this export to review the payment methods and their related processor gateways for your store customers.
This export references customers only by ID. Run the Customers export if you need additional customer details.
View available columns
Header |
Definition |
| payment_method_id | A unique identifier assigned to the cardholder's payment method that is used to reference the payment method in Recharge's database. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| processor_name | The name of the payment processor or gateway handling the transaction. |
| processor_payment_method_token | A unique string of characters the payment processor generates which represents the cardholder's payment method. |
| processor_customer_token | A unique identifier generated by the payment processor that represents a specific customer. |
| status | The status of the payment method, such as VALID, DUMMY, or INVALID. |
| status_reason | Additional information that provides context for the current status of a payment method. |
| payment_type | Indicates the payment method the cardholder used. |
| default | Indicates if the payment method used is the default payment method on file for the customer. |
| payment_details | Detailed information about the payment method, including the card type, the last four digits of the credit card used, and the expiry date. |
| billing_first_name | The cardholder’s first name. |
| billing_last_name | The cardholder’s last name. |
| billing_address_1 | The customer’s street address. This address may differ from the billing address if the person receiving the subscription and the cardholder live at different addresses. |
| billing_address_2 | Any additional address information such as apartment number or specific mailbox. This field is not mandatory. |
| billing_company | The cardholder’s company name. This field is not mandatory. |
| billing_phone | The cardholder’s phone number. |
| billing_province | The cardholder’s state or province. |
| billing_city | The city the cardholder lives in. |
| billing_postal_code | The cardholder’s zip or postal code. |
| billing_country_code | A two-letter code indicating the cardholder's country. |
| created_at | The date and time a customer's payment method was created. |
| updated_at | The date and time a customer's payment method was updated. |
| deleted_at | The date and time if a payment method is deleted from a customer’s account. |
Products
Use this export to review products available in Recharge.
View available columns
Header |
Definition |
| recharge_product_id | Unique numeric identifier of the product in Recharge. |
external_product_id |
A unique string of numbers that is used to identify the product that is listed on the subscription, from your eCommerce platform. |
| title | The title of the subscription product. |
| handle | The handle in the product URL. |
products_are_subscription_only |
Indicates whether a product is available only on subscription. If it is only available as a subscription, a 1 will be indicated in this column. If it is available as subscription and one-time, a 0 will be indicated in this column. |
discount_amount |
The discount percentage amount on the subscription. For example, if you offer 10% off for signing up for a subscription, 10 would be indicated in this column. |
expire_after_specific_number_of_charges |
The number of charges before the subscription expires. |
charge_interval_frequency |
The numerical value of how often the product is charged, depending on what is configured in the ruleset. For example, if a product was configured to charge every three months, the charge_interval_frequency value would be 3. |
order_interval_frequency |
The numerical value of how often the product is shipped, depending on what is configured in the ruleset. For example, if a product was configured to ship every month, the value here would be 1. |
order_interval_unit |
The period of time in which the product is shipped as configured in the ruleset. For example, if a product was configured to ship every month, the value would be "month." |
cutoff_day_of_month |
The specific day of the month that the customer needs to order the product by, as configured in the ruleset. |
cutoff_day_of_week |
The specific day of the week that customer needs to order the product by, as configured in the ruleset. |
modifiable_properties |
List of modifiable line item properties on the product as set by the store. |
order_day_of_month |
The specific day of the month that the product is submitted to your eCommerce platform on a recurring basis. |
order_day_of_week |
The specific day of the week that the product is submitted to your eCommerce platform on a recurring basis. |
order_interval_frequency_options |
List of order interval frequency options that customers can choose from. For example, order_interval_unit=month and order_interval_frequency_option for 3 would be an order every 3 months |
| created_at | The date the product was added to the ruleset. |
| updated_at | Indicates the most recent update date to the product in the ruleset. |
Product tax codes
Use this export to review or audit the tax codes assigned to products, ensuring accurate tax calculations and compliance across your catalog.
View available columns
Header |
Definition |
| product_id | The unique identifier for the product in Recharge. |
| variant_id | The unique identifier for the product variant associated with the tax code. |
| tax_code | The tax code assigned to the product or variant, used for calculating sales tax during checkout. |
Plans
Use this export to review plan configuration details created in Recharge.
View available columns
Header |
Definition |
| id | Unique numeric identifier of the plan in Recharge. |
external_product_id |
A unique string of numbers used to identify the product that is listed on the subscription, from your eCommerce platform. |
sort_order |
Indicates the order the plan is listed when listed with related plans. |
type |
The type of plan, either subscription, prepaid, or one-time. |
| title | The title of the plan. |
interval_unit |
The period of time in which the product is shipped as configured in the ruleset. For example, if a product was configured to ship every month, the value would be "month." |
order_interval_frequency |
The numerical value of how often the product is shipped, depending on what is configured in the ruleset. For example, if a product was configured to ship every month, the value here would be 1. |
charge_interval_frequency |
The numerical value of how often the product is charged, depending on what is configured in the ruleset. For example, if a product was configured to charge every three months, the charge_interval_frequency value would be 3. |
channel_settings |
The supported channels where the plan is available. |
discount_amount |
The discount percentage amount on the subscription. For example, if you offer 10% off for signing up for a subscription, 10 would be indicated in this column. |
cutoff_day_of_month |
The specific day of the month that the customer needs to order the product by, as configured in the ruleset. |
cutoff_day_of_week |
The specific day of the week that customer needs to order the product by, as configured in the ruleset. |
expire_after_specific_number_of_charges |
The number of charges before the subscription expires. |
order_day_of_week |
The specific day of the week that the plan is submitted to your eCommerce platform on a recurring basis. |
order_day_of_month |
The specific day of the month that the plan is submitted to your eCommerce platform on a recurring basis. |
external_plan_group_id |
The unique selling plan group id that appears in external platforms. |
external_plan_id |
The unique selling plan id that appears in external platforms. |
external_plan_name |
The name of the plan as it appears in external platforms. |
| apply_cutoff_date_to_checkout | This column is for future UI additions and can be left blank. |
recurring_discount_type |
Indicates what type of discount the customer will be receiving, such as a fixed amount, percentage, or shipping discount. |
| recurring_discount_amount | The discount percentage amount on the subscription. For example, if you offer 10% off for signing up for a subscription, 10 would be indicated in this column. |
| recurring_discount_after_cycle | This column is for future UI additions and can be left blank. |
| has_variant_restrictions | Indicates if the plan applies to specific variants of the product. |
| external_variant_ids |
A list of variant ids for the product as they appear in external platforms.
Note: The external_variant_ids column applies only to variant-level plans and contains data only when a plan is limited to specific variants.
|
| created_at | The plan creation date. |
| updated_at | The most recent date the plan was updated at. |
Subscriptions
Subscriptions exports help you review subscription records across different statuses.
Subscriptions reference customers and addresses by ID. Run the Customers or Addresses export if you need additional record details.
Subscriptions - Active
Use this export to review all active subscriptions.
View available columns
Header |
Definition |
| subscription_id | Unique identifier for the subscription in Recharge. |
| customer_id | Unique identifier for the customer tied to the subscription, based on their email address. |
| customer_email | The customer’s email address associated with this active subscription. |
| status | The current status of the subscription. For this export, the status is typically active. |
| product_title | The name of the subscribed product as it appears in the merchant’s store. |
| variant_title | The variant or option of the subscribed product (for example, size or flavor). |
| recurring_price | The recurring price per unit for the subscription product in the presentment currency. |
| quantity | The number of product units included in the subscription. |
| external_product_id | The commerce platform’s unique product ID (for example, Shopify’s product ID). |
| external_variant_id | The commerce platform’s unique variant ID (for example, Shopify’s variant ID). |
| order_interval_frequency | The numeric frequency of recurring orders (for example, every 30 days or every 2 months). |
| charge_interval_frequency | The numeric frequency at which charges are generated for the subscription. |
| order_interval_unit | The unit of time used for the interval (for example, day, week, month). |
| created_at | The date and time the subscription was created in Recharge. |
| address_id | Unique identifier for the subscription’s associated address in Recharge. |
| price | Total price for the subscription line item, based on recurring price × quantity. |
| sku |
The product’s stock keeping unit (SKU) used to track inventory in your store. This is not the product SKU of the subscription product. This column only populates when the sku_override has been applied to the subscription. If no override is set, this column is blank. Shopify Checkout Integration stores shouldn't use SKU overrides, since Shopify manages SKU values directly. |
| sku_override | If enabled, this overrides the default SKU for the subscription item (used for custom logic or fulfillment). |
| expire_after_specific_number_of_charges | Specifies whether the subscription automatically expires after a set number of charges. Blank if it renews indefinitely. |
| charge_day_of_month | The day of the month on which the charge is generated for the subscription (for example, 15). |
| charge_day_of_week | The day of the week the subscription charge occurs (for example, Monday). |
| properties | Custom line item properties or attributes associated with the subscription (for example, personalization or bundle details). |
| cancelled_at | The date and time the subscription was cancelled, if applicable. Blank for active subscriptions. |
| cancellation_reason | Reason for cancellation selected by the customer or merchant (for example, “too expensive”). Blank for active subscriptions. |
| cancellation_reason_comments | Free-form text comment provided at cancellation. Blank for active subscriptions. |
| deleted_at | Timestamp when the subscription was permanently deleted, if applicable. Blank for active subscriptions. |
| updated_at | The most recent timestamp when the subscription record was updated (for example, due to address, quantity, or interval change). |
| presentment_currency | The currency shown to the customer for this subscription (ISO code). |
| store_currency | The store’s base currency used for reporting and internal calculations (ISO code). |
| is_gift | Indicates whether the subscription was purchased as a gift (true/false). |
Subscriptions - All
Use this export to review all subscriptions regardless of status.
View available columns
Note that addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| subscription_id | Unique identifier for the subscription in Recharge. |
| customer_id | Unique identifier for the customer tied to the subscription, based on their email address. |
| customer_email | The customer’s email address associated with this active subscription. |
| status | The current status of the subscription. For this export, the status is typically active. |
| product_title | The name of the subscribed product as it appears in the merchant’s store. |
| variant_title | The variant or option of the subscribed product (for example, size or flavor). |
| recurring_price | The recurring price per unit for the subscription product in the presentment currency. |
| quantity | The number of product units included in the subscription. |
| external_product_id | The commerce platform’s unique product ID (for example, Shopify’s product ID). |
| external_variant_id | The commerce platform’s unique variant ID (for example, Shopify’s variant ID). |
| order_interval_frequency | The numeric frequency of recurring orders (for example, every 30 days or every 2 months). |
| charge_interval_frequency | The numeric frequency at which charges are generated for the subscription. |
| order_interval_unit | The unit of time used for the interval (for example, day, week, month). |
| created_at | The date and time the subscription was created in Recharge. |
| address_id | Unique identifier for the subscription’s associated address in Recharge. |
| price | Total price for the subscription line item, based on recurring price × quantity. |
| sku |
The product’s stock keeping unit (SKU) used to track inventory in your store. This is not the product SKU of the subscription product. This column only populates when the sku_override has been applied to the subscription. If no override is set, this column is blank. Shopify Checkout Integration stores shouldn't use SKU overrides, since Shopify manages SKU values directly. |
| sku_override | If enabled, this overrides the default SKU for the subscription item (used for custom logic or fulfillment). |
| expire_after_specific_number_of_charges | Specifies whether the subscription automatically expires after a set number of charges. Blank if it renews indefinitely. |
| charge_day_of_month | The day of the month on which the charge is generated for the subscription (for example, 15). |
| charge_day_of_week | The day of the week the subscription charge occurs (for example, Monday). |
| properties | Custom line item properties or attributes associated with the subscription (for example, personalization or bundle details). |
| cancelled_at | The date and time the subscription was cancelled, if applicable. Blank for active subscriptions. |
| cancellation_reason | Reason for cancellation selected by the customer or merchant (for example, “too expensive”). Blank for active subscriptions. |
| cancellation_reason_comments | Free-form text comment provided at cancellation. Blank for active subscriptions. |
| deleted_at | Timestamp when the subscription was permanently deleted, if applicable. Blank for active subscriptions. |
| updated_at | The most recent timestamp when the subscription record was updated (for example, due to address, quantity, or interval change). |
| presentment_currency | The currency shown to the customer for this subscription (ISO code). |
| store_currency | The store’s base currency used for reporting and internal calculations (ISO code). |
| is_gift | Indicates whether the subscription was purchased as a gift (true/false). |
Subscriptions - All - by creation date
Use this export to review all subscriptions organized by creation date.
View available columns
Addresses and customers are referenced only by their ids. You may need the Customers and Addresses exports for additional data.
Header |
Definition |
| subscription_id | Unique numeric identifier for the subscription. |
| customer_id | A unique string of numbers that identifies a specific customer and is tied specifically to their email address. Even if a customer has multiple subscriptions listed under one email address, they will still only have one Customer ID. |
| customer_email | The email address associated with the subscription. |
| address_id | A unique string of numbers used to identify the customer’s subscription. This is also referred to as the Purchase ID. Individual products within a subscription will also be assigned a unique purchase_items_id. |
| status | The status of the subscription, such as ACTIVE or INACTIVE. |
| product_title | The title of the subscription product. |
| variant_title | The title of the specific variant that the subscriber is subscribed to. |
| recurring_price | The recurring cost for the subscription product. |
| price | The price the customer paid for their subscription product when they checked out. The price paid at checkout might differ from the recurring price if a discount code was used, or if a free trial workflow is implemented. |
| quantity | This is the number of products ordered. |
external_product_id |
A unique string of numbers that is used to identify the product that is listed on the subscription. |
external_variant_id |
A unique string of numbers that is used to identify the specific variant on the subscription. Even if a product does not have any variants created in your eCommerce platform, it still will have one variant ID assigned. Recharge uses the variant ID to create each charge. |
| sku |
Populated if `sku_override`is set. This is not the product SKU of the subscription product. If no override is set, this column is blank. Shopify Checkout Integration stores shouldn't use SKU overrides, since Shopify manages SKU values directly. |
| sku_override | If a SKU override is in place, this column will show the actual SKU that was used to create the charge. Retrieved from `general_arttributes[sku_override]` |
expire_after_specific_number_of_charges |
If the product is in a ruleset that is configured to expire after a certain amount of charges, this column will show how many charges are left until the subscription is automatically cancelled. |
order_interval_frequency |
The numerical value of how often the product is shipped. For example, if a product was configured to ship every month, the value would be "1." |
charge_interval_frequency |
The numerical value of how often the product is charged, depending on what is configured in the ruleset. For example, if a product was configured to charge every month, the value would be "1." |
order_interval_unit |
The period of time in which the product is shipped as. For example, if a product was configured to ship every month, the value would be "month." |
charge_day_of_month |
The specific day of the month that the customer is charged for their subscription on a recurring basis. |
charge_day_of_week |
The specific day of the week that the customer is charged for their subscription on a recurring basis. |
| properties | This column displays any line item properties that were sent through with the order. Line item properties are custom forms on a product used to collect additional customization information. |
| cancelled_at | The date the customer canceled their subscription. |
cancellation_reason |
The reason the product has been canceled from the customer's subscription. This can be selected by the store owner, customer, or automatically by Recharge (e.g. max retries reached). |
cancellation_reason_comments |
Submitted comments as to why the product was canceled. |
| created_at | The date the subscription was added to the account. |
| deleted_at | This column displays the date and time in the event that a product is completely deleted from a customer’s account. |
| updated_at | If a change is made to a subscription, the most recent update date will be indicated in this column. |
| presentment_currency | Currency that the customer checked out with. |
| store_currency | The store’s main currency. |
Subscriptions - Cancelled
Use this export to review cancelled subscriptions.
View available columns
Note that addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| subscription_id | Unique identifier for the subscription in Recharge. |
| customer_id | Unique identifier for the customer tied to the subscription, based on their email address. |
| customer_email | The customer’s email address associated with the subscription. |
| status | Current status of the subscription. For this export, the status is typically cancelled. |
| product_title | The name of the product associated with the cancelled subscription. |
| variant_title | The variant or option of the cancelled product (for example, size or flavor). |
| recurring_price | The recurring price per unit for the subscription product, in the presentment currency, before cancellation. |
| quantity | The number of product units included in the subscription. |
| external_product_id | The commerce platform’s unique product ID (for example, Shopify’s product ID). |
| external_variant_id | The commerce platform’s unique variant ID (for example, Shopify’s variant ID). |
| order_interval_frequency | The numeric frequency of recurring orders (for example, every 30 days or every 2 months). |
| charge_interval_frequency | The numeric frequency at which charges were generated before cancellation. |
| order_interval_unit | The unit of time used for the order interval (for example, day, week, month). |
| cancelled_at | The date and time the subscription was cancelled in Recharge. |
| cancellation_reason | The predefined cancellation reason selected by the customer or merchant (for example, “too expensive” or “no longer needed”). |
| cancellation_reason_comments | Free-form text provided by the customer or merchant explaining why the subscription was cancelled. |
Subscriptions - Expired
Use this export to review expired subscriptions.
View available columns
Note that addresses and customers are referenced only by their ids, so you may need the Customers and Addresses exports for additional data.
Header |
Definition |
| subscription_id | Unique identifier for the subscription in Recharge. |
| customer_id | Unique identifier for the customer tied to the subscription, based on their email address. |
| customer_email | The customer’s email address associated with the expired subscription. |
| status | The current status of the subscription. For this export, the value is typically expired. |
| product_title | The name of the product associated with the expired subscription. |
| variant_title | The variant or option of the expired product (for example, size or flavor). |
| recurring_price | The recurring price per unit for the subscription product, in the presentment currency, before expiration. |
| quantity | The number of product units included in the subscription. |
| external_product_id | The commerce platform’s unique product ID (for example, Shopify’s product ID). |
| external_variant_id | The commerce platform’s unique variant ID (for example, Shopify’s variant ID). |
| order_interval_frequency | The numeric frequency of recurring orders (for example, every 30 days or every 2 months). |
| charge_interval_frequency | The numeric frequency at which charges were generated before expiration. |
| order_interval_unit | The unit of time used for the order interval (for example, day, week, month). |
| created_at | The date and time the subscription was created in Recharge. |
