Data Exports
You can export data from your store that is not available in Orders, Subscriptions, and Events pages.
Export Data
- Navigate to Reports > Data Exports.
- Click Create Data Export. The configuration page opens.
- Enter a Name for the export. This will appear in the list of historical exports.
- In the Date and Number Formatting drop-down, select a region. FastSpring will use this to apply the appropriate number and date formatting.
- In the Site field, select the store that you want to export data from.
- In the Date Range drop downs, specify the time frame from which you would like to export data. The available exports will vary based on the selected date range.
- If you have previously created data exports, FastSpring will display those in the Order Reports – Custom (CSV) and Order Reports – Custom (Text) sections.
- Click Create. FastSpring will display the list of available data exports with a message that your export is processing.
After you export the data, you can download, preview, or permanently delete it from the Actions column. Hover over the i icon to the right of each description to see the creator and creation date.
Customize Your Data Export
Use the New CSV Template or the New Text Template to create a customized data export. This gives you more control over the fields and columns that appear in the export.
- Create a new data export.
- In the Report Type field, select New CSV Template or New Text Template. Additional fields appear.
- If you selected New CSV Template, add a column heading for each data point you want to include in the export to the Custom Report CSV Columns field. Separate each heading by commas.
- Example: Reference,Date,Amount,Amount(USD)
- In the Custom Report Template field, specify the object name of each data point to include in the export, separated by commas.
- Click order below the text area to access a list of available order attributes.
- Example: #{order.id},#{order.created},#{order.subTotal},#{order.subTotalUSD}
- Click Create.
Exposed Parameters:
Click on the drop-downs below to view all possible exposed parameters.
Order Items
| accountUrl: | #{order.accountUrl} | URL of the customer account associated with the order. |
| activeReview: | #{order.activeReview} | True if the order is under review. |
| address: | #{order.address.___} | Customer address associated with the order. |
| address1 | #{order.address.address1} | First line of the customer address. |
| address2 | #{order.address.address2} | Second line of the customer address. |
| city | #{order.address.city} | City. |
| country | #{order.address.country} | Country. |
| countryDisplay | #{order.address.countryDisplay} | Country formatted for display. |
| postalCode | #{order.address.postalCode} | Postal code. |
| region | #{order.address.region} | State (for US addresses). |
| regionDisplay | #{order.address.regionDisplay} | State (for US addresses) formatted for display. |
| allItems | <repeat value=”#{order.allItems}” var=”orderItem”> #{orderItem.___} </repeat> | All order items. |
| allProductNames | <repeat value=”#{order.allProductNames}” var=”value”> #{value} </repeat> | All product names. |
| baseItems | <repeat value=”#{order.baseItems}” var=”orderItem”> #{orderItem.___} </repeat> | Base order items. |
| baseProductNames | <repeat value=”#{order.baseProductNames}” var=”value”> #{value} </repeat> | Product names of base items associated with the order. |
| billDescriptor | #{order.billDescriptor} | Bill descriptor for the order. |
| coupons | <repeat value=”#{order.coupons}” var=”value”> #{value} </repeat> | All coupons used for the order. |
| created | #{order.created} | Order creation date. |
| currency | #{order.currency} | ISO code of the currency associated with the order. |
| customList | #{order.customList} | Custom list associated with the order. |
| customTagsList | #{order.customTagsList} | List of order level custom tags/attributes. key=value comma separated |
| customer | #{order.customer.___} | Customer contact information. |
| customerReference | #{order.customerReference} | Order reference number. |
| discountTotal | #{order.discountTotal} | Total of discounts applied, if any. |
| discountTotalUSD | #{order.discountTotalUSD} | USD total of discounts applied, if any. |
| due | #{order.due} | Payment due date. |
| hasActiveReview | #{order.hasActiveReview} | This is true if the order is in the review status. |
| hasCustomTagsJson | #{order.hasCustomTagsJson} | This is true if the order contains custom JSON tags. |
| hasEmailFulfillment | #{order.hasEmailFulfillment} | This is true if you configure an email fulfillment for one or more products in the order. |
| hasPayPalPayment | #{order.hasPayPalPayment} | This is true if the customer paid with PayPal. |
| hasSource | #{order.hasSource} | This is true if source information is available. |
| hasSurveyFields | #{order.hasSurveyFields} | This is true if the order has survey fields. |
| hasTax | #{order.hasTax} | This is true if FastSpring charged tax to the order. |
| hasUSTax | #{order.hasUSTax} | This is true if FastSpring applied US sales tax to the order. |
| hasVAT | #{order.hasVAT} | This is true if FastSpring applied VAT to the order. |
| httpReferrer | #{order.httpReferrer} | HTTP referrer associated with the order. |
| Id | #{order.id} | Order ID number. |
| isEmbedded: | #{order.isEmbedded} | This is true if the order is embedded. |
| isFree | #{order.isFree} | This is true if the customer does not owe any money for the order. |
| isGift | #{order.isGift} | This is true for gift purchases. |
| isProcessing | #{order.isProcessing} | This is true if the order is pending. |
| isRebill | #{order.isRebill} | This is true for subscription rebills. |
| isReturned | #{order.isReturned} | This is true if the customer received the return. |
| isTest | #{order.isTest} | This is true for test orders. |
| language | #{order.language} | ISO code of the order language. |
| notify | #{order.notify.___} | Customer contact information. |
| offerNames | <repeat value=”#{order.offerNames}” var=”value”>#{value}</repeat> | Names of all product offers associated with the order. |
| originIp | #{order.originIp} | IP address associated with the order. |
| payments | <repeat value=”#{order.payments}” var=”payment”> #{payment.___} </repeat> | Successful payments within the order |
| purchaserAddress | #{order.purchaserAddress.___} | Customer’s physical address. |
| purchaserContact | #{order.purchaserContact.___} | Customer’s contact information |
| referrer | #{order.referrer} | Referrer that originated the order. |
| shippingTotal | #{order.shippingTotal} | Total shipping fees applied to the order. |
| shippingTotalUSD | #{order.shippingTotalUSD} | USD total of shipping fees applied to the order. |
| siteDisplay | #{order.siteDisplay} | Display name of the site that the order originated from. |
| siteMainUrl | #{order.siteMainUrl} | Landing page URL of the website associated with the order. |
| siteName | #{order.siteName} | Website name associated with the order. |
| siteSupportEmail | #{order.siteSupportEmail} | Email address of the support team associated with the order. |
| sourceCampaign | #{order.sourceCampaign} | Order source campaign. |
| sourceKey | #{order.sourceKey} | Order source key. |
| sourceName | #{order.sourceName} | Order source name. |
| status | #{order.status} | Status of the order. |
| statusChange | #{order.statusChange} | Date and time that the status last changed. If the status is completed, then this is the date / time of completion. |
| subTotal | #{order.subTotal} | Order subtotal. |
| subTotalUSD | #{order.subTotalUSD} | Order subtotal, in USD. |
| surveyFieldValues | #{order.surveyFieldValues.___} | Survey field values mapped by the name / key provided. |
| surveyFields | <repeat value=”#{order.surveyFields}” var=”surveyField”> #{surveyField.___} </repeat> | Survey fields associated with the order |
| tagNameString | #{order.tagNameString} | String version of tag names. |
| tagString | #{order.tagString} | String version of tag names and tag values. |
| tags | #{order.tags.___} | Mapping of tag names to tag values. |
| tax | #{order.tax} | US sales tax, EU VAT tax, or Japanese Consumption Tax. |
| taxUSD | #{order.taxUSD} | USD value of the US sales tax, VAT, or Japanese Consumption Tax. |
| total | #{order.total} | Order total. |
| totalUSD | #{order.totalUSD} | Order total, in USD. |
| type | #{order.type} | Type of order. |
| url | #{order.url.___} | URL of the order. |
| visibleItems | <repeat value=”#{order.visibleItems}” var=”orderItem”> #{orderItem.___} </repeat> | all order items visible to the consumer |
Subscription Variables
| accountUrl | #{subscription.accountUrl} | URL of the customer account. |
| attributes | #{subscription.attributes} | Subscription attributes |
| beginDate | #{subscription.beginDate} | First full day the subscription is considered active. |
| coupon | #{subscription.coupon} | Coupon code currently assigned to the subscription. |
| customer | #{subscription.customer.___} | Customer contact information. |
| display | #{subscription.display} | Customer-facing display name of the subscription. |
| endDate | #{subscription.endDate} | Subscription expiration date. After this day, FastSpring will cancel the subscription. This only applies to subscriptions with a fixed number of rebills, or if someone cancels it. |
| hasPaymentMethod | #{subscription.hasPaymentMethod} | This is true if the subscription has an associated payment method. |
| hasSource | #{subscription.hasSource} | This is true if source information is available. |
| isTest | #{subscription.isTest} | This is true for test subscription orders. |
| nextDunningStep | #{subscription.nextDunningStep} | The next billing. |
| nextDunningStepDate | #{subscription.nextDunningStepDate} | Date of the next billing. |
| nextPeriodDate | #{subscription.nextPeriodDate} | Date of the next rebill period. |
| notify | #{subscription.notify.___} | Customer contact information. |
| paymentExpiresBeforeRenewalDate | #{subscription.paymentExpiresBeforeRenewalDate} | True if the payment method expires before the next rebill. |
| paymentMethodExpirationDate | #{subscription.paymentMethodExpirationDate} | Expiration date of the payment method associated with the subscription. |
| productDisplay | #{subscription.productDisplay} | Display name of the product associated with the subscriptions. |
| productName | #{subscription.productName} | Subscription’s product name. |
| productPath | #{subscription.productPath}; | Subscription’s product path. |
| quantity | #{subscription.quantity} | Quantity of the subscription in the order. |
| reference | #{subscription.reference} | Unique API reference key. |
| referrer | #{subscription.referrer} | Custom referrer / identifier associated with the subscription. |
| siteName | #{subscription.siteName} | Name of the website associated with the subscription. |
| sourceCampaign | #{subscription.sourceCampaign} | |
| sourceKey | #{subscription.sourceKey} | Source key associated with the subscription. |
| sourceName | #{subscription.sourceName} | Source name of the subscription. |
| status | #{subscription.status} | Current status of the subscription |
| statusReason | #{subscription.statusReason} | Current reason for the subscription status, if any. |
| successfulPeriodCount | #{subscription.successfulPeriodCount} | Number of successful rebills. |
| tagNameString | #{subscription.tagNameString} | String version of tag names. |
| tagString | #{subscription.tagString}; | String version of tag names and tag values. |
| tags | #{subscription.tags.___} | Mapping of tag names to tag values. |
| terms | #{subscription.terms} | Terms of the subscription. |
| totalPrice | #{subscription.totalPrice} | Total rebill amount. |
| url | #{subscription.url.___} | URL of the subscription. |
Return Variables
| address | #{return.address.___} | Address associated with the return. |
| allItems | <repeat value=”#{return.allItems}” var=”returnItem”> #{returnItem.___} </repeat> | All items included in the return. |
| allProductNames | <repeat value=”#{return.allProductNames}” var=”value”> #{value} </repeat> | Names of all products in the return. |
| baseItems | <repeat value=”#{return.baseItems}” var=”returnItem”> #{returnItem.___} </repeat> | Products included in the return. |
| baseProductNames | <repeat value=”#{return.baseProductNames}” var=”value”> #{value} </repeat> | Names of the base products in the return. |
| created | #{return.created} | Date and time that someone created the return. |
| currency | #{return.currency} | ISO code of the associated currency. |
| customer | #{return.customer.___} | Customer contact information. |
| discountTotal | #{return.discountTotal} | Total of discounts. |
| discountTotalUSD | #{return.discountTotalUSD} | Total of discounts applied, in USD. |
| hasReview | #{return.hasReview} | |
| hasTax | #{return.hasTax} | True if FastSpring applied tax to the order. |
| hasUSTax | #{return.hasUSTax} | True if FastSpring applied US sales tax to the order. |
| hasVAT | #{return.hasVAT} | True if FastSpring applied VAT to the order. |
| id | #{return.id} | ID of the return. |
| isProcessing | #{return.isProcessing} | True if the order is pending. |
| isTest | #{return.isTest} | True for test orders. |
| notify | #{return.notify.___} | Customer’s contact information. |
| original | #{return.original.___} | Original order. |
| purchaserAddress | #{return.purchaserAddress.___} | Customer’s address. |
| purchaserContact | #{return.purchaserContact.___} | Customer contact information. |
| reasonText | #{return.reasonText} | Reason for the return. |
| review | #{return.review.___} | Review status of the return. |
| shippingTotal | #{return.shippingTotal} | Shipping charges applied to the order. |
| shippingTotalUSD | #{return.shippingTotalUSD} | Shipping charges, in USD. |
| siteDisplay | #{return.siteDisplay} | Customer-facing display name of the website where the order originated. |
| siteMainUrl | #{return.siteMainUrl} | URL of the website where the order originated. |
| siteName | #{return.siteName} | Name of the website where the order originated. |
| siteSupportEmail | #{return.siteSupportEmail} | Support email address associated with the return. |
| status | #{return.status} | Status of the return. |
| statusChange | #{return.statusChange} | Date / time that the status last changed. If the status is completed, then this is the date / time of completion. |
| subTotal | #{return.subTotal} | Subtotal |
| subTotalUSD | #{return.subTotalUSD} | Subtotal, in USD. |
| tax | #{return.tax} | US sales tax, EU VAT tax, or Japanese Consumption Tax. |
| taxUSD | #{return.taxUSD} | USD value of the US sales tax, VAT, or Japanese Consumption Tax. |
| total | #{return.total} | Total return amount. |
| totalUSD | #{return.totalUSD} | Total return amount, in USD. |
| type | #{return.type} | Type of return. |