Exporting Data

With LemonStand, you can export various parts of your store as export files (as CSV). These files can be used in Excel (or Numbers), and can connect your store with other applications. Exports are sent by email when you click the “Export” button, found on Product, Orders, and Customer listings pages in the LemonStand backend interface. Your export will be compressed as a .ZIP file, so you will need to unzip the files before using them in your favorite applications.

Exports, and General Format

You can export a number of sections of your online store, including your:

  • orders
  • products
  • customers
  • subscriptions

Each section of your store is exported as a CSV file, which is a text file with comma-separated fields. These special text files can be used in applications such as:

  • Numbers
  • Microsoft Excel
  • Google Spreadsheets
  • And other tools that understand standard CSV files

The export files contain your store’s data, organized by columns, rows, and sub-rows. The sub-rows include extra information relating to the row above it (the parent row), to track things like customer’s various addresses, and order line items. The concept of parent and child rows is an important distinction in the export files, as it makes it possible for applications like Excel (and other tools) to make sense of your store export.

Example

Let's work through an example export.

  1. Click the Export button located at the bottom right of an exportable listview, such as the Orders dashboard:

A pop-up will notify the user that an export has been successfully triggered. In the case that an error occurs, an error message will be returned.

2. When complete, an email (with the subject: “CSV Export Success”) will appear in your inbox, with a link to download.


3. Your export is complete!

Note: You can also download exports via the Audit Log. See our docs on Audit Logs for more details.

Supported Columns

CSV Order Export

Orders are represented by a single line, and line items associated with orders will be shown on subsequent lines; they will only satisfy the headers provisioned for them (currently anything prefixed with an Order Item [X]).A single set of headers will be defined for Order CSV Exports. The set of headers supported are as defined below:

Parameter
Order ID
Order #
Order Item Order ID
Date Received
Updated
First Name
Last Name
Customer Email
Status
Status Updated At
Customer ID
Is Quote
Is Tax Exempt
Total
Total Invoiced
Total Paid
Total Refunded
Subtotal Invoiced
Subtotal Paid
Subtotal Refunded
Total Discount
Total Sales Tax
Total Sales Tax Invoiced
Total Sales Tax Paid
Total Sales Tax Refunded
Total Shipping Tax
Total Shipping Tax Invoiced
Total Shipping Tax Paid
Total Shipping Tax Refunded
Total Shipping Quote
Total Shipping Invoiced
Total Shipping Paid
Total Shipping Refunded
Is Tax Exempt
Subscription ID
Billing Street Address
Billing Street Address 2
Billing City
Billing State
Billing Country
Billing Postal Code
Shipping Street Address
Shipping Street Address 2
Shipping City
Shipping State
Shipping Country
Shipping Postal Code
Order Item Product Name
Order Item Product SKU
Order Item Quantity
Order Item Price Reduction
Order Item Unit Price
Order Item Subtotal
Order Item Discount
Order Item Product ID
Order Item Product Variant ID
Order Item Tax Class

CSV Product Export

You can see full details on our product export CSV file format from our article on importing and exporting product data.

CSV Customer Export


Parameter
Customer ID
Address Customer ID
First Name
Last Name
Email
Created
Updated
Is Guest
Notes
Address First Name
Address Last Name
Address Street Address
Address Street Address 2
Address City
Address State
Address Country
Address Postal Code
Address Phone
Address Is Billing Address
Address Is Default

CSV Subscription Export


Parameter
Subscription ID
Price
Trial Length
Billing Day
Customer Id
Customer Name
Customer Email
Billing Plan Id
Date Created
Updated At
Shipping Method Id
Shipping Service
Shiping Quote
Last Invoice Date
Status
Current Status Id
Payment Method Id
Billing Status Id
Failed Payments Count
Discount
Pending Billing Plan Id