Collapse Menu
Docs Home
Developer Tools
Contact Support

Data Exports

Overview

Access and run data exports.

Use Data Exports for information that is not available in Orders, Subscriptions, or Events reports.

Export Data

  1. In the FastSpring App, navigate to Reports > Data Exports.
  2. Click Create Data Export to open the Create Data Export page.
  3. In the Name field, enter a name to distinguish the export in the list of historical exports.
  4. In the Date and Number Formatting drop-down, select a country for your preferred formatting of dates and numbers.
    • For example: If you select English, dates will be expressed as MM/DD/YYYY and decimals will be expressed using periods (e.g., $123.45). If you select German, dates will be expressed as DD/MM/YYYY and decimals will be expressed using the comma separator (e.g., $123,45).
  5. In the Site field, select the Store whose data you want to export.
  6. In the Date Range From and To drop-downs, select the time frame of activity to include. All dates in the FastSpring App are based on UTC/GMT - 0.
  7. In the Report Type drop-down, select the type of data that you want to export.
    • A variety of pre-defined exports are available to run based on the selected Date Range.
    • The Order Reports - Custom (CSV) and Order Reports - Custom (Text) sections show custom data exports that you previously created in your Store and did not delete.
  8. Click Create.
  9. The page will refresh to the list of Available Data Exports with a message that your new export is processing. The page will automatically refresh every 20 seconds until your export is ready.

After your new export is ready, use the buttons in the Actions column to download, preview on your screen, or permanently delete any export in the list. You can also mouse over the i icon to the right of each export Description to see which user created the export and when the user created it.

Chargeback Ratio Report

Follow instructions to export data and select Order Item Export (CSV) in the Report Type drop-down.

The report includes granular details about Purchase events, Return events, and Return-Dispute events.
Chargebacks that have been completed in our system are listed as Return-Dispute events.

Custom Data Export

For advanced users, use New CSV Template or New Text Template to create a custom data export with more control over exactly which fields or columns appear in your export.

The following example applies to the New CSV Template option but the process is similar for both CSV and Text Templates.

  1. Follow instructions to export data and select New CSV Template in the Report Type drop-down.
  2. In the Custom Report CSV Columns field, enter a column heading for each data point you want to include in the export, separated by commas.
    • For example: If you want to include the order reference, order date, local currency amount for the order, and the USD amount for the order, enter the following:
      Custom Report CSV Columns example
      	Reference,Date,,Amount,Amount(USD)
      

       Regarding #{order.created}

      If you select English for the Date and Number Formatting field and you need to use the #{order.created} variable to insert the order date, include two commas after the column heading rather than one. In the output, the year will be in a separate column, and the extra comma in the list of headings allows everything to be properly aligned.
  3. In the text area labeled Custom Report Template, specify the object name of each data point to include in the export, separated by commas. Use the "order" hyperlink located just below the text area to open a Help window with a list of available order attributes.
  4. To continue the example above, you would enter the following:
    Custom Report Template example
    	#{order.id},#{order.created},#{order.subTotal},#{order.subTotalUSD} 
  5. Important:  Press ENTER at the end of your line of column variables to move your cursor down to the next line so the system knows the last column in the row has been reached.
  6. Click Create.

Try FastSpring

Get a free account and see why FastSpring is the ecommerce partner of choice for software providers around the world. Try our full-service ecommerce solution today to unlock revenue growth for your online company.